Oracle Cloud Infrastructure Documentation

Enable Database Management for Oracle Cloud Databases

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

You can enable Database Management for Oracle Cloud Databases on the Database Details page within the Base Database Service and Exadata Cloud Infrastructure or on the Database Management Managed databases page.

To enable Database Management for Oracle Cloud Databases on the Database Management Managed databases page:

  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 Database 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 Managed databases page, click Enable Database Management.
  5. In the Enable Database Management panel:
    1. Specify the following details to select a database:
      1. Database type: Select the co-managed Oracle Database cloud solution on which the Oracle Database is running.
      2. Depending on the option selected in the previous step, one of the following options is displayed:
        • Database system (for Bare Metal and Virtual Machine DB systems): Select the Bare Metal or Virtual Machine DB system. 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 Exadata Cloud Infrastructure): Select the cloud VM cluster that provides a link between the Exadata Cloud Infrastructure 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

        • 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 Bare Metal or Virtual Machine DB system after Database Management was enabled for it using the TCPS protocol, then TCPS will have to be reconfigured. Enabling Oracle Data Guard is causing TCPS configuration to be overwritten, and it's recommended that TCPS is configured on a Bare Metal or Virtual Machine DB system after enabling Oracle Data Guard.

        Also, Database Management currently does not support Oracle Data Guard configuration and Database Management features are not available for standby databases.

      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.
      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. Select the private endpoint in the Private endpoint drop-down list, which 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 Bare Metal and Virtual Machine DB systems.
      • Private endpoint for RAC Oracle Cloud Databases in the Virtual Machine DB system and Exadata Cloud Infrastructure.

      If a Database Management private endpoint is not available, then you must create one. For information on how to create a private endpoint, see Create a Database Management Private Endpoint.

    4. Select the appropriate management option.
      Note

      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:

  • Database Management Managed databases page: On the left pane, select the compartment in which your 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.
  • 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 Database Management, see Errors Encountered When Enabling Database Management for Oracle Cloud Databases for likely causes and solutions.

About Management Options

Database Management features for Oracle Cloud Databases, which are Oracle Databases in the Base Database Service and Exadata Cloud Infrastructure, are available as part of two management options. You can select either option when enabling Database Management.

Note

If you're enabling Database Management for a PDB, 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 Database 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 Database Management feature availability, see Database Management Feature Support Matrix for Oracle Databases.
  • Basic management: This option is available for Oracle Cloud Databases 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
  • Dashboard features
  • 14 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 Database 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.