racone

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