We will create brand new 12c Database instance, enable remote access and using Oracle SQL developer we will connect from our local machine to the newly created database. Finally we will show how to monitor the database instance with OEM Database Express 12c and DBaaS Monitor.
Creating Database as a Service Instance in Oracle Database Cloud.
We will create our demo database with a backup configuration enabled using both, Cloud Storage and Local Storage. This will allow us in the future creating Oracle SOA Cloud Service instance.
Enable secure network access
Next, we have to open some ports to enable secure network access to the database service.
There are several ways to enable secure network access. SSH tunnelling, VPN and another option is to open specific ports (closed by default) to allow tools like SQL Developer connecting to the database from a remote locations.
In this example we will open default port (1521):
Connecting to a Service Instance
Now we are ready to connect to Database as a Service instance from a remote location with Oracle SQL Developer. We already know the public IP address and SID of our container database:
We will be using sys account and we will login to the database as sysdba:
Monitoring the Database Instance in a Service Instance
We can monitor database instance using available tools like DBaaS Monitor and OEM Database Express 12c. Again, we have to enable secured access. I recommend to enable access via HTTPs only. Note that in order to login to Database Express 12c we are using database sys user account while in order to login to DBaaS Monitor we are using different account “dbaas_monitor”.
Enabling access and monitoring database instances with OEM Database Express 12c and DBaaS Monitor:
Oracle Database Cloud Service documentation available here.
Please leave comments down below. Also if you like this article feel free to share it.
The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.