Oracle DBaaS 1z0-160 part 29 :- DBaaS monitor in Oracle cloud

How to access DBaaS monitor from console

Please open port 443 (https) using “Access Rules”

Please enable oar_p2_httpssl

Now the port ora_p2_httpssl open now

If you do not want to enable port 443 from console,you need to enable port forwarding.

If you enable port forwarding,you need to open using localhost after enable putty session.

When prompted for a user name and password, enter dbaas_monitor as the user name and the password specified during the database deployment creation process, and then click OK

After logging to DBaaS monitor,You can see below

Using Oracle DBaaS Monitor

Oracle DBaaS Monitor provides monitoring and management of the Oracle database and listener on Oracle Database Cloud Service.


This section does not apply to database deployments that use Oracle Real Application Clusters. Such deployments do not currently include Oracle DBaaS Monitor.

The following are key things you can do using DBAAS Monitor

  • Administering the Listener
  • Starting and Stopping the Database Instance
  • Viewing and Modifying Initialization Parameters
  • Viewing User Account and Expiring Password Information
  • Viewing Tablespace and Segment Space Usage
  • Changing the TDE Keystore Password
  • Viewing Alert Log Entries and Checking for Errors
  • Viewing Real Time SQL Monitor
  • Administering Pluggable Databases.

Oracle DBaaS Monitor provides monitoring and management of the Oracle database and listener on Oracle Database Cloud Service.

DBaaS Monitor provides quick and easy access to a variety of information about the database instance running on a database deployment:

  • Overall, how much storage is allocated to tablespaces, and how much of that storage is used.
  • For each tablespace, how much storage is allocated and how much of that storage is used, with additional drill-down capabilities to view segments.
  • A real-time graph showing wait events across several selectable categories.
  • The alert log, with log searching capabilities.
  • A list of open user sessions, with drill-down capabilities to view session details such as the last SQL statement, explain plan, waits, contention, and so on.
  • A list of initialization parameters, with the ability to change parameter values, both in memory and in the SPFILE.
  • Indication of whether certain database options are enabled.
  • Monitoring of current and past SQL Developer PDB uploads.
  • A list of the SQL statements that are being monitored in the database, with real time display of details such as the status, duration, degree of parallelism, and so on.

You can use DBaaS Monitor to view information about the compute node:

  • CPU utilization information in an interactive table format, with automatic refresh intervals
  • OS process information, with filtering and automatic refresh capabilities DBaaS Monitor also provides the following management capabilities:
  • Start up and shut down the database instance.
  • Open and close a pluggable database.
  • Create and drop a pluggable database.
  • Plug in and unplug a pluggable database.
  • Clone a pluggable database.
  • Start and stop the listener.

There are various menus by which you can administer Database.

You can check status of listener and turn off if required

You may also stop/start database using this menu of DBaaS monitor

Please keep in my mind following notes when you shutdown database using DBaaS monitor

You can use DBaaS Monitor to shut down the database instance in IMMEDIATE mode. In this mode, no new connections are allowed. No new transactions are allowed to be started and any uncommitted transactions are rolled back.If you need to shut down the database instance in any other mode (ABORT,NORMAL, or TRANSACTIONAL), use SQL*Plus instead of DBaaS Monitor.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>