Listener Configuration in 11gR2: Author - A.Kishore
Listener Configuration in 11gR2: Author - A.Kishore
Listener Configuration in 11gR2: Author - A.Kishore
Kishore
http:/www.appsdba.info
Convert 11gR2 non-RAC database to RAC database using rconfig
This post talks about the Conversion of 11gR2 non-RAC database to RAC database using rconfig.
Oracle provides 3 methods to convert non-RAC single instance database to RAC databases:
1. DBCA
2. rconfig
3. Enterprise Manager
All the 3 have their own benefits and can be used to suit one’s needs. My recent work involved the
conversion of non-RAC single instance database to RAC database using rconfig, although I’ve tested all
the 3 methods but concluded on rconfig.
The Oracle Home can either be the Infrastructure home or a database home. The TNS_ADMIN
directory can be any accessible directory. The listener name must be unique within the
listener.ora file. See Oracle Real Application Clusters Administration and Deployment Guide 11g
Release 2 (11.2)
There are three issues to be considered:
When the listener starts, it will run from the database ORACLE_HOME. srvctl manages the
listener.ora file across all nodes.
SourceDBHome - /d01/oracle/RACDB/db/tech_st/11.2.0
ORACLE_SID – RACDB
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.
Author – A.Kishore
http:/www.appsdba.info
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.
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.
Author – A.Kishore
http:/www.appsdba.info
-- From New Home
cat grid.env
export ORACLE_HOME=/d01/oracle/app/11.2.0/grid
export PATH=$PATH:$ORACLE_HOME/bin
. ./grid.env
spfile=’ +DATA/spfile/spfileracdb.ora’
rconfig ConvertToRAC_AdminManaged.xml
Author – A.Kishore
http:/www.appsdba.info
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:
8. Now are we are ready for conversion, edit the xml file
“ConvertToRAC_AdminManaged.xml” and change:
rconfig ConvertToRAC_AdminManaged.xml
The conversion will take some time to complete. The progress can be monitored from the logs located at
$ORACLE_BASE/cfgtoollogs/rconfig
Author – A.Kishore
http:/www.appsdba.info
Author – A.Kishore
http:/www.appsdba.info
Post-RAC Migration Steps
Back out archivelog mode changes implemented by Rconfig (conditional). Rconfig will put the database
into archive log mode. If you do not want the database to be in archive log mode, you can disable it using
the following steps:
Check the archive log setting using the command "archive log list".
If the existing single instance Net Listener was not reused during the Rconfig conversion, or is named
something other than LISTENER_<hostname>, remove the Listener configuration generated by Rconfig
using NetCA, then verify that the listener was removed from CRS by issuing the crs_stat command from a
session set to the CRS_ORACLE_HOME location.
Using the command "srvctl stop listener -n <nodename>", shut down the listeners with the name
LISTENER_<nodename>. These were created in Step 3.3 using srvctl login as the owner of the
CRS_ORACLE_HOME.
Using Oracle 11g Release 2 Real Application Clusters with Oracle E-Business Suite Release 12 (Doc ID 823587.1)