Deploy Oracle Grid Infrastructure and Oracle RAC

Deploying Oracle Grid Infrastructure and Oracle RAC database involves configuring your Oracle Automatic Storage Management (Oracle ASM) Disks, installing Oracle Grid Infrastructure in silent or GUI mode, rebooting Oracle Clusterware, installing Oracle RAC database software, creating an Oracle RAC Database, and verification of your deployment.

The following steps describe how to deploy Oracle Grid Infrastructure and Oracle RAC in your Private Cloud Appliance system.

1. Use asmcmd or asmlib to label the disk. For example: GI_HOME/bin/asmcmd afd_label diskgroup_name disk_with_full_path --init. Refer to the Oracle Grid Infrastructure Installation Guide for more details.

   /u01/app/21.0.0/grid/bin/asmcmd afd_label OCR /dev/sdc ––init
   

2. Create a response file. You can use the sample response file in GI_Home/install/response and add the variable values.
3. Install Oracle Grid Infrastructure in silent mode. For example: GI_HOME/gridSetup.sh -silent -responseFile responsefile_name_with_full_path.

   /u01/app/21.0.0/grid/gridSetup.sh -silent -responseFile /home/oracle/gridsetup.rsp

4. Set the environment variable HAIP_UNSUPPORTED=TRUE.
   Oracle Private Cloud Appliance X9-2 Rack uses the IP range 169.254.0.0/16 for iSCSI connections to the boot and block volumes, instance metadata, and other services. This impacts HAIP communications used by the private network causing Oracle Grid Infrastructure installation to fail. This environment variable needs to be set for HAIP communications to succeed.

   $ export HAIP_UNSUPPORTED=TRUE

5. Execute the ./root.sh command on every node.

   $ ./root.sh

6. Use the Cluster Verification utility Cluvfy to verify post installation. For example: GI_HOME/bin/cluvfy -post crsinst -n node1, node2.

   u01/app/21.0.0/grid/bin/cluvfy -post crsinst -n racvm1,racvm2

7. Check Oracle Clusterware resources with crsctl command.

   [oracle@racvm1 ~]$ crsctl stat res -t 
   --------------------------------------------------------------------------------
   Name Target State Server State details 
   --------------------------------------------------------------------------------
   Local Resources
   --------------------------------------------------------------------------------
   ora.LISTENER.lsnr
    ONLINE ONLINE racvm1 STABLE
    ONLINE ONLINE racvm2 STABLE
   ora.chad
    ONLINE ONLINE racvm1 STABLE
    ONLINE ONLINE racvm2 STABLE
   ora.net1.network
    ONLINE ONLINE racvm1 STABLE
    ONLINE ONLINE racvm2 STABLE
   ora.ons
    ONLINE ONLINE racvm1 STABLE
    ONLINE ONLINE racvm2 STABLE
   --------------------------------------------------------------------------------
   Cluster Resources
   --------------------------------------------------------------------------------
   ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
    1 ONLINE ONLINE racvm1 STABLE
    2 ONLINE ONLINE racvm2 STABLE
   ora.DATA.dg(ora.asmgroup)
    1 ONLINE ONLINE racvm1 STABLE
    2 ONLINE ONLINE racvm2 STABLE
   ora.LISTENER_SCAN1.lsnr
    1 ONLINE ONLINE racvm2 STABLE
   ora.LISTENER_SCAN2.lsnr
    1 ONLINE ONLINE racvm2 STABLE
   ora.LISTENER_SCAN3.lsnr
    1 ONLINE ONLINE racvm1 STABLE
   ora.asm(ora.asmgroup)
    1 ONLINE ONLINE racvm1 STABLE
    2 ONLINE ONLINE racvm2 Started,STABLE
   ora.asmnet1.asmnetwork(ora.asmgroup)
    1 ONLINE ONLINE racvm1 STABLE
    2 ONLINE ONLINE racvm2 STABLE
   ora.cdp1.cdp
    1 ONLINE ONLINE racvm2 STABLE
   ora.cdp2.cdp
    1 ONLINE ONLINE racvm2 STABLE
   ora.cdp3.cdp
    1 ONLINE ONLINE racvm1 STABLE
   ora.cvu
    1 ONLINE ONLINE racvm2 STABLE
   ora.qosmserver
    1 ONLINE ONLINE racvm2 STABLE
   ora.racvm1.vip
    1 ONLINE ONLINE racvm1 STABLE
   ora.racvm2.vip
    1 ONLINE ONLINE racvm2 STABLE
   ora.scan1.vip
    1 ONLINE ONLINE racvm2 STABLE
   ora.scan2.vip
    1 ONLINE ONLINE racvm2 STABLE
   ora.scan3.vip
    1 ONLINE ONLINE racvm1 STABLE
   --------------------------------------------------------------------------------
   [oracle@racvm1 ~]$ 

8. Use runInstaller as the RDBMS user to install the Oracle RAC database software in silent mode, or in GUI mode. Refer to the Oracle Real Application Clusters Installation Guide for more details.
   Example of silent mode: RDBMS_HOME/runInstaller -silent -responseFile response_file_name_with_full_path.

   /u01/app/oracle/product/21.0.0/dbhome_1/runInstaller -silent -responseFile 
   /u01/app/oracle/product/21.0.0/dbhome_1/install/response/db_install.rsp

9. Use Oracle Database Configuration Assistant (DBCA) to create an Oracle RAC database in silent mode, or in GUI mode. Example of silent mode: RDBMS_HOME/bin/dbca -silent -createDatabase -responseFile response_file_name_with_full_path.

   [oracle@racvm1 ~]$ /u01/app/oracle/product/21.0.0/dbhome_1/bin/dbca -silent -
   createDatabase -responseFile 
   /u01/app/oracle/product/21.0.0/dbhome_1/assistants/dbca/dbca.rsp

10. Verify Oracle RAC is created successfully.

    [oracle@racvm1 ~]$ /u01/app/oracle/product/21.0.0/dbhome_1/bin/srvctl status db -d 
    PCARACDB
    Instance PCARACDB1 is running on node racvm1
    Instance PCARACDB2 is running on node racvm2
    oracle@racvm1 ~]$ crsctl stat res -t|grep -i db
    ora.pcaracdb.db
     1 ONLINE ONLINE racvm1 Open,HOME=/u01/app/o
     racle/product/21.0.0
    /dbhome_1,STABLE
     2 ONLINE ONLINE racvm2 Open,HOME=/u01/app/o
     racle/product/21.0.0
    /dbhome_1,STABLE