DATABASE NAME =XRXDB
instance_name=XRXDB1( on node 1 ) and XRXDB2 ( node 2 )
echo $ORACLE_SID
XRXDB1

[1] Create pfile from spfile in non-default location.

 

 

SQL> create pfile=’/u02/oraclenetwork/XRXDB/initXRXDB.ora’ from spfile;
File created.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
 [server313:XRXDB1]$ pwd
/u01/app/oracle/product/11.2.0.3/db_1/dbs
[server313:XRXDB1]$ cd
[server313:XRXDB1]$ cd /u02/oraclenetwork/XRXDB/
[server313:XRXDB1]$ ls -ltr
total 3678728

[server313:XRXDB1]$ cp initXRXDB.ora initXRXDB.ora_bkp
[server313:XRXDB1]$ vi initXRXDB.ora  // comment all the  RAC specific parameters as shown below
[server313:XRXDB1]$ s
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

 

[2] Mount The Database  using new pfile as shown below

 

 

Note:SID is same as earlier

[server313:XRXDB1]$ pwd
/u02/oraclenetwork/XRXDB

SQL> startup mount pfile=’/u02/oraclenetwork/XRXDB/initXRXDB.ora’;
ORACLE instance started.

Total System Global Area 3106619392 bytes
Fixed Size                  2232392 bytes
Variable Size            1862275000 bytes
Database Buffers         1224736768 bytes
Redo Buffers               17375232 bytes
Database mounted.
SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production

Note:Below is sample pfile

comment the XRXDB2 parameters–

#XRXDB2.instance_number=2
#XRXDB2.local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.1)(PORT=1525))))’

[server313:XRXDB1]$ cat /u02/oraclenetwork/XRXDB/initXRXDB.ora
#*.cluster_database=true
*.compatible=’11.2.0.0.0′
*.control_files=’+DATA_GRP_1/xrxdb/controlfile/current.272.872156757′,’+ARCH_GRP_1/xrxdb/controlfile/current.1623.871600291′
*.db_block_size=8192
*.db_create_file_dest=’+DATA_GRP_1′
*.db_domain=”
*.db_name=’XRXDB’
*.db_recovery_file_dest=’+ARCH_GRP_1′
*.db_recovery_file_dest_size=6005194752
*.diagnostic_dest=’/u01/app/oracle’
XRXDB1.instance_number=1
#XRXDB2.instance_number=2
#XRXDB2.local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.1)(PORT=1525))))’
*.log_archive_format=’%t_%s_%r.dbf’
*.memory_target=3111124992
*.open_cursors=300
*.processes=150
*.remote_listener=’racdev-scan.corp.otn.com:1521′
*.remote_login_passwordfile=’exclusive’
XRXDB1.thread=1
#XRXDB2.thread=2
#XRXDB2.undo_tablespace=’UNDOTBS1′
XRXDB1.undo_tablespace=’UNDOTBS2′

 

Now use the nid utility :

 
[server313:XRXDB1]$ nid TARGET=sys/oracle dbname=xrxdbnew

DBNEWID: Release 11.2.0.3.0 – Production on Wed Feb 25 08:40:51 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to database XRXDB (DBID=3599526942)

Connected to server version 11.2.0

Control Files in database:
    +DATA_GRP_1/xrxdb/controlfile/current.272.872156757
    +ARCH_GRP_1/xrxdb/controlfile/current.1623.871600291

Change database ID and database name XRXDB to XRXDBNEW? (Y/[N]) => Y

Proceeding with operation
Changing database ID from 3599526942 to 3696324691
Changing database name from XRXDB to XRXDBNEW
    Control File +DATA_GRP_1/xrxdb/controlfile/current.272.872156757 – modified
    Control File +ARCH_GRP_1/xrxdb/controlfile/current.1623.871600291 – modified
    Datafile +DATA_GRP_1/xrxdb/datafile/system.304.87215712 – dbid changed, wrote new name
    Datafile +DATA_GRP_1/xrxdb/datafile/sysaux.299.87215712 – dbid changed, wrote new name
    Datafile +DATA_GRP_1/xrxdb/datafile/undotbs1.298.87215712 – dbid changed, wrote new name
    Datafile +DATA_GRP_1/xrxdb/datafile/undotbs2.297.87215712 – dbid changed, wrote new name
    Datafile +DATA_GRP_1/xrxdb/datafile/users.296.87215712 – dbid changed, wrote new name
    Datafile +DATA_GRP_1/xrxdb/tempfile/temp.300.87160030 – dbid changed, wrote new name
    Control File +DATA_GRP_1/xrxdb/controlfile/current.272.872156757 – dbid changed, wrote new name
    Control File +ARCH_GRP_1/xrxdb/controlfile/current.1623.871600291 – dbid changed, wrote new name
    Instance shut down

Database name changed to XRXDBNEW.
Modify parameter file and generate a new password file before restarting.
Database ID for database XRXDBNEW changed to 3696324691.
All previous backups and archived redo logs for this database are unusable.
Database is not aware of previous backups and archived logs in Recovery Area.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database name and ID.
DBNEWID – Completed succesfully.

 

 Mount Database with new pfile.

 

[server313:RAC11]$ export ORACLE_SID=XRXDBNEW
[server313:XRXDBNEW]$ s

SQL*Plus: Release 11.2.0.3.0 Production on Wed Feb 25 08:59:19 2015
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup mount pfile=’/u02/oraclenetwork/XRXDB/initXRXDBNEW.ora’;
ORACLE instance started.

Total System Global Area 3106619392 bytes
Fixed Size                  2232392 bytes
Variable Size            1711280056 bytes
Database Buffers         1375731712 bytes
Redo Buffers               17375232 bytes
Database mounted.

SQL> select status from v$instance;
STATUS
————
MOUNTED

SQL> select name from v$database;
NAME
———
XRXDBNEW

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open RESETLOGS;
Database altered.
SQL> select open_mode from v$database;
OPEN_MODE
——————–
READ WRITE
SQL> create spfile=’+DATA_GRP_1/XRXDB/spfileXRXDBNEW.ora’ from pfile=’/u02/oraclenetwork/XRXDB/XRXDBNEW.ora’;
File created.

SQL> !echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0.3/db_1

SQL> select name from v$database;

NAME
———
XRXDBNEW
Register Database with the Cluster.

 

[server313:XRXDBNEW]$ srvctl add database -d XRXDBNEW -o /u01/app/oracle/product/11.2.0.3/db_1 -r primary -s OPEN -p +DATA_GRP_1/XRXDB/spfileXRXDBNEW.ora
[server313:XRXDBNEW]$ srvctl add instance -d XRXDBNEW -i XRXDBNEW1 -n server313
[server313:XRXDBNEW]$ srvctl add instance -d XRXDBNEW -i XRXDBNEW2 -n usa0300lx575
[server313:XRXDBNEW]$ srvctl config database -d XRXDNEW -a
PRCD-1120 : The resource for database XRXDNEW could not be found.
PRCR-1001 : Resource ora.xrxdnew.db does not exist
[server313:XRXDBNEW]$ srvctl config database -d XRXDBNEW -a
Database unique name: XRXDBNEW
Database name:
Oracle home: /u01/app/oracle/product/11.2.0.3/db_1
Oracle user: oracle
Spfile: +DATA_GRP_1/XRXDB/spfileXRXDBNEW.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: XRXDBNEW
Database instances: XRXDBNEW1,XRXDBNEW2
Disk Groups:
Mount point paths:
Services:
Type: RAC
Database is enabled
Database is administrator managed