By following the steps outlined in this blog, you will be able to configure a Database in Oracle Cloud Interface.
The steps in the entire process can comprise the following:
Considering that the following pre-requisites are already in place:
Open WinSCP & Click on Tools -> Run PuTTYgen
To generate the private & public keys, Click on Generate and move over the mouse around the blank area in the box as shown above:
Key gets generated, as shown in following screenshot
Click on Save private key to in your local system. Add the key passphrase (Password) and re-enter it again to confirm passphrase.
For public key, copy the Key content in a file on your local system which is shown in the following snippet. Sometimes it is required in case of any issue in accepting public key file.
Copied key content of public key can be used in such cases. Then click on Save Public Key to save the file in the same location where private key was stored in step 3.
Note: Public key format starts with ssh-rsa & end with rsa-key-20211015
Save public key with .pub & private key with.ppk extension
After generating and saving both the keys, you can go back to the Cloud Portal.
This section involves steps in creating an Oracle Database in Public Subnet on OCI.
Login to OCI console with your tenant. Here ohravi is the Tenant I already created.
So below is the URL _https://cloud.oracle.com/?tenant=ohravi_
Select the links which are highlighted in Box as per below snippet
Select the AD & shape as VM with standard shape as per below snippet on the options available
Select the highlighted/indicated in Box as per below snippet on the options available while configuring the DB system
Paste your Public key created earlier in Section 1 point 5 as shown in the following screenshot
Select a name for the VCN, I have used as POC_VCN & the subnet.
Provide a database name here. I am using POC & 19c in my example.
Select create DB system option as indicated in the following snippet
It takes 50-60 minutes to keep the instance Up & Running.
When the DB creation is done, the status changes from Provisioning to Available as shown in the following snapshot.
Login to the OCI Console, & navigate to Database Section select database POC_Ravi
When you click on pocDB above, next page will show the Public IP address as per the following snippet. Use that IP address in connection as the Host Name in the next step
Host Name (or IP Address): Enter opc@Public IP of your instance
Port: Enter 22
Connection type: Select SSH
Now, expand SSH and select Auth and browse your private key and click open.
Click on Open
Switch to Oracle user to connect with the SQLPLUS
The blog explains the basic steps on configuring a Database on the Public subnet along with SSH Keys generation. Also, the above explained steps help connecting to the Database using the SSH keys which are essential for an Oracle Cloud DBA’s routine activity.
Use the Feedback tab to make any comments or ask questions. You can also start a conversation with us.