[Oracle Cloud] - Creating an Oracle Database Deployment

Creating an Oracle Database Deployment in Oracle Public Cloud:

In this blog post, I will illustrate the steps to deploy an Oracle Database Deployment in Oracle Public Cloud. Assuming you have access to Oracle identity account and have the DBAAS Database Administrator role assigned to your service account to start creating database deployments in Oracle Public Cloud.

After login to the My Services Console, select the “Oracle Database Cloud Service” from the hamburger option just left to the services pages. 

Initially when you don’t have any Database deployments created then you would be shown the page like one depicted below. Here there is no Oracle Database Deployment is created and we will start creating a Oracle Database Deployment now.

Step: 1 – Click on the “Create Service” option in the services region of the “Oracle Database Cloud Service” page

Step : 2 – Once you click on the Create Service option, you will be displayed the following screen where you specify the Service Name, Service Description about the service being created, select Region in which you would like your Oracle Database Deployment to be hosted in.

Select appropriate Software Release and Software Edition and Database Type(there are multiple options to select from Database Type i.e. Single Instance, Database Clustering with RAC, Hybrid DR….)

In this demo article, I am creating a Single Instance database deployment, Oracle Database 12c Release 2 Enterprise Edition Database Deployment.

Choose the option as per your need and click on Next.

Step : 3 – Now you would be moved to the following “Service Details” page to provide your Database Configurations, Backup and Recovery Configuration(In this case, I choose the value “none” for Backup Destination as I don’t want my Oracle Database Deployment to be backed up automatically, There are other options as well to choose from whether you want to backup your Database Deployment to both Cloud Storage and Local Storage or Cloud Storage only).

In the SSH Public Key field, click on the Edit button, Here you would be required to assign one Public key for the database deployment . You will be given three options for Public key here as explained here under.

1 - Choose "Key File Name", if you have already generated the key pairs on your client machine then browse to select the Public key to upload here on Compute Node.

2 - Select the "Key Value" option. Open the public key file in one of the text editor on your client machine and copy the complete public key contents and paste in the right area of this option without any line breaks.

3 -  Choose option "Create a New Key" if you have not already generated the key pairs beforehand. Oracle Database Deployment Create Service wizard provides you flexibility to generate the key pairs here itself. Click on "Enter" then this GUI will generate public/private key pairs for you automatically and give you the option to download the key pairs on your client machine for future use.

Please remember that private key in the downloaded key pair will be used when you connect to the Compute Node using SSH/Putty.

Once you are one with the key pairs work, you can click on the "Advanced Settings" if you would like to change the Listener Port to a none-default port, you can also change Timezone, Database Character Set, Database Deployment National Character Set.

You can check the "Enable Oracle Golden Gate" option if you wish to enable Oracle Golden Gate replication settings, etc.

Click Next.

Step 4 - Now, you will be displayed the summary page of options you have selected for your Oracle database deployment to review once before actually creating the Oracle database deployment, This is the last chance for you to review the configurations selected for your Oracle Database Deployment and go back and change a setting for the database deployment if required, before clicking on "Create Service" tab.

Once you clicked on "Create Service" tab, Oracle database deployment service creation starts now. You would see that status of database deployment is in "Creating service" status now.

You can go and grab a cup of coffee while the service is being created, oh yeah, Oracle doesn't prohibit you from getting one :-)

When Oracle Database Deployment Service Creation starts, then a New Virtual Machine is created for your and one Public IP is assigned to the VM/Compute Node. Oracle Linux is then automatically installed to the Compute Node, Oracle Software gets installed, and Oracle Database instance gets created for you.

In the end, when service creation completes then Oracle database deployment service status changes to "Ready", you can connect to the Compute Node where database deployment is running using the Public IP assigned to your Host name and starts playing with Oracle Database Cloud Service.......

Hope it would help in understanding how we create a Oracle Database Deployment in Oracle Public Cloud.....!!