Saturday 17 August 2019

RAC - Rconfig convert single instance to 2 node RAC 12.1.0.2.0

Senerio Preview

  • Standalone database smrtest installed on grid database home
  • Grid 12c 12.1.0.2.0  already installed
  • (NOTE :  Standalone database already installed oel 6.7 machine , i have install grid 12c setup on same machine. But once try to create rac database using rconfig on standalone which was previously created got error . So fresh grid database software setup done on it and install database after that using RCONFIG standalone databsae converted into RAC database.
Solution:
  • Go to location oracle home assistants/rconfig/sampleXMLs location..
  • Edit on ConvertToRAC_AdminManaged.xml file
  • Run command  as /u01/app/oracle/product/12.1.0/dbhome_2/bin/rconfig ConvertToRAC_AdminManaged.xml
  • Check status using crsctl status resource -t
  • check listener status on instance (grid automatically configure listener setting from standalone to rac db)



[oracle@srv1 sampleXMLs]$ vi ConvertToRAC_AdminManaged.xml
[root@srv1 sampleXMLs]# cat ConvertToRAC_AdminManaged.xml
<?xml version="1.0" encoding="UTF-8"?>
<n:RConfig xmlns:n="http://www.oracle.com/rconfig"
           xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
           xsi:schemaLocation="http://www.oracle.com/rconfig rconfig.xsd">
    <n:ConvertToRAC> 
<!-- Verify does a precheck to ensure all pre-requisites are met, before the conversion is attempted. Allowable values are: YES|NO|ONLY -->
<n:Convert verify="YES">
<!--Specify current OracleHome of non-rac database for SourceDBHome -->
      <n:SourceDBHome>/u01/app/oracle/product/12.1.0/dbhome_2</n:SourceDBHome>
<!--Specify OracleHome where the rac database should be configured. It can be same as SourceDBHome -->
      <n:TargetDBHome>/u01/app/oracle/product/12.1.0/dbhome_2</n:TargetDBHome>
<!--Specify SID of non-rac database and credential. User with sysdba role is required to perform conversion -->
              <n:SourceDBInfo SID="smrtest">
        <n:Credentials>
          <n:User>sys</n:User>
          <n:Password>system123</n:Password>
          <n:Role>sysdba</n:Role>
        </n:Credentials>
<!--Specify Windows Secure Oracle Home Credentials if the Oracle Home was installed with Secure User option  -->
<!--
        <n:Credentials>
          <n:User>UserDomain\SecureHomeUserName</n:User>
          <n:Password>oracle</n:Password>
          <n:Role>windows_svc</n:Role>
        </n:Credentials>
-->
      </n:SourceDBInfo>
<!--Specify the list of nodes that should have rac instances running for the Admin Managed Cluster Database. LocalNode should be the first node in this nodelist. -->
      <n:NodeList>     
        <n:Node name="srv1"/>
        <n:Node name="srv2"/>
      </n:NodeList>
<!--Specify RacOneNode along with servicename to convert database to RACOne Node -->
              <!--n:RacOneNode  servicename="salesrac1service"/-->
<!--Instance Prefix tag is optional starting with 11.2. If left empty, it is derived from db_unique_name.-->
      <n:InstancePrefix>smrtest</n:InstancePrefix>
<!-- Listener details are no longer needed starting 11.2. Database is registered with default listener and SCAN listener running from Oracle Grid Infrastructure home. -->
<!--Specify the type of storage to be used by rac database. Allowable values are CFS|ASM. The non-rac database should have same storage type. ASM credentials are no needed for conversion. -->
      <n:SharedStorage type="ASM">
<!--Specify Database Area Location to be configured for rac database.If this field is left empty, current storage will be used for rac database. For CFS, this field will have directory path. -->
        <n:TargetDatabaseArea>+DATA</n:TargetDatabaseArea>
<!--Specify Fast Recovery Area to be configured for rac database. If this field is left empty, current recovery area of non-rac database will be configured for rac database. If current database is not using recovery Area, the resulting rac database will not have a recovery area. -->
        <n:TargetFlashRecoveryArea>+FRA</n:TargetFlashRecoveryArea>
      </n:SharedStorage>
        </n:Convert>
    </n:ConvertToRAC>
</n:RConfig>
[root@srv1 sampleXMLs]#


[oracle@srv1 sampleXMLs]$ ll
total 12
-rw-r--r-- 1 oracle oinstall 3070 Aug 14 18:09 ConvertToRAC_AdminManaged.xml
-rw-r--r-- 1 oracle oinstall 3068 Aug 14 18:08 ConvertToRAC_AdminManaged.xml_bkp
-rw-r--r-- 1 oracle oinstall 3153 Oct 13  2013 ConvertToRAC_PolicyManaged.xml



[oracle@srv1 sampleXMLs]$ /u01/app/oracle/product/12.1.0/dbhome_2/bin/rconfig ConvertToRAC_AdminManaged.xml
Converting Database "smrtest" to Cluster Database. Target Oracle Home: /u01/app/oracle/product/12.1.0/dbhome_2. Database Role: PRIMARY.
Setting Data Files and Control Files

Adding Trace files
Adding Database Instances
Adding Redo Logs
Enabling threads for all Database Instances
Setting TEMP tablespace
Adding UNDO tablespaces
Setting Fast Recovery Area
Updating Oratab
Creating Password file(s)
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/12.1.0/dbhome_2
       </Oracle_Home>
       <Database type="ADMIN_MANAGED"  >
         <InstanceList>
           <Instance SID="smrtest1" Node="srv1"  >
           </Instance>
           <Instance SID="smrtest2" Node="srv2"  >
           </Instance>
         </InstanceList>
       </Database>     </ReturnValue>
    </Convert>
  </ConvertToRAC></RConfig>
[oracle@srv1 sampleXMLs]$



[root@srv1 disks]# crsctl status resource -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRS.dg
               ONLINE  ONLINE       srv1                     STABLE
               ONLINE  ONLINE       srv2                     STABLE
ora.DATA.dg
               ONLINE  ONLINE       srv1                     STABLE
               ONLINE  ONLINE       srv2                     STABLE
ora.FRA.dg
               ONLINE  ONLINE       srv1                     STABLE
               ONLINE  ONLINE       srv2                     STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       srv1                     STABLE
               ONLINE  ONLINE       srv2                     STABLE
ora.asm
               ONLINE  ONLINE       srv1                     Started,STABLE
               ONLINE  ONLINE       srv2                     Started,STABLE
ora.net1.network
               ONLINE  ONLINE       srv1                     STABLE
               ONLINE  ONLINE       srv2                     STABLE
ora.ons
               ONLINE  ONLINE       srv1                     STABLE
               ONLINE  ONLINE       srv2                     STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       srv2                     STABLE
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       srv1                     STABLE
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       srv1                     STABLE
ora.MGMTLSNR
      1        ONLINE  ONLINE       srv1                     169.254.157.132,STAB
                                                             LE
ora.cvu
      1        ONLINE  ONLINE       srv1                     STABLE
ora.mgmtdb
      1        ONLINE  ONLINE       srv1                     Open,STABLE
ora.oc4j
      1        ONLINE  ONLINE       srv1                     STABLE
ora.rac.db
      1        ONLINE  ONLINE       srv1                     Open,STABLE
      2        ONLINE  ONLINE       srv2                     Open,STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       srv2                     STABLE
ora.scan2.vip
      1        ONLINE  ONLINE       srv1                     STABLE
ora.scan3.vip
      1        ONLINE  ONLINE       srv1                     STABLE
ora.smrtest.db
      1        ONLINE  ONLINE       srv1                     Open,STABLE
      2        ONLINE  ONLINE       srv2                     Open,STABLE
ora.srv1.vip
      1        ONLINE  ONLINE       srv1                     STABLE
ora.srv2.vip
      1        ONLINE  ONLINE       srv2                     STABLE
--------------------------------------------------------------------------------
[root@srv1 disks]#

[root@srv1 disks]# srvctl status database -d smrtest
Instance smrtest1 is running on node srv1
Instance smrtest2 is running on node srv2
[root@srv1 disks]#
SQL> select INST_ID,INSTANCE_NUMBER,INSTANCE_NAME,STATUS from gv$instance;

   INST_ID INSTANCE_NUMBER INSTANCE_NAME    STATUS
---------- --------------- ---------------- ------------
         2               2 smrtest2         OPEN
         1               1 smrtest1         OPEN

SQL>
SQL> sho parameter listener

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
listener_networks                    string
local_listener                       string       (ADDRESS=(PROTOCOL=TCP)(HOST=
                                                 192.168.56.82)(PORT=1521))
remote_listener                      string       srv-scan:1521
SQL>

SQL> sho parameter service

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string      smrtest
SQL>



Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)