Modify Oracle RAC Database Name
Briefly record some methods for modifying the name of Oracle RAC.
1. Close an instance
[Oracle @ rac11g2 ~] $ Sqlplus/as sysdba
SQL> shutdown immediate;
2. Back up the spfile File
SQL> create pfile = '/home/oracle/acct1.pfile' from spfile;
3. Modify the pfile cluster_database to false.
*. Cluster_database = FALSE
4. Use the pfile file to start a single instance database to the mount status
SQL> startup mount pfile = '/home/oracle/acct1.pfile ';
5. Execute nid to modify dbname
[Oracle @ rac11g1 ~] $ Nid target = sys/oracle dbname = crmdb setname = y
DBNEWID: Release 11.2.0.4.0-Production on Tue May 19 09:31:48 2015
Copyright (c) 1982,201 1, Oracle and/or its affiliates. All rights reserved.
Connected to database ACCT (DBID = 3809824099)
Connected to server version 11.2.0
Control Files in database:
+ DATA_DG/acct/controlfile/current.261.872692963
+ DATA_DG/acct/controlfile/current.260.872692963
Change database name of database ACCT to CRMDB? (Y/[N]) => Y
Proceeding with operation
Changing database name from ACCT to CRMDB
Control File + DATA_DG/acct/controlfile/current.261.872692963-modified
Control File + DATA_DG/acct/controlfile/current.260.872692963-modified
Datafile + DATA_DG/acct/datafile/system.256.87269284-wrote new name
Datafile + DATA_DG/acct/datafile/sysaux.257.87269284-wrote new name
Datafile + DATA_DG/acct/datafile/undotbs1.258.87269284-wrote new name
Datafile + DATA_DG/acct/datafile/users.259.87269284-wrote new name
Datafile + DATA_DG/acct/datafile/example.267.87269300-wrote new name
Datafile + DATA_DG/acct/datafile/undotbs2.268.87269351-wrote new name
Datafile + DATA_DG/acct/tempfile/temp.266.87269298-wrote new name
Control File + DATA_DG/acct/controlfile/current.261.872692963-wrote new name
Control File + DATA_DG/acct/controlfile/current.260.872692963-wrote new name
Instance shut down
Database name changed to CRMDB.
Modify parameter file and generate a new password file before restarting.
Succesfully changed database name.
DBNEWID-Completed succesfully.
6. Modify ORACLE_SID Information
------ Node 1 ------
6.1 Environment Variables
[Oracle @ rac11g1 ~] $ Vi. bash_profile
Export ORACLE_SID = crmdb1
6.2 Password File
[Oracle @ rac11g1 ~] $ Cd $ ORACLE_HOME/dbs
[Oracle @ rac11g1 dbs] $ orapwd file = orapwcrmdb1 password = oracle
6.3 modify the pfile file to start the database
*. Cluster_database = TRUE
*. Db_name = 'crmdb'
Replace acct1 with crmdb1: % s/acct1/crmdb1/g
Replace acct2 with crmdb2: % s/acct2/crmdb2/g
6.4 create a new spfile parameter file
[Oracle @ rac11g1 ~] $ Sqlplus/as sysdba
SQL> startup pfile = '/home/oracle/acct1.pfile 'nomount;
SQL> create spfile = '+ DATA_DG' from pfile = '/home/oracle/acct1.pfile ';
6.5 create a pfile parameter file
[Oracle @ rac11g1 ~] $ Cd $ ORACLE_HOME/dbs
[Oracle @ rac11g1 dbs] $ vi initcrmdb1.ora
SPFILE = '+ DATA_DG/crmdb/PARAMETERFILE/spfile.293.880105913'
------ Node 2 ------
1. Environment Variables
[Oracle @ rac11g2 ~] $ Vi. bash_profile
Export ORACLE_SID = crmdb2
2. Password File
[Oracle @ rac11g2 ~] $ Cd $ ORACLE_HOME/dbs
[Oracle @ rac11g2 dbs] $ orapwd file = orapwcrmdb2 password = oracle
3. parameter file
[Oracle @ rac11g2 dbs] $ vi initcrmdb2.ora
SPFILE = '+ DATA_DG/crmdb/PARAMETERFILE/spfile.293.880105913'
7. Modify crs Resources
7.1 delete old instance configurations
[Oracle @ rac11g1 ~] $ Srvctl remove database-d acct
7.2 add new instance Configuration
[Oracle @ rac11g1 ~] $ Srvctl add database-d crmdb-o/oracle/app/oracle/product/11.2.0/db_1/
[Oracle @ rac11g1 ~] $ Srvctl add instance-d crmdb-I crmdb1-n rac11g1
[Oracle @ rac11g1 ~] $ Srvctl add instance-d crmdb-I crmdb2-n rac11g2