Oracle Cloud DBaaS (Database as a Service)
Introduction
This document is designed as a Step by Step explanation of how to setup, connnect and monitor an Oracle Database using the DBaaS on the Oracle Cloud.
Note:
This document should be used in conjuction with the following documents:
Sections
1. Creating a Database using Oracle Cloud DBaaS
2. Connecting to the Cloud Database
3. Monitoring the Cloud Database
Creating a Database using Quick Start
I will review the steps for creating an Oracle Database on the Oracle Cloud using the DBaaS Quick Start Service. This service provides a limited set of choices but is quick and simple to setup. If you just need a database and not a server for other software this is a good choice.
To get started you will need to setup an account at cloud.oracle.com and log into the Oracle Identity Cloud(IDC) website. I will not review the account setup steps since your experience will probably differ depending on whether you are using the free account or a paid account.
Once you are logged in you should see the Oracle Cloud Services Dashboard. From the Dasboard you can setup a database, setup storage, do a database backup etc..
Choosing the Create Instance box brings up a selection of services. The Quick Start Services has the database creation selection that we need, so I will skip the “All Services” tab.
Clicking on the Create button for Database brings up a Confirmation page.
Clicking on the Download link starts the download of a zip file containing the public key, private key and a file with an initial password. Once the Download file is sent, the Create button becomes active: click on the button.
The Database creation process starts at this point. It takes approximately 30 minutes for the database service to be created. In the interim the page below is shown:
The text of the above page is misleading. To check the progress click on the refresh button next to the date or choose the Activity tab or the ‘Service Create and Delete History’
Once the database is created a summary page of the Instances will be shown.
Click on the name of the database to go to the page that has the information necessary to establish a connection.
Before a connection can be made the listener needs to be enabled. Go to the Access Rules page.
Enable the ora_p2_dblistener rule
For information on setting up a connection to the database, see the accompaning webpage document:Connecting to the Oracle Cloud Database
