Convert Oracle RAC to stand-alone database

1. Stop database and CRS on both node
$ srvctl Stop database-d mydb
# Crsctl Stop CRS

2. Turn off RAC

Sql> Startup
ORA-29702 error occurred in Cluster Group Service operation

Relink with the RAC off.
$ cd $ORACLE _home/rdbms/lib
$/usr/ccs/bin/make-f ins_rdbms.mk Rac_off

Relinking Oracle
$ make-f ins_rdbms.mk ioracle

# # OR, both working fine
$ cd $ORACLE _home/bin
$ relink Oracle

If ASM Instance Exist, run below command as root
#/oracle/product/10.2.0/db/bin/localconfig Delete
#/oracle/product/10.2.0/db/bin/localconfig Add

3. Parameter (pfile/spfile) & Database Changes
Sql> Startup
sql> ALTER DATABASE disable thread 2;
Sql> alter system set remote_listener= ';

3a. Remove unwanted logfile
Sql> Select thread#, group# from V$log;
sql> ALTER DATABASE drop logfile Group 3;
sql> ALTER DATABASE drop logfile Group 4;

3b. Remove unwanted tablespace
Sql> drop tablespace UNDOTBS2 including contents and datafiles;

3c. Rename instance name.
Sql> alter system set instance_name=<new_name> Scope=spfile;
sql> shutdown Immediate
Sql> Startup
-Change your ORACLE_SID environment

4. Run $ORA _crs_home/install/rootdelete.sh on both node
-This'll stop and remove all CRS startup related file

5. Remove $ORA _crs_home binary using Clusterware OUI Installer
-Ignore any error if 2nd node already down
-RM-RF $ORA _crs_home

6. Modify Listener File
$ VI $ORACLE _home/network/admin/listener.ora

6a. Modify Tnsname File
$ VI $ORACLE _home/network/admin/tnsnames.ora

You should also change the cluster_database in the initialization parameter to False

========================================================

Oracle expert QQ Group: 60632593 (Full), 60618621, 23145225

Blog: blog.csdn.net/newhappy2008

========================================================