Single Instance to RACOne Node Conversion.
Convert single instance to RAC using rconfig utility. Verify the database is added to cluster and is SINGLE Instance.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
[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.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 |
[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… Read More »