Installation of Oracle RAC on Oracle Cloud Infrastructure(OCI)

In this post, we will see the creation of Oracle RAC on Oracle Cloud Infrastructure (OCI)

After login to your OCI account, Click on the Menu and choose Bare Metal, VM, Exadata option under Database category.

First, you need to select the compartment name and then click on “Create DB System”

As shown in the below image. Provide all the information.

• Select a compartment
• Name your DB system – DBSVM
• Select an availablity domain as per your subscription
• Select a shape type – Virtual Machine
• Select a shape – VM.Standard.2.2

Note: VM.Standard.2.2 shape contains 2 nodes.

• Set the Total node count is 2.
• OCI for storage management : Grid infrastructure
• Choose default Available Storage: 256

• Provide the Cluster Name : SKANTCLST
• Upload your Public Key
• Choose a license type : License Included

Step 7 :Next in network information ,provide  VCN detail and client subnet detail. Then provide host prefix. According to the host prefix provided by you , you will see host and domain URL.

• Database name : SKANTORC
• Check the Display all available versions.
• Database version – 19.5.0.0.
• PDB name : SKANTPDB1
• Password of sys user.

• Select the workload type : OLTP (as per your requirement)
• Optionally, select enable automatic backups

Click on Create DB System.

Wait for few mins and your RAC db will be ready for use.

Click on DBSVM database and you will able to get all the information.

By selecting Nodes from left side panel, you can see nodes information.

Now, use the private key and public IP of any node and connect to server with OPC user for getting the more details.

login as: opc
Authenticating with public key "rsa-key-20200220"
Last login: Thu Feb 27 17:01:07 2020 from 183.83.146.62
[opc@skanthost2 ~]$ sudo su - grid
Last login: Thu Feb 27 17:26:46 UTC 2020
[grid@skanthost2 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.COMMONSTORE.advm
               ONLINE  ONLINE       skanthost1               STABLE
               ONLINE  ONLINE       skanthost2               STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       skanthost1               STABLE
               ONLINE  ONLINE       skanthost2               STABLE
ora.chad
               ONLINE  ONLINE       skanthost1               STABLE
               ONLINE  ONLINE       skanthost2               STABLE
ora.data.commonstore.acfs
               ONLINE  ONLINE       skanthost1               mounted on /opt/orac
                                                             le/dcs/commonstore,S
                                                             TABLE
               ONLINE  ONLINE       skanthost2               mounted on /opt/orac
                                                             le/dcs/commonstore,S
                                                             TABLE
ora.net1.network
               ONLINE  ONLINE       skanthost1               STABLE
               ONLINE  ONLINE       skanthost2               STABLE
ora.ons
               ONLINE  ONLINE       skanthost1               STABLE
               ONLINE  ONLINE       skanthost2               STABLE
ora.proxy_advm
               ONLINE  ONLINE       skanthost1               STABLE
               ONLINE  ONLINE       skanthost2               STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       skanthost1               STABLE
      2        ONLINE  ONLINE       skanthost2               STABLE
ora.DATA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       skanthost1               STABLE
      2        ONLINE  ONLINE       skanthost2               STABLE
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       skanthost2               STABLE
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       skanthost1               STABLE
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       skanthost1               STABLE
ora.RECO.dg(ora.asmgroup)
      1        ONLINE  ONLINE       skanthost1               STABLE
      2        ONLINE  ONLINE       skanthost2               STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       skanthost1               Started,STABLE
      2        ONLINE  ONLINE       skanthost2               Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       skanthost1               STABLE
      2        ONLINE  ONLINE       skanthost2               STABLE
ora.cvu
      1        ONLINE  ONLINE       skanthost1               STABLE
ora.qosmserver
      1        ONLINE  ONLINE       skanthost1               STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       skanthost2               STABLE
ora.scan2.vip
      1        ONLINE  ONLINE       skanthost1               STABLE
ora.scan3.vip
      1        ONLINE  ONLINE       skanthost1               STABLE
ora.skanthost1.vip
      1        ONLINE  ONLINE       skanthost1               STABLE
ora.skanthost2.vip
      1        ONLINE  ONLINE       skanthost2               STABLE
ora.skantorc_iad19m.db
      1        ONLINE  ONLINE       skanthost1               Open,HOME=/u01/app/o
                                                             racle/product/19.0.0
                                                             .0/dbhome_1,STABLE
      2        ONLINE  ONLINE       skanthost2               Open,HOME=/u01/app/o
                                                             racle/product/19.0.0
                                                             .0/dbhome_1,STABLE
--------------------------------------------------------------------------------

[grid@skanthost2 ~]$ crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online

[grid@skanthost2 ~]$ srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node skanthost2
SCAN VIP scan2 is enabled
SCAN VIP scan2 is running on node skanthost1
SCAN VIP scan3 is enabled
SCAN VIP scan3 is running on node skanthost1

[grid@skanthost2 ~]$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node skanthost2
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node skanthost1
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node skanthost1

[grid@skanthost2 ~]$ olsnodes -n
skanthost1      1
skanthost2      2

[grid@skanthost2 ~]$ ps -ef|grep pmon
oracle     546     1  0 16:05 ?        00:00:00 ora_pmon_SKANTORC2
grid     54703     1  0 15:30 ?        00:00:00 asm_pmon_+ASM2
grid     62375     1  0 15:32 ?        00:00:00 apx_pmon_+APX2
grid     65260 60830  0 17:33 pts/0    00:00:00 grep --color=auto pmon
[grid@skanthost2 ~]$

In the next post, we will create the Data Gaurd for this RAC setup on OCI.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp