Enable Database Management for Oracle Cloud Databases

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

Note

Database Management currently does not support PDBs in Bare Metal and Virtual Machine DB systems and Exadata Cloud service.

You can enable Database Management for Oracle Cloud Databases on the Database Details page within the Co-managed Oracle Database Cloud solution, or on the Database Management Administration page.

To enable Database Management for Oracle Cloud Databases on the Database Management Administration 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 left pane on the Administration page, select the compartment in which the Oracle Cloud Database resides.
  5. On the Managed Databases page, click Enable Database Management.
  6. In the Enable Database Management dialog box:
    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, either of the following options is displayed:
        • Database System in <Compartment> (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 in <Compartment> (for Exadata Cloud service): 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: Select the Oracle Cloud Database.
      4. Service Name: The unique service name in the Database_Name.Host_Domain_Name format is automatically displayed, but you can edit it, if required.
    2. Specify the database credentials for the connection to the selected Oracle Cloud Database.
      1. Database User Name: Enter the database user name.
      2. Use existing secret or Create new secret: Select either of these radio buttons to use an existing Oracle Cloud Infrastructure Vault service secret that contains the database user password or create a new secret and save the password. If you select the Create new secret option, the Create Password Secret dialog box is displayed. Enter the information required to create a new secret and save the database user password, which must meet the following FIPS requirements:
        • Password length must be between 14 to 127 characters.
        • Password must have at least two lowercase, two uppercase, two digits, and two special characters.

        For more information on database monitoring user credentials and saving the database user password as a secret in the Vault service, see Oracle Cloud Database-related Prerequisite Tasks.

      3. Database User Password Secret in <Compartment>: 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, click Change Compartment and select another compartment.

      Note that you must have the required Vault service permissions to use existing secrets or create new secrets. For more information, see Permissions Required to Enable Database Management for Oracle Cloud Databases.

    3. Private Endpoint in <Compartment>: 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, click Change Compartment and select another compartment.

      Note that 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 service.

      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. Management Options: Select the appropriate management option. 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 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 Administration page: 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: Select Metrics on the left pane under Resources and check if the database metrics are displayed.

If you encounter issues when enabling Database Management, see Issues 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 on Bare Metal and Virtual Machine DB systems and Exadata Cloud service, are available as part of two Management Options. You can select either option when enabling Database Management.

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, it does not include Performance Hub features.
  • Basic Management: This option is available for Oracle Cloud Databases at no additional cost.

The following table provides 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
  • 14 database metrics such as CpuUtilization, StorageAllocated, and UserCalls
  • ASH Analytics, AWR Report, and SQL Monitoring in Performance Hub

Note that Database Management console features are not available with the Basic Management option.

For information on the metrics available with the management options, see Exadata, Bare Metal, and Virtual Machine Database Metrics.