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.

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

3. Click on “Create Instance” and select Database

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.

 

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.

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

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

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.

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

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

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

 

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

Enjoy!