Convert 11gR2 non-RAC database to RAC database using rconfig

[abdulrehman]

Convert 11gR2 non-RAC database to RAC database using rconfig

I’ve installed the new 11gR2 clustered ORACLE_HOME at /d01/oracle/app/oracle/product/11.2.0/dbhome_1 on both the nodes linux1 and linux2
New Oracle 11gR2 RAC Home - /d01/oracle/app/oracle/product/11.2.0/dbhome_1
SourceDBHome - /d01/oracle/RACDB/db/tech_st/11.2.0
ORACLE_SID – RACDB


1. As the oracle user, navigate to the directory $ORACLE_HOME/assistants/rconfig/sampleXMLs,
and open the sample file ConvertToRAC.xml using a text editor such as vi. This XML sample file
contains comment lines that provide instructions on how to edit the file to suit your site's specific
needs.
nConnect to new home
n. ./oracle.env
n[oracle@linux1 ~]$ cat oracle.env
export ORACLE_HOME=/d01/oracle/app/oracle/product/11.2.0/dbhome_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib,$ORACLE_HOME/ctx/lib
export ORACLE_SID=RACDB
export PATH=$PATH:$ORACLE_HOME/bin
export
TNS_ADMIN=/d01/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/RACDB
1_linux1
cd /d01/oracle/app/oracle/product/11.2.0/dbhome_1/assistants/rconfig/sampleXMLs
cp ConvertToRAC_AdminManaged.xml ConvertToRAC_AdminManaged.xml_org

2. Copy the sample ConvertToRAC_AdminManaged.xml, and modify the parameters as required for
your system. Make a note of the name of your copy of the XML file.

3. To test the settings specified, it is advisable to execute rconfig using convert verify="ONLY"
before carrying out the actual conversion. This will perform a test run to validate parameters and
flag any incorrect settings or issues that need to be resolved before the final conversion takes
place.

Note: Specify 'SourceDBHome' variable in ConvertToRAC_AdminManaged.xml as Non- RAC
oracle home (e.g. $OLD_ORACLE_HOME path). If you wish to specify as
NEW_ORACLE_HOME then start the database from new oracle home using:

I have started from NEW_ORACLE_HOME

4. Move the spfile to the shared location, in this case the Single Instance Database was hosted on file
system, in this process we will move the datafiles from file system storage to ASM.

-- From New Home

-- copy the initRACDB.ora from Source DB Home

Create the spfile from pfile using the command:
sqlplus “/as sysdba”

So create spfile in the shared disk location

create spfile='+DATA/spfile/spfileracdb.ora' from pfile;


You can check if the file is created through “asmcmd”
cat grid.env
export ORACLE_HOME=/d01/oracle/app/11.2.0/grid
export PATH=$PATH:$ORACLE_HOME/bin

. ./grid.env


. ./oracle.env




5.Take a backup of existing $ORACLE_HOME/dbs/init.ora and create a new
$ORACLE_HOME/dbs/init.ora with following parameter:

spfile='/spfile.ora'
spfile=’ +DATA/spfile/spfileracdb.ora’

6. Start up the instance from the NEW ORACLE_HOME

7. Now lets test if “rconfig” is ready for conversion, navigate to $ORACLE_HOME/
assistants/rconfig/sampleXMLs and issue the following command





cd /d01/oracle/app/oracle/product/11.2.0/dbhome_1/assistants/rconfig/sampleXMLs

rconfig ConvertToRAC_AdminManaged.xml

The above command validates( as we’ve set convert=”ONLY”) if rconfig is ready for conversion.
If the output throws any error, diagnose and troubleshoot to fix the issue. Refer to the following
output for successful validation:


Issues faced –

Rconfig

a> Default Listener is not configured in Grid Infrastructure Home.

Solution - on the grid infrastruture - run netca - create a default listener

b> /d02/oracle/RACDB/db/tech_st/11.2.0/dbs/arch LOG ARCHIVE DEST
Solution - mkdir /d02/oracle/RACDB/db/tech_st/11.2.0/dbs/arch

8. Now are we are ready for conversion, edit the xml file
“ConvertToRAC_AdminManaged.xml” and change: