As a Database Infrastructure Administrator, monitoring the status and performance of the components in a DB system is essential as this in turn determines the status and performance of the database.

Database Management provides a unified view of the components in the Oracle Cloud Database System on the Database System details page and enables you to monitor their status over a selected period of time. On the Database System details page, you can monitor:

• Single Instance Oracle Cloud Database System, which includes:
  • Oracle Databases
    • CDBs
    • PDBs
    • Non-CDBs
  • Local listeners
• RAC Oracle Cloud Database System and Single Instance Oracle Cloud Database System on RAC One Node, which include:
  • Oracle Databases
    • CDBs
    • PDBs
    • Non-CDBs
  • Clusters
    • Standard clusters
    • Flex clusters
  • ASM instances
  • Listeners
    • Local listeners
    • SCAN listeners
    • ASM Net listeners

For more information on these components, see Oracle Database documentation.

Before you go to the Database System details page to monitor the Oracle Cloud Database System, you must complete the prerequisite tasks, obtain the permissions required to monitor the Oracle Cloud Database System, and discover the Oracle Cloud Database System and connect to the components. For information, see Get Started.

To go to the Database System details page and monitor the Oracle Cloud Database System:

1. Sign in to the Oracle Cloud Infrastructure console.
2. Open the navigation menu, click Observability & Management. Under Database Management, click Administration.
3. On the left pane, select the compartment in which you discovered the Oracle Cloud Database System and the Oracle Database cloud solution in the Deployment type filter.
4. Click the Oracle Cloud Database System display name link in the Database System column.

   The Database System details page is displayed.

On the Database System details page, you can:

• Click Rediscover Database System to rediscover the Oracle Cloud Database System and register any new components added to the DB system. For information, see Discover Oracle Cloud Database Systems.
• Click More actions to perform the following tasks:
  • Click Rename to rename the Oracle Cloud Database System.
  • Click Add tags to add tags to the Oracle Cloud Database System. For information, see Working with Resource Tags.
  • Click View connectors to view the connectors used to connect to the Oracle Cloud Database System and the components. In the View connectors panel, click the display name of the connector to go to the Connector details page and view connector details.
  • Click Disable Diagnostics & Management to disable Database Management for the Oracle Cloud Database System. If Database Management is disabled on an Oracle Cloud Database System, then it stops monitoring the components and you can no longer perform tasks such as rediscovering the Oracle Cloud Database System. Note that even when Database Management is disabled for the Oracle Cloud Database System, Diagnostics & Management remains enabled for the databases in the DB system.
  • Click Deregister Database System to deregister the Oracle Cloud Database System components. Note that even when the Oracle Cloud Database System is deregistered, the databases in the Oracle Cloud Database System are not deregistered and they continue to be monitored and managed.
• View Database System information, which includes details such as the OCID and home location of the Oracle Cloud Database System. In the Database System information section, you can:
  • Click the Associated system link to go to the details page in the Oracle Database cloud solution’s interface.
  • Click the compartment link to go to the Compartment details page.
  • Monitor the total number of open alarms and the number of alarms by severity for the Oracle Cloud Database System. Note that an alarm is only displayed in Database Management if the OCID of the resource is specified using the resourceId dimension when creating the alarm. You can click the number of alarms to access the Alarms panel and review the list of open alarms. For information, see Monitor Alarms for Oracle Cloud Database Systems.
• Click the Tags tab to add, view, edit, or remove tags. For information, see Working with Resource Tags.
• Monitor the components in the Oracle Cloud Database System in the Summary section for the time period selected in the Time period drop-down list.
  • Monitor the status of each component during the selected time period in the Monitoring status timeline section. The monitoring status indicates whether Database Management can collect monitoring metrics for the component. The color of the blocks denotes the monitoring status and the number of blocks denotes the time slots within the selected time period over which status is checked. For example, if the default time period, Last 60 min, is selected, then each block represents a period of two minutes. Here's information on what the color of the blocks in the Monitoring status timeline denotes:
    • Green: All the components of a particular component type are available and monitored during the selected time period.
    • Amber: Some of the components of a particular component type have monitoring issues during the selected time period.
    • Red: All the components of a particular component type are down during the selected time period.
    • Grey: All the components of a particular component type have monitoring issues during the selected time period.
  • Monitor the components in the Oracle Cloud Database System over the selected time period.
    Note
    
    The Cluster and ASM sections are only displayed on the Database System details page of a RAC Oracle Cloud Database System and Single Instance Oracle Cloud Database System on RAC One Node.
    • Cluster: Monitor the status of the cluster and cluster nodes in the Oracle Cloud Database System. In this section, you can:
      • Click the display name of the cluster to go to the Cluster details page.
      • Click the link in the Cluster connection column to go to the Connector details page to view connector details.
      • Click the Actions icon () for the cluster to perform tasks such as going to the Cluster details page or editing the connection.
    • Databases: Monitor the status of the databases in the Oracle Cloud Database System. You can select the Show Managed Databases only check box to only view the databases for which Diagnostics & Management is enabled. In addition, you can select an option in the View by drop-down list in the upper-right corner of the section to filter the databases and view CDBs and PDBs or RAC instances.

      Click the display name of the database to go to the corresponding Managed database details page. For information on the tasks you can perform to monitor and manage a database using Diagnostics & Management, see Monitor and Manage a Specific Managed Database.

    • ASM: Monitor the status of the ASM instances in the Oracle Cloud Database System. In this section, you can:
      • Click the display name of the ASM to go to the ASM details page.
      • Click the link in the ASM connection column to go to the Connector details page to view connector details.
      • Click the Actions icon () for the ASM to perform tasks such as going to the ASM details page or editing the connection.
    • Listener: Monitor the status of the listeners in the Oracle Cloud Database System. In this section, you can:
      • Click the display name of the listener to go to the Listener details page.
      • Click the link in the Listener connection column to go to the Connector details page to view connector details.
      • Monitor node status in the Node status column for listeners in a single instance Oracle Cloud Database System. Monitor the associated cluster nodes and their status in the Cluster nodes column for listeners in the RAC Oracle Cloud Database System and Single Instance Oracle Cloud Database System on RAC One Node.
      • Click the Actions icon () for a listener to perform tasks such as going to the Listener details page or editing the connection.
• Click Work requests on the left pane under Resources to monitor the work requests pertaining to the Oracle Cloud Database System.