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 OraERP.com 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, Simple and Absolutely Free.

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

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:


Reply
Thanks given by:


Possibly Related Threads...
Thread Author Replies Views Last Post
  Query- How to check the Oracle database version Zishan Ali 0 1,383 08-16-2015, 11:35 PM
Last Post: Zishan Ali
  Recover database without archivelogs Zishan Ali 0 1,046 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,681 06-25-2015, 07:07 PM
Last Post: Ahmad Mujeeb
  Oracle 11gR2 database upgrade in Apps R12.1.1 Sara Khan 0 1,711 12-20-2013, 05:49 AM
Last Post: Sara Khan
  Oracle Database 11g on Enterprise Linux 5 and CentOS 5 Hassanmalik 0 1,812 12-09-2012, 05:44 AM
Last Post: Hassanmalik



Users browsing this thread: 1 Guest(s)
OTech Talks, Lets Talk OPEN! Get Oracle Tutorials, Tips! Post a Question!