Modify Oracle RAC Database Name

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