Steps to create 2 node rac instance in cloud

How to create RAC in cloud?

Hello DBA's,

Please find the steps to create RAC instance in oracle cloud. I have covered most of the steps with screen shots. So you must be able to create service in cloud without any issue.

Make sure you have paid or trial account to the oracle cloud in order to make services. Please log in to cloud portal and navigate to dashboard. I logged in with the link below and you can use the link sent in the email by oracle. 

URL :  https://myaccount.cloud.oracle.com/mycloud/faces/dashboard.jspx

Click Oracle database cloud service

Below page will display what are all services are attached to your account. To create new service, click create service button.

Before we create service we need private and public keys for SSH access which we need to supply while creating service. Please download and install putty key generator.

Click generate button and drag mouse in the given space to generate public and private keys.

Supply the password and save private key in *.ppk format. Please make sure to remember the password, we need this password to access the servers once they are created.

To save public key dont use save public key button as we did for private key since it wont work in cloud. Service creation will result into failed status. Copy the key as highlighted below, Open a notepad and paste it there. Save it into *.pub format. Now, we have created our public and private keys. We are good to create service now.

- Select Enterprise edition - Extreme performance in order to create RAC. Or else you cant see RAC option from the drop down menu.
- Select Database clustering with RAC in db type.

 - Provide service name
- Supply the password (This password needed to access sys schema)
- Since i had trial account i can create only 2 node cluster. If you have paid account, create node type as per your requirement.
- I have selected backup container to none since i dint want to take backup. If you want to schedule backup you need to create container before you create service.

At ssh public key section click edit and upload the public key which we created.

- Review the configuration and click create to create service

Once you create the service oracle may take 2-3 hours to create service and compute nodes. You can monitor the status in activity tab.

Once service is created click the service name to find the ip addresses of the nodes.

To access the servers please do the below. Open putty, click ssh --> Auth and click browse. Select the private key which you created through putty generator. To start listener, click icon in the actions menu and enable to listener. I have highlighted the same in the picture below.

In order to connect to db you need to start the listeners from console.  Please click the icon below and select access rules. start all the highlighted listeners below.

You can access the below users in the nodes.

- OPC
- ORACLE
- ROOT
- GRID

Excpet opc user you cant log into the nodes. Putty will throw an error if you try to do so. In order to log in as oracle, root or grid user. Initially log in as opc user then sudo to any of the user (oracle, root or grid).

Ex : Sudo su - grid
sudo su - root
sudo su - oracle

Thanks!
Hope it helps. You are encouraged to point out if i have anything provided incorrectly and feel free to add more info.