One of the nice features in Oracle Cloud is that they have incorporated a couple of extra tools available for you to use to monitor and maintain your Oracle DBaaS instance easily.
You can access Database Monitor if you have opened up the firewall for HTTP/HTTPS by accessing the URL
(or you could use an SSH tunnel if you didn’t want to open it up).
Or you can navigate to it from the home page of (https://<your.public.ip.address>) and clicking the Database Monitor link.
You will be prompted for a username and password to login
Now here’s where I wished I’d read the documentation before trying to “just guess”. I assumed that the username would be ‘system’ or ‘sysdba’ or some other DBA level account (perhaps the username / email address I used to sign up to the Cloud service).
But no…it turns out the default username is dbaas_monitor
The password is the same password you specified when you created the DBaaS instance.
Once you’ve entered those and (hopefully) logged in, you should see the DBaaS Monitor homepage
As you can see we get a nice overview of the ‘health’ of our DBaaS Instance, including a summary of waits, CPU utilization and alert log entries.
We can drill into some CPU metrics
Get a nice (simplified) overview of storage
and perform some (very simplified) management tasks like starting and stopping the database.
So is this a replacement for Enterprise Manager? Absolutely not, it has very limited functionality, however it is also pretty light-weight so it’s potentially a faster way of checking the health of your DBaaS instance before you drill into EM etc.
I do hope Oracle extends and adds functionality to DBaaS Monitor in the future since it has a lot of potential.