Oracle Forums Community of Oracle Professionals including Fusion/Cloud Application Consultants, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick and Simple.
Get unlimited access to Oracle Tutorials, Articles, eBooks, Tools and Tips by upgrading to "Premium Membership".
Oracle Training

Thread Rating:
  • 26 Vote(s) - 2.08 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Convert 11gR2 non-RAC database to RAC database using rconfig
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

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
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
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

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

. ./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=’ +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
[Image: clip_image005.jpg]

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 –


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:

Thanks given by:

Possibly Related Threads...
Thread Author Replies Views Last Post
  Oracle RAC Upgrade from to Zishan Ali 2 2,675 05-08-2016, 10:25 PM
Last Post: Kashif Manzoor
  Query- How to check the Oracle database version Zishan Ali 0 1,477 08-16-2015, 11:35 PM
Last Post: Zishan Ali
  Recover database without archivelogs Zishan Ali 0 1,191 08-15-2015, 07:42 AM
Last Post: Zishan Ali
  Query to Check Tablespace Size and frees pace in Oracle Database Ahmad Mujeeb 0 1,865 06-25-2015, 07:07 PM
Last Post: Ahmad Mujeeb
  Oracle 11gR2 database upgrade in Apps R12.1.1 Sara Khan 0 1,910 12-20-2013, 05:49 AM
Last Post: Sara Khan
  Oracle Database 11g on Enterprise Linux 5 and CentOS 5 Hassanmalik 0 1,920 12-09-2012, 05:44 AM
Last Post: Hassanmalik
  Step By Step: Install and setup Oracle 11g R2 RAC on Oracle Enterprise Linux 5.5 (32 abdulrehman 0 30,748 01-23-2012, 03:59 PM
Last Post: abdulrehman

Users browsing this thread: 1 Guest(s)
Get Premium Membership Get Oracle Tutorials, Tips! Post a Question!