Beginner Series, Oracle

My Cloud Services DBaaS: Configuring the Oracle Cloud Database Service

My Cloud Services DBaaS

I went ahead and jumped on the bandwagon and signed up for my very own Oracle Cloud Services Account. They make it too easy, so let’s jump right in and create a new Database Service. Obviously you will need to sign-up and get an account, which can be done right here: Cloud Promotion. Once you’ve gone through the sign-up process and received your credentials, come back here and we can get started.

I would also suggest that you go ahead and create an SSH Key. It is required for remote connections from tools such as SQL Developer. If you need some instructions on generating a key, check out my Generate an SSH key on macOS post.

1. Log into your account with the provided credentials.

Oracle Cloud login screen

2. A successful login should present you with your dashboard where you have access to all your services.

My Cloud Services Dashboard

3. Click on “Create Instance” and select Database

My Cloud Services selection screen

4. As you can see I have already created a Database Instance and you’ll get there too. Just click in the “Create Service” button.

My Cloud Services DBaaS Screen

 

5. Next provide the basic service instance information. The only change I’d recommend is the choosing the Database 12c Release 2 version of the database and leave the remaining options alone. Click Next.

My Cloud Services DBaaS Screen 2

6. On the Service Details screen, we are going to accept the default values for DB name (SID), PDB Name, Usable Database Storage, and Compute Shape. This will also be a good time to make sure you have an SSH Public Key.

Enter and confirm the Administration Password, upload your SSH Public Key. Directions for creating one macOS can be found here. Also choose “None” from the Backup Destination dropdown. Click Next

My Cloud Services DBaaS Screen 2

7. Verify everything on the Confirmation screen is acceptable. Click Create.

My Cloud Services DBaaS Screen 3

At this point, we will wait for the services to be provisioned.

…. and approximately 21 minutes later, we have a newly provisioned 12cR2 database.

8. Click on the Service name (Blog-Example) to get the details of your new Database instance. Pay particular attention to the IP address as you will need this later to connect to the DB instance.

9. Finally we need to open a port 1521 via the Access Rules enable remote connectivity to the database. Click the dropdown menu icon beside the instance name, and choose Access Rules.

Access Rules

10. Click the Actions dropdown for Rule Name: ora_p2_dblistener and select Enable to allow access to port 1521.

Enable Port 1521

11. Click the enable button on the Enable Access Rule dialogue box.

Enable 1521 Access Rules

1521 Success page

12. Finally you can connect remotely to your database via a tool such as SQLcl. I have added an entry in my /etc/hosts file to resolve the blog-example name to its IP address 129.150.65.254

SQLcl

 

Next we will learn how to use SQL Developer to connect to a database instance.

Enjoy!


Also published on Medium.

3 Comments on “My Cloud Services DBaaS: Configuring the Oracle Cloud Database Service