12 Days of #Cloud: Creating a RAC #DBaaS
12 Days of #Cloud: Day 2
Today, let’s create a 2 node RAC instance on Oracle Cloud. The database creation steps are similar.
First, choose the release of the database.
The Service Packaging definition says “Standard and Enterprise packages include their respective on-premises capabilities and add Transparent Data Encryption. High Performance adds all database options excluding: RAC, In-Memory and Active Data Guard. Extreme Performance includes all options.”
So, to create the RAC instance, we need to choose “Extreme Performance” service.
In the Service Details screen, choose RAC checkbox. You have the following options:
- Data Guard
- Golden Gate
As soon as you choose RAC, the other options go away. So at this time, it looks like the RAC database may not have Data Guard or Golden Gate.
Here are all the options chosen in Service Details.
I chose 1 CPU machine but looks like RAC instance does not like that.
All is good, the summary screen shows (note the compute shape):
That’s it. Rest of the work is done by Oracle Cloud for you.
After about 1+ hours, the RAC instance is created.
The database service has two nodes, 4 OCPUs, 30GB memory.
Enable the ports to connect to database using SQL*Net and to use OEM Database Express. The menu does not have an option to view Dbaas Monitor with the current version of Cloud.
Let’s login to the database backend servers, and verify the services.
The disk allocation on both servers are pretty identical. The standby activation can be completed only after we make sure there are no errors.
The three file systems /dev/asm/data-369, fra-219 and redo-506 are ACFS (u02, u03 & u04) and shared on both systems.
Everything seems to have configured right.