{"id":11462,"date":"2019-04-20T23:02:08","date_gmt":"2019-04-20T23:02:08","guid":{"rendered":"https:\/\/dbtut.com\/?p=11462"},"modified":"2019-04-20T23:02:09","modified_gmt":"2019-04-20T23:02:09","slug":"how-to-change-the-database-id-and-database-name-in-rac-databases","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/04\/20\/how-to-change-the-database-id-and-database-name-in-rac-databases\/","title":{"rendered":"How To Change the database id and database name in RAC Databases"},"content":{"rendered":"<p>This article describes how to change the id and name of a database that is running as RAC, what operations should be done before and after.<\/p>\n<p>In the examples, necessary steps have been performed to change the name of the database named ORCL as TEST.<\/p>\n<h2>Step 1<\/h2>\n<p>Change the value of the cluster_database parameter to false.<\/p>\n<pre class=\"lang:default decode:true \">-bash-4.3$ sqlplus \/ as sysdba\n\nSQL*Plus: Release 11.2.0.4.0 Production on Fri Oct 20 17:20:17 2017\n\nCopyright (c) 1982, 2013, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\nWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\nData Mining and Real Application Testing options\n\nSQL&gt; alter system set cluster_database=false scope=spfile sid='*';\n\nSystem altered.<\/pre>\n<h2>Step 2<\/h2>\n<p>Start database in mount mode on a node.<\/p>\n<pre class=\"lang:default decode:true\">-bash-4.3$ srvctl stop database -d ORCL\n\n\nSQL&gt; startup mount\nORACLE instance started.\n\nTotal System Global Area 3.8215E+10 bytes\nFixed Size                  2254416 bytes\nVariable Size            6979324336 bytes\nDatabase Buffers         3.1004E+10 bytes\nRedo Buffers              229019648 bytes\nDatabase mounted.<\/pre>\n<h2>Step 3<\/h2>\n<p>Change the database id and name information with the nid tool. We specify the new database name using DBNAME.<\/p>\n<pre class=\"lang:default decode:true \">-bash-4.3$ nid TARGET=sys\/welcome1@ORCL DBNAME=TEST\n\nDBNEWID: Release 11.2.0.4.0 - Production on Fri Oct 20 17:22:12 2017\n\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates.  All rights reserved.\n\nConnected to database ORCL (DBID=1485672324)\n\nConnected to server version 11.2.0\n\nControl Files in database:\n    +DATA\/orcl\/controlfile\/current.824.957891589\n    +RECO\/orcl\/controlfile\/current.49661.957891589\n\nChange database ID and database name ORCL to TEST? (Y\/[N]) =&gt; Y\n\nProceeding with operation\nChanging database ID from 1485672324 to 2256023237\nChanging database name from ORCL to TEST\n    Control File +DATA\/orcl\/controlfile\/current.824.957891589 - modified\n    Control File +RECO\/orcl\/controlfile\/current.49661.957891589 - modified\n    Datafile +DATA\/orcl\/datafile\/system.846.95789151 - dbid changed, wrote new name\n    Datafile +DATA\/orcl\/datafile\/sysaux.849.95789151 - dbid changed, wrote new name\n    Datafile +DATA\/orcl\/datafile\/undotbs1.844.95789151 - dbid changed, wrote new name\n    Datafile +DATA\/orcl\/datafile\/users.843.95789151 - dbid changed, wrote new name\n    Datafile +DATA\/orcl\/datafile\/undotbs2.880.95789161 - dbid changed, wrote new name\n    Datafile +DATA\/orcl\/tempfile\/temp.879.95789159 - dbid changed, wrote new name\n    Control File +DATA\/orcl\/controlfile\/current.824.957891589 - dbid changed, wrote new name\n    Control File +RECO\/orcl\/controlfile\/current.49661.957891589 - dbid changed, wrote new name\n    Instance shut down\n\nDatabase name changed to TEST.\nModify parameter file and generate a new password file before restarting.\nDatabase ID for database TEST changed to 2256023237.\nAll previous backups and archived redo logs for this database are unusable.\nDatabase is not aware of previous backups and archived logs in Recovery Area.\nDatabase has been shutdown, open database with RESETLOGS option.\nSuccesfully changed database name and ID.\nDBNEWID - Completed succesfully.<\/pre>\n<h2>Step 4<\/h2>\n<p>Change the value of the db_name parameter as the new database name.<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; startup mount\nORACLE instance started.\n\nTotal System Global Area 3.8215E+10 bytes\nFixed Size                  2254416 bytes\nVariable Size            6979324336 bytes\nDatabase Buffers         3.1004E+10 bytes\nRedo Buffers              229019648 bytes\nORA-01103: database name 'TEST' in control file is not 'ORCL'\n\n\nSQL&gt; alter system set db_name=TEST scope=spfile sid='*';\n\nSystem altered.\n\n\nSQL&gt; exit\nDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\nWith the Partitioning, Real Application Clusters, OLAP, Data Mining\nand Real Application Testing options<\/pre>\n<h2>Step 5<\/h2>\n<p>On all nodes, change the name of the corresponding initSID.ora file under the $ORACLE_HOME\/dbs directory to initNEWSID.ora.<\/p>\n<pre class=\"lang:default decode:true \">-bash-4.3$ cd $ORACLE_HOME\/dbs\n-bash-4.3$ mv initORCL1.ora initTEST1.ora\n\n-bash-4.3$ ssh oradb2\n-bash-4.3$ cd \/u01\/app\/oracle\/product\/11.2.0\/dbhome_1\/dbs\n-bash-4.3$ mv initORCL2.ora initTEST2.ora<\/pre>\n<h2>Step 6<\/h2>\n<p>Create the new password file and distribute it to all nodes.<\/p>\n<pre class=\"lang:default decode:true \">-bash-4.3$ cd $ORACLE_HOME\/dbs\n-bash-4.3$ orapwd file=orapwTEST1 password=welcome1 entries=10\n\n-bash-4.3$ scp orapwTEST1 oradb2:\/u01\/app\/oracle\/product\/11.2.0\/dbhome_1\/dbs\/orapwTEST2\norapwTEST1                                                                                                                                                   100% 2560     2.5KB\/s   00:00<\/pre>\n<h2>Step 7<\/h2>\n<p>Show the new database name to the listeners on all nodes.<\/p>\n<pre class=\"lang:default decode:true \">-bash-4.3$ . oraenv\nORACLE_SID = [TEST1] ? +ASM1\nThe Oracle base remains unchanged with value \/u01\/app\/oracle\n-bash-4.3$ lsnrctl reload\n\nLSNRCTL for IBM\/AIX RISC System\/6000: Version 11.2.0.4.0 - Production on 20-OCT-2017 17:35:20\n\nCopyright (c) 1991, 2013, Oracle.  All rights reserved.\n\nConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))\nThe command completed successfully<\/pre>\n<h2>Step 8<\/h2>\n<p>Start the database in mount mode with the new SID environment variables and open it as resetlogs.<\/p>\n<pre class=\"lang:default decode:true\">-bash-4.3$ . oraenv\nORACLE_SID = [TEST1] ? \nThe Oracle base remains unchanged with value \/u01\/app\/oracle\n-bash-4.3$ sqlplus \/ as sysdba\n\nSQL*Plus: Release 11.2.0.4.0 Production on Fri Oct 20 17:37:20 2017\n\nCopyright (c) 1982, 2013, Oracle.  All rights reserved.\n\nConnected to an idle instance.\n\nSQL&gt; startup mount\nORACLE instance started.\n\nTotal System Global Area 3.8215E+10 bytes\nFixed Size                  2254416 bytes\nVariable Size            4563405232 bytes\nDatabase Buffers         3.3420E+10 bytes\nRedo Buffers              229019648 bytes\nDatabase mounted.\nSQL&gt; ALTER DATABASE OPEN RESETLOGS;\n\nDatabase altered.<\/pre>\n<h2>Step 9<\/h2>\n<p>Set the cluster_database parameter to true and open the database on all nodes.<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; alter system set cluster_database=true scope=spfile sid='*';\n\nSystem altered.\n\nSQL&gt; shu immediate\nDatabase closed.\nDatabase dismounted.\nORACLE instance shut down.\nSQL&gt; exit\nDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\nWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\nData Mining and Real Application Testing options\n\n-bash-4.3$ srvctl status database -d ORCL\nInstance ORCL1 is not running on node oradb1\nInstance ORCL2 is not running on node oradb2<\/pre>\n<h2>Step 10<\/h2>\n<p>Check the current database configuration.<\/p>\n<pre class=\"lang:default decode:true \">-bash-4.3$ srvctl config database -d ORCL\nDatabase unique name: ORCL\nDatabase name: ORCL\nOracle home: \/u01\/app\/oracle\/product\/11.2.0\/dbhome_1\nOracle user: oracle\nSpfile: +DATA\/ORCL\/spfileORCL.ora\nDomain: \nStart options: open\nStop options: immediate\nDatabase role: PRIMARY\nManagement policy: AUTOMATIC\nServer pools: ORCL\nDatabase instances: ORCL1,ORCL2\nDisk Groups: DATA,RECO\nMount point paths: \nServices: \nType: RAC\nDatabase is administrator managed<\/pre>\n<h2>Step 11<\/h2>\n<p>Create the pfile from the spfile file that is being used. In this pfile, change the SID values \u200b\u200bearlier than &#8220;*&#8221; in the instance-based parameters to the new SID, and then create the new spfile from this pfile.<\/p>\n<pre class=\"lang:default decode:true\">-bash-4.3$ sqlplus \/ as sysdba\n\nSQL*Plus: Release 11.2.0.4.0 Production on Fri Oct 20 17:47:23 2017\n\nCopyright (c) 1982, 2013, Oracle.  All rights reserved.\n\nConnected to an idle instance.\n\nSQL&gt; create pfile='\/tmp\/testpfile' from spfile='+DATA\/ORCL\/spfileORCL.ora';\n\nFile created.\n\n-bash-4.3$ vi \/tmp\/testpfile\n\n*.audit_file_dest='\/u01\/app\/oracle\/admin\/ORCL\/adump'\n*.audit_trail='db'\n*.cluster_database=TRUE\n*.compatible='11.2.0.4.0'\n*.control_files='+DATA\/orcl\/controlfile\/current.824.957891589','+RECO\/orcl\/controlfile\/current.49661.957891589'\n*.db_block_size=8192\n*.db_create_file_dest='+DATA'\n*.db_domain=''\n*.db_name='TEST'\n*.db_recovery_file_dest='+RECO'\n*.db_recovery_file_dest_size=4621074432\n*.diagnostic_dest='\/u01\/app\/oracle'\n*.dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'\nTEST1.instance_number=1\nTEST2.instance_number=2\n*.open_cursors=300\n*.pga_aggregate_target=12767461376\n*.processes=150\n*.remote_listener='oradb-scan:1521'\n*.remote_login_passwordfile='exclusive'\n*.sga_target=38302384128\nTEST2.thread=2\nTEST1.thread=1\nTEST2.undo_tablespace='UNDOTBS2'\nTEST1.undo_tablespace='UNDOTBS1'\n\nSQL&gt; create spfile='+DATA\/ORCL\/spfileTEST.ora' from pfile='\/tmp\/testpfile';\n\nFile created.<\/pre>\n<h2>Step 12<\/h2>\n<p>Add new databases and instances to the CRS.<\/p>\n<pre class=\"lang:default decode:true \">-bash-4.3$ srvctl add database -d TEST -o \/u01\/app\/oracle\/product\/11.2.0\/dbhome_1 -p '+DATA\/ORCL\/spfileTEST.ora' -n TEST\n-bash-4.3$ srvctl status database -d TEST\nDatabase is not running.\n-bash-4.3$ srvctl add instance -d TEST -i TEST1 -n oradb1\n-bash-4.3$ srvctl add instance -d TEST -i TEST2 -n oradb2\n-bash-4.3$  srvctl status database -d TEST\nInstance TEST1 is not running on node oradb1\nInstance TEST2 is not running on node oradb2<\/pre>\n<h2>Step 13<\/h2>\n<p>Start the database created with the new name.<\/p>\n<pre class=\"lang:default decode:true \">-bash-4.3$  srvctl start database -d TEST\n-bash-4.3$  srvctl status database -d TEST\nInstance TEST1 is running on node oradb1\nInstance TEST2 is running on node oradb2<\/pre>\n<h2>Step 14<\/h2>\n<p>Remove the instance and database registered with the old name in CRS.<\/p>\n<pre class=\"lang:default decode:true\">-bash-4.3$ srvctl remove instance -d ORCL -i ORCL1\nRemove instance from the database ORCL? (y\/[n]) y\n-bash-4.3$ srvctl remove instance -d ORCL -i ORCL2\nRemove instance from the database ORCL? (y\/[n]) y\n-bash-4.3$ srvctl remove database -d ORCL\nRemove the database ORCL? (y\/[n]) y<\/pre>\n<h2>Step 15<\/h2>\n<p>At this stage, the db_name and db_unique_name parameters must be new, and the directories in the ASM disk groups must be created automatically with the new name.<\/p>\n<p>Open the database in mount mode, ensure that the existing datafiles are created in the new ASM directory, and delete the old ones.<\/p>\n<pre class=\"lang:default decode:true \">-bash-4.3$ sqlplus \/ as sysdba\n\nSQL*Plus: Release 11.2.0.4.0 Production on Fri Oct 20 17:37:20 2017\n\nCopyright (c) 1982, 2013, Oracle.  All rights reserved.\n\nConnected to an idle instance.\n\nSQL&gt; startup mount\nORACLE instance started.\n\nTotal System Global Area 3.8215E+10 bytes\nFixed Size                  2254416 bytes\nVariable Size            4563405232 bytes\nDatabase Buffers         3.3420E+10 bytes\nRedo Buffers              229019648 bytes\nDatabase mounted.\n\n-bash-4.3$ rman target \/\n\nRecovery Manager: Release 11.2.0.4.0 - Production on Fri Oct 20 18:15:29 2017\n\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates.  All rights reserved.\n\nconnected to target database: TEST (DBID=2256023237, not open)\n\nRMAN&gt; BACKUP AS COPY DATABASE FORMAT '+DATA';\n\nStarting backup at 20-OCT-17\nusing channel ORA_DISK_1\nchannel ORA_DISK_1: starting datafile copy\ninput datafile file number=00001 name=+DATA\/orcl\/datafile\/system.846.957891511\noutput file name=+DATA\/test\/datafile\/system.885.957896199 tag=TAG20171020T181638 RECID=7 STAMP=957896200\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03\nchannel ORA_DISK_1: starting datafile copy\ninput datafile file number=00002 name=+DATA\/orcl\/datafile\/sysaux.849.957891511\noutput file name=+DATA\/test\/datafile\/sysaux.886.957896203 tag=TAG20171020T181638 RECID=8 STAMP=957896203\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03\nchannel ORA_DISK_1: starting datafile copy\ninput datafile file number=00003 name=+DATA\/orcl\/datafile\/undotbs1.844.957891511\noutput file name=+DATA\/test\/datafile\/undotbs1.887.957896205 tag=TAG20171020T181638 RECID=9 STAMP=957896205\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01\nchannel ORA_DISK_1: starting datafile copy\ninput datafile file number=00005 name=+DATA\/orcl\/datafile\/undotbs2.880.957891619\noutput file name=+DATA\/test\/datafile\/undotbs2.888.957896207 tag=TAG20171020T181638 RECID=10 STAMP=957896206\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01\nchannel ORA_DISK_1: starting datafile copy\ncopying current control file\noutput file name=+DATA\/test\/controlfile\/backup.889.957896209 tag=TAG20171020T181638 RECID=11 STAMP=957896208\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01\nchannel ORA_DISK_1: starting datafile copy\ninput datafile file number=00004 name=+DATA\/orcl\/datafile\/users.843.957891511\noutput file name=+DATA\/test\/datafile\/users.890.957896209 tag=TAG20171020T181638 RECID=12 STAMP=957896209\nchannel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01\nchannel ORA_DISK_1: starting full datafile backup set\nchannel ORA_DISK_1: specifying datafile(s) in backup set\nincluding current SPFILE in backup set\nchannel ORA_DISK_1: starting piece 1 at 20-OCT-17\nchannel ORA_DISK_1: finished piece 1 at 20-OCT-17\npiece handle=+DATA\/test\/backupset\/2017_10_20\/nnsnf0_tag20171020t181638_0.891.957896211 tag=TAG20171020T181638 comment=NONE\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\nFinished backup at 20-OCT-17\n\nRMAN&gt; list copy of database;\n\nList of Datafile Copies\n=======================\n\nKey     File S Completion Time Ckp SCN    Ckp Time       \n------- ---- - --------------- ---------- ---------------\n7       1    A 20-OCT-17       1099335    20-OCT-17      \n        Name: +DATA\/test\/datafile\/system.885.957896199\n        Tag: TAG20171020T181638\n\n8       2    A 20-OCT-17       1099335    20-OCT-17      \n        Name: +DATA\/test\/datafile\/sysaux.886.957896203\n        Tag: TAG20171020T181638\n\n9       3    A 20-OCT-17       1099335    20-OCT-17      \n        Name: +DATA\/test\/datafile\/undotbs1.887.957896205\n        Tag: TAG20171020T181638\n\n12      4    A 20-OCT-17       1099335    20-OCT-17      \n        Name: +DATA\/test\/datafile\/users.890.957896209\n        Tag: TAG20171020T181638\n\n10      5    A 20-OCT-17       1099335    20-OCT-17      \n        Name: +DATA\/test\/datafile\/undotbs2.888.957896207\n        Tag: TAG20171020T181638\n\n\nRMAN&gt; switch database to copy;\n\ndatafile 1 switched to datafile copy \"+DATA\/test\/datafile\/system.885.957896199\"\ndatafile 2 switched to datafile copy \"+DATA\/test\/datafile\/sysaux.886.957896203\"\ndatafile 3 switched to datafile copy \"+DATA\/test\/datafile\/undotbs1.887.957896205\"\ndatafile 4 switched to datafile copy \"+DATA\/test\/datafile\/users.890.957896209\"\ndatafile 5 switched to datafile copy \"+DATA\/test\/datafile\/undotbs2.888.957896207\"\n\nRMAN&gt; list copy of database;\n\nList of Datafile Copies\n=======================\n\nKey     File S Completion Time Ckp SCN    Ckp Time       \n------- ---- - --------------- ---------- ---------------\n13      1    A 20-OCT-17       1099335    20-OCT-17      \n        Name: +DATA\/orcl\/datafile\/system.846.957891511\n\n14      2    A 20-OCT-17       1099335    20-OCT-17      \n        Name: +DATA\/orcl\/datafile\/sysaux.849.957891511\n\n15      3    A 20-OCT-17       1099335    20-OCT-17      \n        Name: +DATA\/orcl\/datafile\/undotbs1.844.957891511\n\n16      4    A 20-OCT-17       1099335    20-OCT-17      \n        Name: +DATA\/orcl\/datafile\/users.843.957891511\n\n17      5    A 20-OCT-17       1099335    20-OCT-17      \n        Name: +DATA\/orcl\/datafile\/undotbs2.880.957891619\n\n\nRMAN&gt;  delete copy of database;\n\nreleased channel: ORA_DISK_1\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=113 instance=TEST1 device type=DISK\nList of Datafile Copies\n=======================\n\nKey     File S Completion Time Ckp SCN    Ckp Time       \n------- ---- - --------------- ---------- ---------------\n13      1    A 20-OCT-17       1099335    20-OCT-17      \n        Name: +DATA\/orcl\/datafile\/system.846.957891511\n\n14      2    A 20-OCT-17       1099335    20-OCT-17      \n        Name: +DATA\/orcl\/datafile\/sysaux.849.957891511\n\n15      3    A 20-OCT-17       1099335    20-OCT-17      \n        Name: +DATA\/orcl\/datafile\/undotbs1.844.957891511\n\n16      4    A 20-OCT-17       1099335    20-OCT-17      \n        Name: +DATA\/orcl\/datafile\/users.843.957891511\n\n17      5    A 20-OCT-17       1099335    20-OCT-17      \n        Name: +DATA\/orcl\/datafile\/undotbs2.880.957891619\n\n\nDo you really want to delete the above objects (enter YES or NO)? YES\ndeleted datafile copy\ndatafile copy file name=+DATA\/orcl\/datafile\/system.846.957891511 RECID=13 STAMP=957896229\ndeleted datafile copy\ndatafile copy file name=+DATA\/orcl\/datafile\/sysaux.849.957891511 RECID=14 STAMP=957896229\ndeleted datafile copy\ndatafile copy file name=+DATA\/orcl\/datafile\/undotbs1.844.957891511 RECID=15 STAMP=957896229\ndeleted datafile copy\ndatafile copy file name=+DATA\/orcl\/datafile\/users.843.957891511 RECID=16 STAMP=957896229\ndeleted datafile copy\ndatafile copy file name=+DATA\/orcl\/datafile\/undotbs2.880.957891619 RECID=17 STAMP=957896229\nDeleted 5 objects\n\n\nRMAN&gt; exit\n\n\nRecovery Manager complete.<\/pre>\n<h2>Step 16<\/h2>\n<p>Start the database on all nodes.<\/p>\n<pre class=\"lang:default decode:true \">-bash-4.3$ srvctl start database -d TEST\n-bash-4.3$ srvctl status database -d TEST\nInstance TEST1 is running on node oradb1\nInstance TEST2 is running on node oradb2<\/pre>\n<h2>Step 17<\/h2>\n<p>Make sure that the datafiles are under the directory created with the new database name in the ASM disk group.<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; select FILE#,NAME from v$datafile;\n\n     FILE# NAME\n---------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------\n         1 +DATA\/test\/datafile\/system.885.957896199\n         2 +DATA\/test\/datafile\/sysaux.886.957896203\n         3 +DATA\/test\/datafile\/undotbs1.887.957896205\n         4 +DATA\/test\/datafile\/users.890.957896209\n         5 +DATA\/test\/datafile\/undotbs2.888.957896207<\/pre>\n<h2>Step 18<\/h2>\n<p>Move the existing controlfiles under the directory created with the new database name in the ASM disk group.<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; show parameter control\n\nNAME                                 TYPE\n------------------------------------ ---------------------------------\nVALUE\n------------------------------\ncontrol_file_record_keep_time        integer\n7\ncontrol_files                        string\n+DATA\/orcl\/controlfile\/current\n.824.957891589, +RECO\/orcl\/con\ntrolfile\/current.49661.9578915\n89\ncontrol_management_pack_access       string\nDIAGNOSTIC+TUNING\n\n\nSQL&gt; show parameter db_name\n\nNAME                                 TYPE\n------------------------------------ ---------------------------------\nVALUE\n------------------------------\ndb_name                              string\nTEST\nSQL&gt; show parameter db_unique_name\n\nNAME                                 TYPE\n------------------------------------ ---------------------------------\nVALUE\n------------------------------\ndb_unique_name                       string\nTEST<\/pre>\n<h2>Step 19<\/h2>\n<p>Change the current control_files parameter to include one old controlfile and the names of the disk groups.<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; alter system set control_files='+DATA\/orcl\/controlfile\/current.824.957891589','+DATA','+RECO' scope=spfile sid='*';\n\nSystem altered.<\/pre>\n<h2>Step 20<\/h2>\n<p>Start the database in nomount mode, and create new controlfiles with the restore controlfile operation.<\/p>\n<pre class=\"lang:default decode:true\">-bash-4.3$ srvctl stop database -d TEST\n\n\nSQL&gt; startup nomount\n\n\n-bash-4.3$ rman target \/\n\nRecovery Manager: Release 11.2.0.4.0 - Production on Tue Oct 24 11:18:53 2017\n\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates.  All rights reserved.\n\nconnected to target database: TEST (not mounted)\n\nRMAN&gt; restore controlfile from '+DATA\/orcl\/controlfile\/current.824.957891589';\n\nStarting restore at 24-OCT-17\nusing target database control file instead of recovery catalog\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=109 instance=TEST1 device type=DISK\n\nchannel ORA_DISK_1: copied control file copy\noutput file name=+DATA\/orcl\/controlfile\/current.824.957891589\noutput file name=+DATA\/test\/controlfile\/current.899.958216739\noutput file name=+RECO\/test\/controlfile\/current.49227.958216739\nFinished restore at 24-OCT-17\n\nRMAN&gt; exit\n\n\nRecovery Manager complete.<\/pre>\n<h2>Step 21<\/h2>\n<p>Change the existing control_files parameter with the controlfiles created under the new database directory. (example: test)<\/p>\n<pre class=\"lang:default decode:true \">-bash-4.3$ sqlplus \/ as sysdba\n\nSQL*Plus: Release 11.2.0.4.0 Production on Tue Oct 24 11:19:50 2017\n\nCopyright (c) 1982, 2013, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\nWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\nData Mining and Real Application Testing options\n\nSQL&gt; alter system set control_files='+DATA\/test\/controlfile\/current.899.958216739','+RECO\/test\/controlfile\/current.49227.958216739' scope=spfile sid='*';\n\nSystem altered.\n\nSQL&gt; shu immediate\nORA-01507: database not mounted\n\n\nORACLE instance shut down.\nSQL&gt; exit\nDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\nWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\nData Mining and Real Application Testing options<\/pre>\n<h2>Step 22<\/h2>\n<p>Start the database to make sure that it uses the new controlfiles.<\/p>\n<pre class=\"lang:default decode:true \">-bash-4.3$ srvctl status database -d TEST\nInstance TEST1 is not running on node oradb1\nInstance TEST2 is not running on node oradb2\n-bash-4.3$ srvctl start database -d TEST\n-bash-4.3$ srvctl status database -d TEST\nInstance TEST1 is running on node oradb1\nInstance TEST2 is running on node oradb2\n-bash-4.3$ sqlplus \/ as sysdba\n\nSQL*Plus: Release 11.2.0.4.0 Production on Tue Oct 24 11:21:24 2017\n\nCopyright (c) 1982, 2013, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\nWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\nData Mining and Real Application Testing options\n\nSQL&gt; show parameter control\n\nNAME                                 TYPE\n------------------------------------ ---------------------------------\nVALUE\n------------------------------\ncontrol_file_record_keep_time        integer\n7\ncontrol_files                        string\n+DATA\/test\/controlfile\/current\n.899.958216739, +RECO\/test\/con\ntrolfile\/current.49227.9582167\n39\ncontrol_management_pack_access       string\nDIAGNOSTIC+TUNING<\/pre>\n<h2>Step 23<\/h2>\n<p>In the previous steps, we created the spfile with new name under the old database in the ASM. In this step, we will re-create the spfile with new name under the new directory.<\/p>\n<pre class=\"lang:default decode:true \">-bash-4.3$ srvctl config database -d TEST\nDatabase unique name: TEST\nDatabase name: TEST\nOracle home: \/u01\/app\/oracle\/product\/11.2.0\/dbhome_1\nOracle user: oracle\nSpfile: +DATA\/ORCL\/spfileTEST.ora\nDomain: \nStart options: open\nStop options: immediate\nDatabase role: PRIMARY\nManagement policy: AUTOMATIC\nServer pools: TEST\nDatabase instances: TEST1,TEST2\nDisk Groups: DATA,RECO\nMount point paths: \nServices: \nType: RAC\nDatabase is administrator managed\n-bash-4.3$ sqlplus \/ as sysdba\n\nSQL*Plus: Release 11.2.0.4.0 Production on Tue Oct 24 11:31:19 2017\n\nCopyright (c) 1982, 2013, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\nWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\nData Mining and Real Application Testing options\n\nSQL&gt; show parameter spfile\n\nNAME                                 TYPE\n------------------------------------ ---------------------------------\nVALUE\n------------------------------\nspfile                               string\n+DATA\/orcl\/spfiletest.ora\nSQL&gt; \nSQL&gt; \nSQL&gt; \nSQL&gt; \nSQL&gt; \nSQL&gt; create pfile='\/tmp\/pfiletest.ora' from spfile='+DATA\/orcl\/spfiletest.ora';\n\nFile created.\n\nSQL&gt; create spfile='+DATA\/test\/spfiletest.ora' from pfile='\/tmp\/pfiletest.ora';\n\nFile created.\n\nSQL&gt; exit\nDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\nWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\nData Mining and Real Application Testing options<\/pre>\n<h2>Step 24<\/h2>\n<p>After changing the spfile, change the database configuration so that it uses the new spfile.<\/p>\n<pre class=\"lang:default decode:true \">-bash-4.3$ srvctl modify database -d TEST -p +DATA\/test\/spfiletest.ora\n-bash-4.3$ srvctl config database -d TEST\nDatabase unique name: TEST\nDatabase name: TEST\nOracle home: \/u01\/app\/oracle\/product\/11.2.0\/dbhome_1\nOracle user: oracle\nSpfile: +DATA\/test\/spfiletest.ora\nDomain: \nStart options: open\nStop options: immediate\nDatabase role: PRIMARY\nManagement policy: AUTOMATIC\nServer pools: TEST\nDatabase instances: TEST1,TEST2\nDisk Groups: DATA,RECO\nMount point paths: \nServices: \nType: RAC\nDatabase is administrator managed<\/pre>\n<h2>Step 25<\/h2>\n<p>Stop the database and change the corresponding row in the $ORACLE_HOME\/dbs\/initSID.ora file on all nodes to show the new spfile.<\/p>\n<pre class=\"lang:default decode:true \">-bash-4.3$ srvctl stop database -d TEST\n\n\n-bash-4.3$ cat $ORACLE_HOME\/dbs\/initTEST1.ora\nSPFILE='+DATA\/ORCL\/spfileTEST.ora'              # line added by Agent\n\n\n-bash-4.3$ vi $ORACLE_HOME\/dbs\/initTEST1.ora\n\n\n-bash-4.3$ cat $ORACLE_HOME\/dbs\/initTEST1.ora\nSPFILE='+DATA\/test\/spfiletest.ora'              # line added by Agent<\/pre>\n<h2>Step 26<\/h2>\n<p>Open the database and make sure that the new spfile is visible in the configuration, and the database opened with the new spfile.<\/p>\n<pre class=\"lang:default decode:true \">-bash-4.3$ srvctl start database -d TEST\n-bash-4.3$ srvctl config database -d TEST\nDatabase unique name: TEST\nDatabase name: TEST\nOracle home: \/u01\/app\/oracle\/product\/11.2.0\/dbhome_1\nOracle user: oracle\nSpfile: +DATA\/test\/spfiletest.ora\nDomain: \nStart options: open\nStop options: immediate\nDatabase role: PRIMARY\nManagement policy: AUTOMATIC\nServer pools: TEST\nDatabase instances: TEST1,TEST2\nDisk Groups: DATA,RECO\nMount point paths: \nServices: \nType: RAC\nDatabase is administrator managed\n\n-bash-4.3$ sqlplus \/ as sysdba\n\nSQL*Plus: Release 11.2.0.4.0 Production on Tue Oct 24 11:41:19 2017\n\nCopyright (c) 1982, 2013, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\nWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\nData Mining and Real Application Testing options\n\nSQL&gt; show parameter spfile\n\nNAME                                 TYPE\n------------------------------------ ---------------------------------\nVALUE\n------------------------------\nspfile                               string\n+DATA\/test\/spfiletest.ora<\/pre>\n<h2>Step 27<\/h2>\n<p>Finally, re-create the existing temp tablespace so that it can use the new directory in the ASM.<\/p>\n<pre class=\"lang:default decode:true \">-bash-4.3$ sqlplus \/ as sysdba\n\nSQL*Plus: Release 11.2.0.4.0 Production on Tue Oct 24 11:50:43 2017\n\nCopyright (c) 1982, 2013, Oracle.  All rights reserved.\n\n\nConnected to:\nOracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\nWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,\nData Mining and Real Application Testing options\n\nSQL&gt; CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '+DATA' SIZE 1G AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED TABLESPACE GROUP '' EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;\n\nTablespace created.\n\nSQL&gt; ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP1;\n\nDatabase altered.\n\nSQL&gt; DROP TABLESPACE TEMP INCLUDING CONTENTS AND DATAFILES;\n\nTablespace dropped.\n\nSQL&gt; CREATE TEMPORARY TABLESPACE TEMP TEMPFILE '+DATA' SIZE 1G AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED TABLESPACE GROUP '' EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;\n\nTablespace created.\n\nSQL&gt; ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP;\n\nDatabase altered.\n\nSQL&gt; DROP TABLESPACE TEMP1 INCLUDING CONTENTS AND DATAFILES;\n\nTablespace dropped.<\/pre>\n<h2>Step 28<\/h2>\n<p>Delete directories created with the old database name in ASM disk groups.<\/p>\n<pre class=\"lang:default decode:true \">-bash-4.3$ . oraenv\nORACLE_SID = [TEST1] ? +ASM1\nThe Oracle base remains unchanged with value \/u01\/app\/oracle\n\n-bash-4.3$ asmcmd\nASMCMD&gt; ls\nDATA\/\nRECO\/\nASMCMD&gt; cd DATA\nASMCMD&gt; rm -rf ORCL\nASMCMD&gt; cd RECO\nASMCMD&gt; rm -rf ORCL\nASMCMD&gt;<\/pre>\n<h2>Step 29<\/h2>\n<p>Make sure that all datafile and tempfiles are under the new directory in ASM.<\/p>\n<pre class=\"lang:default decode:true \">-bash-4.3$ rman target \/\n\nRecovery Manager: Release 11.2.0.4.0 - Production on Tue Oct 24 11:57:35 2017\n\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates.  All rights reserved.\n\nconnected to target database: TEST (DBID=2256023237)\n\nRMAN&gt; report schema;\n\nusing target database control file instead of recovery catalog\nReport of database schema for database with db_unique_name TEST\n\nList of Permanent Datafiles\n===========================\nFile Size(MB) Tablespace           RB segs Datafile Name\n---- -------- -------------------- ------- ------------------------\n1    740      SYSTEM               ***     +DATA\/test\/datafile\/system.885.957896199\n2    570      SYSAUX               ***     +DATA\/test\/datafile\/sysaux.886.957896203\n3    150      UNDOTBS1             ***     +DATA\/test\/datafile\/undotbs1.887.957896205\n4    5        USERS                ***     +DATA\/test\/datafile\/users.890.957896209\n5    25       UNDOTBS2             ***     +DATA\/test\/datafile\/undotbs2.888.957896207\n\nList of Temporary Files\n=======================\nFile Size(MB) Tablespace           Maxsize(MB) Tempfile Name\n---- -------- -------------------- ----------- --------------------\n1    1024     TEMP                 32767       +DATA\/test\/tempfile\/temp.879.958218705<\/pre>\n<p>NOTE: Because redologs are automatically created under the new directory in the ASM, they are not manually recreated.<\/p>\n\n<p>&nbsp;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_11462\" class=\"pvc_stats all  \" data-element-id=\"11462\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>This article describes how to change the id and name of a database that is running as RAC, what operations should be done before and after. In the examples, necessary steps have been performed to change the name of the database named ORCL as TEST. Step 1 Change the value of the cluster_database parameter to &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_11462\" class=\"pvc_stats all  \" data-element-id=\"11462\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":11463,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[3324,3322,3311,3329,3317,3313,3314,3310,3321,3315,3316,3337,3339,3341,3335,3340,3333,3332,3334,3336,3326,3328,3325,3327,3338,3323,3320,3312,3330,3331,3319,3318],"class_list":["post-11462","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-add-database-to-crs","tag-add-databases-to-crs","tag-change-cluster_database-parameter","tag-change-control_files-parameter","tag-change-password-file-in-oracle","tag-change-the-database-id-and-name","tag-change-the-database-id-and-name-in-oracle","tag-change-the-value-of-the-cluster_database-parameter","tag-check-database-configuration","tag-create-pfile-from-spfile","tag-create-spfile-from-pfile","tag-how-to-change-database-name-in-oracle","tag-how-to-change-database-name-in-oracle-12c-rac","tag-how-to-change-database-name-in-oracle-12c-using-nid","tag-how-to-change-dbid-in-rac","tag-how-to-change-oracle-sid-name-in-11g","tag-how-to-change-rac-database-id","tag-how-to-change-rac-database-name","tag-how-to-change-rac-db-id","tag-how-to-rename-an-oracle-database","tag-move-control-file-to-new-directory","tag-move-control-files-to-new-directory","tag-move-controlfile-to-new-directory","tag-move-controlfiles-to-new-directory","tag-oracle-rename-database-create-controlfile","tag-remove-database-from-cts","tag-restore-control-file","tag-start-database-in-mount-mode","tag-start-database-using-new-control-file","tag-start-database-using-new-controlfile","tag-start-oracle-database-from-different-pfile","tag-start-oracle-database-from-different-spfile"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Change the database id and database name in RAC Databases - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Change the database id and database name in RAC Databases\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/04\/20\/how-to-change-the-database-id-and-database-name-in-rac-databases\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Change the database id and database name in RAC Databases - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Change the database id and database name in RAC Databases\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/04\/20\/how-to-change-the-database-id-and-database-name-in-rac-databases\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-04-20T23:02:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-04-20T23:02:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-26.png\" \/>\n\t<meta property=\"og:image:width\" content=\"589\" \/>\n\t<meta property=\"og:image:height\" content=\"301\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"18 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/20\/how-to-change-the-database-id-and-database-name-in-rac-databases\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/20\/how-to-change-the-database-id-and-database-name-in-rac-databases\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Change the database id and database name in RAC Databases\",\"datePublished\":\"2019-04-20T23:02:08+00:00\",\"dateModified\":\"2019-04-20T23:02:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/20\/how-to-change-the-database-id-and-database-name-in-rac-databases\/\"},\"wordCount\":599,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/20\/how-to-change-the-database-id-and-database-name-in-rac-databases\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-26.png\",\"keywords\":[\"add database to CRS\",\"add databases to CRS\",\"Change cluster_database parameter\",\"Change control_files parameter\",\"change password file in oracle\",\"Change the database id and name\",\"Change the database id and name in oracle\",\"Change the value of the cluster_database parameter\",\"Check database configuration\",\"create pfile from spfile\",\"create spfile from pfile\",\"how to change database name in oracle\",\"how to change database name in oracle 12c rac\",\"how to change database name in oracle 12c using nid\",\"How to change DBID in RAC\",\"how to change oracle sid name in 11g\",\"How to change RAC database id\",\"How to change RAC database name\",\"How to change RAC db id\",\"How to rename an Oracle database\",\"move control file to new directory\",\"move control files to new directory\",\"move controlfile to new directory\",\"move controlfiles to new directory\",\"oracle rename database create controlfile\",\"remove database from CTS\",\"restore control file\",\"Start database in mount mode\",\"start database using new control file\",\"start database using new controlfile\",\"start oracle database from different pfile\",\"start oracle database from different spfile\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/04\/20\/how-to-change-the-database-id-and-database-name-in-rac-databases\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/20\/how-to-change-the-database-id-and-database-name-in-rac-databases\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/20\/how-to-change-the-database-id-and-database-name-in-rac-databases\/\",\"name\":\"How To Change the database id and database name in RAC Databases - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/20\/how-to-change-the-database-id-and-database-name-in-rac-databases\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/20\/how-to-change-the-database-id-and-database-name-in-rac-databases\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-26.png\",\"datePublished\":\"2019-04-20T23:02:08+00:00\",\"dateModified\":\"2019-04-20T23:02:09+00:00\",\"description\":\"How To Change the database id and database name in RAC Databases\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/20\/how-to-change-the-database-id-and-database-name-in-rac-databases\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/04\/20\/how-to-change-the-database-id-and-database-name-in-rac-databases\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/20\/how-to-change-the-database-id-and-database-name-in-rac-databases\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-26.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-26.png\",\"width\":589,\"height\":301},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/20\/how-to-change-the-database-id-and-database-name-in-rac-databases\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Change the database id and database name in RAC Databases\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Change the database id and database name in RAC Databases - Database Tutorials","description":"How To Change the database id and database name in RAC Databases","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2019\/04\/20\/how-to-change-the-database-id-and-database-name-in-rac-databases\/","og_locale":"en_US","og_type":"article","og_title":"How To Change the database id and database name in RAC Databases - Database Tutorials","og_description":"How To Change the database id and database name in RAC Databases","og_url":"https:\/\/dbtut.com\/index.php\/2019\/04\/20\/how-to-change-the-database-id-and-database-name-in-rac-databases\/","og_site_name":"Database Tutorials","article_published_time":"2019-04-20T23:02:08+00:00","article_modified_time":"2019-04-20T23:02:09+00:00","og_image":[{"width":589,"height":301,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-26.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"18 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/20\/how-to-change-the-database-id-and-database-name-in-rac-databases\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/20\/how-to-change-the-database-id-and-database-name-in-rac-databases\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Change the database id and database name in RAC Databases","datePublished":"2019-04-20T23:02:08+00:00","dateModified":"2019-04-20T23:02:09+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/20\/how-to-change-the-database-id-and-database-name-in-rac-databases\/"},"wordCount":599,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/20\/how-to-change-the-database-id-and-database-name-in-rac-databases\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-26.png","keywords":["add database to CRS","add databases to CRS","Change cluster_database parameter","Change control_files parameter","change password file in oracle","Change the database id and name","Change the database id and name in oracle","Change the value of the cluster_database parameter","Check database configuration","create pfile from spfile","create spfile from pfile","how to change database name in oracle","how to change database name in oracle 12c rac","how to change database name in oracle 12c using nid","How to change DBID in RAC","how to change oracle sid name in 11g","How to change RAC database id","How to change RAC database name","How to change RAC db id","How to rename an Oracle database","move control file to new directory","move control files to new directory","move controlfile to new directory","move controlfiles to new directory","oracle rename database create controlfile","remove database from CTS","restore control file","Start database in mount mode","start database using new control file","start database using new controlfile","start oracle database from different pfile","start oracle database from different spfile"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/04\/20\/how-to-change-the-database-id-and-database-name-in-rac-databases\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/20\/how-to-change-the-database-id-and-database-name-in-rac-databases\/","url":"https:\/\/dbtut.com\/index.php\/2019\/04\/20\/how-to-change-the-database-id-and-database-name-in-rac-databases\/","name":"How To Change the database id and database name in RAC Databases - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/20\/how-to-change-the-database-id-and-database-name-in-rac-databases\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/20\/how-to-change-the-database-id-and-database-name-in-rac-databases\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-26.png","datePublished":"2019-04-20T23:02:08+00:00","dateModified":"2019-04-20T23:02:09+00:00","description":"How To Change the database id and database name in RAC Databases","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/20\/how-to-change-the-database-id-and-database-name-in-rac-databases\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/04\/20\/how-to-change-the-database-id-and-database-name-in-rac-databases\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/20\/how-to-change-the-database-id-and-database-name-in-rac-databases\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-26.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-26.png","width":589,"height":301},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/20\/how-to-change-the-database-id-and-database-name-in-rac-databases\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Change the database id and database name in RAC Databases"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/11462","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=11462"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/11462\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/11463"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=11462"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=11462"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=11462"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}