Convert 11gR2 non-RAC database to RAC database using rconfig - Printable Version +- Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities (http://www.oraerp.com) +-- Forum: Oracle Applications (http://www.oraerp.com/forum-39.html) +--- Forum: Oracle Tutorials, Articles, eBooks, Tools & Tips (http://www.oraerp.com/forum-12.html) +--- Thread: Convert 11gR2 non-RAC database to RAC database using rconfig (/thread-15456.html)

Convert 11gR2 non-RAC database to RAC database using rconfig - abdulrehman - 01-23-2012 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: