How to convert single instance to RAC database !!

Subject : How to convert single instance database to RAC enabled Database ( Multi instance )
Version : Oracle 10.2.0.3


There are three ways to do it.

1) Manual process by setting init parameters
2) By using DBCA
3) By using rconfig utility

1)

Prechecks

** Back Up the Original Single-Instance Database
** Perform the Pre-Installation Steps
** Set Up and validate the Cluster, ensure second nodes connected to the cluster by running olsnodes
** Install Oracle Database 10g Software with Real Application Clusters
** Make sure storage area is shared with other node.
** Make sure you have created Oracle Admin folder which are bdump cdump and udump in the correct loacation as per parameter file.
** change the parameter file of instance 1 with following parameters and copy over to second node.

Assue testdb1 is the first instance and testdb2 is the second instance.

testdb1.instance_number=1
testdb1.instance_name='testdb1'
testdb2.instance_number=2
testdb2.instance_name='testdb2'
testdb1.thread=1
testdb2.thread=2
cluster_database=TRUE
cluster_database_instances=2
testdb1.undo_tablespace=undotbs1
testdb2.undo_tablespace=undotbs2


2) It is wizard kind of thing.. So i do not want to focus on it.

3) rconfig is also very interesting one. rconfig can be find $ORACLE_HOME/bin/rconfig , As a oracle user if you would explore $ORACLE_HOME/assistants/rconfig/sampleXMLs and then you will see file called "ConvertToRAC.xml", Where you need to set the parameter which are
required for single to multi instance conversion.

On the seventh line of this file , you need to set values one of below.

YES - Performs a check of prerequisites + conversion
NO - No check of prerequisites straight to conversion
ONLY - only prerequisites check

Save this file to some name say myinputpara.xml

rconfig myinputpara.xml


After converting if you want to change the database name so please refer one of other post.

HTH
Prashant