Convert single instance to RAC using rconfig utility.
Verify the database is added to cluster and is SINGLE Instance.
[oracle@SAMOELNODE01 ~]$ srvctl config database -d ORCL Database unique name: ORCL Database name: Oracle home: /u01/app/oracle/product/11.2.0.4/dbhome_2 Oracle user: oracle Spfile: Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: ORCL Database instance: ORCL Disk Groups: Mount point paths: Services: Type: SINGLE Database is administrator managed
Above output shows Type: SINGLE.
[oracle@SAMOELNODE01 scripts]$ cd /u01/app/oracle/product/11.2.0.4/dbhome_2/assistants/rconfig/sampleXMLs/ [oracle@SAMOELNODE01 sampleXMLs]$ ls -ltr total 12 -rw-r--r-- 1 oracle oinstall 2804 Mar 22 2010 ConvertToRAC_PolicyManaged.xml -rw-r--r-- 1 oracle oinstall 2754 Apr 8 14:24 ConvertToRAC_AdminManaged.xml.orig -rw-r--r-- 1 oracle oinstall 2781 Apr 8 15:00 ConvertToRAC_AdminManaged.xml [oracle@SAMOELNODE01 sampleXMLs]$ cp ConvertToRAC_AdminManaged.xml ConvertToRACOneNode.xml [oracle@SAMOELNODE01 sampleXMLs]$ diff ConvertToRAC_AdminManaged.xml ConvertToRACOneNode.xml 7c7 < <n:Convert verify="YES"> --- > <n:Convert verify="ONLY"> 9c9 < <n:SourceDBHome>/oracle/product/11.2.0/db_1</n:SourceDBHome> --- > <n:SourceDBHome>/u01/app/oracle/product/11.2.0.4/dbhome_2</n:SourceDBHome> 11c11 < <n:TargetDBHome>/oracle/product/11.2.0/db_1</n:TargetDBHome> --- > <n:TargetDBHome>/u01/app/oracle/product/11.2.0.4/dbhome_2</n:TargetDBHome> 13c13 < <n:SourceDBInfo SID="sales"> --- > <n:SourceDBInfo SID="ORCL"> 16c16 < <n:Password>oracle</n:Password> --- > <n:Password>system123</n:Password> 22,23c22,23 < <n:Node name="node1"/> < <n:Node name="node2"/> --- > <n:Node name="SAMOELNODE01"/> > <n:Node name="SAMOELNODE02"/> 26c26 < <!--n:RacOneNode servicename="saleORCLac1service"/--> --- > <n:RacOneNode servicename="ORCL"/> 28c28 < <n:InstancePrefix>sales</n:InstancePrefix> --- > <n:InstancePrefix>ORCL</n:InstancePrefix> 33c33 < <n:TargetDatabaseArea>+ASMDG</n:TargetDatabaseArea> --- > <n:TargetDatabaseArea></n:TargetDatabaseArea> 35c35 < <n:TargetFlashRecoveryArea>+ASMDG</n:TargetFlashRecoveryArea> --- > <n:TargetFlashRecoveryArea></n:TargetFlashRecoveryArea>
So here I’ve changed only following values
i.e. SourceDBHome, TargetDBHome, SourceDBInfo, Password, Node name, RacOneNode servicename, InstancePrefix
and following values are altered to blank (><) as we are not migrating storage area i.e. TargetDatabaseArea & TargetFlashRecoveryArea.
“Convert verify”: Value of “ONLY” denotes to run rconfig in Test mode, “YES” denotes Live mode conversion.
Now execute rconfig in Test mode only (<n:Convert verify=”ONLY”>). Post success, we can execute with <n:Convert verify=”YES”>.
[oracle@SAMOELNODE01 bin]$ ./rconfig /u01/app/oracle/product/11.2.0.4/dbhome_2/assistants/rconfig/sampleXMLs/ConvertToRACOneNode.xml <?xml version="1.0" ?> <RConfig version="1.1" > <ConvertToRAC> <Convert> <Response> <Result code="0" > Operation Succeeded </Result> </Response> <ReturnValue type="object"> There is no return value for this step </ReturnValue> </Convert> </ConvertToRAC></RConfig>
Here “Operation Succeded” mentions its success in test mode.
Now execute rconfig in Live mode only (change <n:Convert verify=”YES”>). And execute below.
[oracle@SAMOELNODE01 bin]$ ./rconfig /u01/app/oracle/product/11.2.0.4/dbhome_2/assistants/rconfig/sampleXMLs/ConvertToRACOneNode.xml Converting Database "ORCL" to Cluster Database. Target Oracle Home: /u01/app/oracle/product/11.2.0.4/dbhome_2. Database Role: PRIMARY. Setting Data Files and Control Files Adding Database Instances Adding Redo Logs Enabling threads for all Database Instances Setting TEMP tablespace Adding UNDO tablespaces Adding Trace files Setting Fast Recovery Area Updating Oratab Creating Password file(s) Configuring Listeners Configuring related CRS resources Starting Cluster Database <?xml version="1.0" ?> <RConfig version="1.1" > <ConvertToRAC> <Convert> <Response> <Result code="0" > Operation Succeeded </Result> </Response> <ReturnValue type="object"> <Oracle_Home> /u01/app/oracle/product/11.2.0.4/dbhome_2 </Oracle_Home> <Database type="ADMIN_MANAGED" > <InstanceList> <Instance SID="ORCL_1" Node="SAMOELNODE01" > </Instance> </InstanceList> </Database> </ReturnValue> </Convert> </ConvertToRAC></RConfig>
Now again we see “Operation Succeded” that says its success.
Let’s verify the same.
[oracle@SAMOELNODE01 bin]$ srvctl config database -d ORCL Database unique name: ORCL Database name: ORCL Oracle home: /u01/app/oracle/product/11.2.0.4/dbhome_2 Oracle user: oracle Spfile: /u02/app/oracle/oradata/datastore/.ACFS/snaps/ORCL/spfileORCL.ora Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: ORCL Database instances: Disk Groups: Mount point paths: Services: saleORClac1service Type: RACOneNode Online relocation timeout: 30 Instance name prefix: ORCL Candidate servers: SAMOELNODE01,SAMOELNODE02 Database is administrator managed
For troubleshooting refer logs at $ORACLE_HOME/cfgtoollogs/rconfig.
e.g. /u01/app/oracle/product/11.2.0.4/dbhome_2/cfgtoollogs/rconfig
Recent Comments