Enable Diagnostics & Management for Oracle Cloud Databases

Before you enable Database Management Diagnostics & Management for Oracle Cloud Databases, you must:

You can enable Diagnostics & Management for Oracle Cloud Databases on the Database Details page of the respective Oracle Database cloud solution or on the Administration Managed databases page in Database Management.

To enable Diagnostics & Management for Oracle Cloud Databases in Database Management:

  1. Sign in to the Oracle Cloud Infrastructure console.
  2. At the top of the page, ensure that the region in which you want to enable Diagnostics & Management is selected.
    Note

    Cross-region monitoring and management of Oracle Databases is not available.
  3. Open the navigation menu, click Observability & Management. Under Database Management, click Administration.
  4. On the left pane, select a compartment in the Compartment drop-down list and the Oracle Database cloud solution in the Deployment type drop-down list.
  5. On the Managed databases page, click Enable Database Management.
  6. In the Enable Database Management panel:
    1. Specify the following details to select a database:
      1. Database type: Ensure that the correct Oracle Database cloud solution is selected.
      2. Depending on the option selected in the previous step, one of the following options is displayed:
        • Database system (for Base Database Service): Select the DB system in the Base Database Service. By default, the compartment selected on the Managed databases page is displayed, however, you can click Change compartment and select another compartment, if required.
        • VM cluster (for ExaDB-D and ExaDB-C@C): Select the cloud VM cluster that provides a link between the ExaDB-D or ExaDB-C@C resource and the database. By default, the compartment selected on the Managed databases page is displayed, however, you can click Change compartment and select another compartment, if required.
      3. Database home: Select the database home associated with the Oracle Cloud Database.
      4. Pluggable database: Select this check box if you're enabling Database Management for a PDB.
        Note

        • For Oracle Cloud Databases, Database Management only supports the monitoring and management of PDBs for Oracle Database version 19c and later.
        • If you're enabling Database Management for a PDB, then it must first be enabled on the associated CDB with the Full management option.
        • You can enable Database Management for a maximum of 10 PDBs in one CDB. If you want to increase the PDB limit, contact Oracle Support.
      5. Database name: Select the Oracle Cloud Database. If you're enabling Database Management for a PDB, then you must select the associated CDB in this field.
      6. Pluggable database name: Select the PDB. This field is only displayed if you're enabling Database Management for a PDB.
      7. Service name: The unique service name in the Database_Name.Host_Domain_Name format is automatically displayed, however, you can edit it, if required.
      8. Protocol: Select either the TCP or TCPS protocol to connect to the Oracle Cloud Database. By default, the TCP protocol is selected.
        Note

        If Oracle Data Guard is enabled on a DB system in the Base Database Service after Database Management was enabled for it using the TCPS protocol, then TCPS will have to be reconfigured. Enabling Data Guard is causing TCPS configuration to be overwritten, and it's recommended that TCPS is configured on the DB system after enabling Data Guard.
      9. Port: Enter the port number. If TCP is selected in the Protocol field, then port number 1521 is displayed by default and you can change it, if required.
      10. Database wallet secret: Select the secret that contains the database wallet from the drop-down list. This field is only displayed if TCPS is selected in the Protocol field. If an existing database wallet secret is not available, then select Create new secret... in the drop-down list. The Create database wallet secret panel is displayed and you can create a new secret. For information on database wallets and how to create a secret in the Vault service, see Oracle Cloud Database-related Prerequisite Tasks.

        Note that a service policy is required to grant Database Management (dpd) the permission to read the secret that contains the database wallet. If the service policy is not created, then the Service policy is required... message is displayed and you can click Add policy to view and automatically add it. The Oracle Cloud Infrastructure IAM service creates the policy and it's added to a collection of policies called DBMgmt_Service_Policy in the IAM service.

        For information on:

    2. Specify the database credentials for the connection to the selected Oracle Cloud Database.
      1. Database user name: Enter the database user name.
        Note

        If you're enabling Database Management for a database in an Oracle Data Guard configuration that contains a physical standby database in mounted state, you must ensure that the monitoring user has the SYSDG privilege.
      2. User password secret: Select the secret that contains the database user password from the drop-down list. If the compartment in which the secret resides is different from the compartment displayed, then click Change compartment and select another compartment.

        If an existing secret with the database user password is not available, then select Create new secret... in the drop-down list. The Create password secret panel is displayed and you can create a new secret. For information on database monitoring user credentials and how to save the database user password as a secret in the Vault service, see Oracle Cloud Database-related Prerequisite Tasks.

        Note that a service policy is required to grant Database Management (dpd) the permission to read the secret that contains the database user password. If the service policy is not created, then the Service policy is required... message is displayed and you can click Add policy to view and automatically add it. The IAM service creates the policy and it's added to a collection of policies called DBMgmt_Service_Policy in the IAM service.

        For information on:

    3. Depending on the Oracle Database cloud solution on which the Oracle Database is running, one of the following options is displayed:
      • Private endpoint information (for Base Database Service): Select the private endpoint that will act as a representation of Database Management in the VCN in which the Oracle Cloud Database can be accessed. If the compartment in which the private endpoint resides is different from the compartment displayed, then click Change compartment and select another compartment.

        You must ensure that the appropriate Database Management private endpoint is available. Here are the two types of Database Management private endpoints:

        • Private endpoint for single instance Oracle Cloud Databases in the Base Database Service.
        • Private endpoint for RAC Oracle Cloud Databases in the Base Database Service.

        If an existing Database Management private endpoint is not available, then select Create private endpoint... in the drop-down list to create one. For information on how to create a private endpoint, see Create a Database Management Private Endpoint for Oracle Cloud Databases.

      • Private Endpoint or Management Agent (for ExaDB-D): Select one of the available options to connect to the Oracle Cloud Database in ExaDB-D:
        • Private Endpoint: Select the private endpoint that will act as a representation of Database Management in the VCN in which the Oracle Cloud Database can be accessed. If the compartment in which the private endpoint resides is different from the compartment displayed, then click Change compartment and select another compartment.

          You must ensure that the appropriate Database Management private endpoint for RAC Oracle Cloud Databases in ExaDB-D is available.

          If an existing Database Management private endpoint is not available, then select Create private endpoint... in the drop-down list to create one. For information on how to create a private endpoint, see Create a Database Management Private Endpoint for Oracle Cloud Databases.

        • Management Agent: Select this option and the Management Agent in the Management Agent ID drop-down list. If the compartment in which the Management Agent resides is different from the compartment displayed, then click Change compartment and select another compartment.
          Note

          • If using a Management Agent when enabling Database Management, you cannot edit Database Management and select a different Management Agent later.
          • If Database Management is enabled for a CDB using a Management Agent, then the same Management Agent is used when enabling Database Management for its PDBs.

          If a Management Agent is not installed, then you must first install one. For information, see Install Management Agents.

      • Management Agent (for ExaDB-C@C): Select the Management Agent in the Management Agent ID drop-down list to connect to the Oracle Cloud Database in ExaDB-C@C. If the compartment in which the Management Agent resides is different from the compartment displayed, then click Change compartment and select another compartment.
        Note

        The same Management Agent that was used to enable Database Management for a CDB is used when enabling Database Management for its PDBs.

        If a Management Agent is not installed, then you must first install one. For generic information, see Install Management Agents and for additional information on how to install a Management Agent on Exadata Cloud to enable Database Management, see Observability & Management Support For Exadata Cloud (Doc ID 3015115.1) in My Oracle Support.

    4. Select the appropriate management option.
      Note

      • The Basic management option is not available for Oracle Cloud Databases in ExaDB-C@C.
      • The Management options are not displayed if you're enabling Database Management for a PDB.

      For information on management options, see About Management Options.

    5. Click Enable Database Management.
A confirmation message with a link to the Oracle Cloud Database's Work requests section on the Database Details page is displayed. Click the link to monitor the progress of the work request.

You can verify if Database Management is successfully enabled on the following pages:

  • Managed databases page in Database Management: On the left pane, select the compartment in which the Oracle Cloud Database resides and select the appropriate option in the Deployment type drop-down list. After Database Management is enabled, the Oracle Cloud Database is listed as a Managed Database. You can click the Actions icon (Actions) for the Oracle Cloud Database and perform the following tasks:
    • View details: Click to go to the Database Details page in the Oracle Database cloud solution.
    • Edit Database Management: Click to edit the connection information or the other details provided to enable Database Management for the Oracle Cloud Database.
    • Disable Database Management: Click to disable Database Management.
    • Set Session Credential: Click to set a session credential for that particular session and perform Diagnostics & Management tasks.
  • Database Details page of the Oracle Cloud Database: Verify if the Enable option next to Database Management is replaced with Enabled. A Disable option is also displayed, which you can click to disable Database Management.

If you encounter issues when enabling Diagnostics & Management, see Errors Encountered When Enabling Database Management for Oracle Cloud Databases for likely causes and solutions.

About Management Options

Database Management Diagnostics & Management features for Oracle Cloud Databases in the Base Database Service and ExaDB-D are available as part of two management options. You can select either option when enabling Database Management.

Note

  • The Basic management option is not available for Oracle Cloud Databases in ExaDB-C@C.
  • If you're enabling Diagnostics & Management for a PDB (in the Base Database Service and ExaDB-D), then you do not have the option of selecting a management option as PDB support is only available as part of the Full management option.

The two management options are:

  • Full management: This option includes all Diagnostics & Management features at an additional service cost. The Full management option is available for the Oracle Database Enterprise Editions and the Oracle Database Standard Edition, however, for the Oracle Database Standard Edition, the Full management option does not include Performance Hub features and other features such as Alert Logs and AWR Explorer. For information on Diagnostics & Management feature availability, see Diagnostics & Management Feature Support Matrix for Oracle Databases.
  • Basic management: This option is available for Oracle Cloud Databases in the Base Database Service and ExaDB-D at no additional cost.

Here's an overview of the features available in each management option.

Full management (Available at an additional cost) Basic management (Free)
  • Database fleet monitoring
  • Single Managed Database monitoring
  • Performance Hub features, including advanced features such as Exadata monitoring
  • RAC database monitoring
  • SQL Tuning Advisor
  • Database administration features
  • Oracle Data Guard monitoring
  • Dashboard features
  • 15 database metrics such as CpuUtilization, StorageAllocated, and UserCalls
  • ASH Analytics, AWR Report, and SQL Monitoring in Performance Hub
  • Dashboard features with the exception of certain widgets in the Oracle-defined dashboards, which do not display metric data for Oracle Cloud Databases enabled with Basic management.

Note that the other Diagnostics & Management console features are not available with the Basic management option.

For information on the metrics available with the management options, see Oracle Cloud Database Metrics.