Manage Database Management for Base Database Service Resources

This article describes the procedure to enable, edit, and disable Database Management for Base Database Service resources.

The following topics are covered in this article:

Prerequisites

You must perform the following tasks before enabling Database Management for your databases.

Required IAM Policy

To use Oracle Cloud Infrastructure, you must be granted security access in a policy by an administrator. This access is required whether you're using the Console or the REST API with an SDK, CLI, or other tool. If you get a message that you don’t have permission or are unauthorized, verify with your administrator what type of access you have and which compartment to work in.

For administrators: The policy in Let database admins manage Oracle Cloud database systems lets the specified group do everything with databases and related Database resources.

If you're new to policies, see Getting Started with Policies and Common Policies. If you want to dig deeper into writing policies for databases, see Details for the Database Service.

Use the API

For information about using the API and signing requests, see REST APIs and Security Credentials. For information about SDKs, see Software Development Kits and Command Line Interface.

Use the following APIs for managing Database Management:

  • enableDatabaseManagement
  • disableDatabaseManagement
  • updateDatabaseManagement

For the complete list of APIs for the Database service, see Database Service API.

Related Topics

Enable Database Management for a Database

Note:

You can also enable Database Management for a database from the Database Management Administration page. For more information, see Enable Database Management for Oracle Cloud Databases.

Perform the following steps to enable Database Management for a database.

  1. Open the navigation menu. Click Oracle Database, then click Oracle Base Database.
  2. Choose your Compartment. A list of DB systems is displayed.
  3. In the list of DB systems, click the DB system that contains the database for which you want to enable Database Management. Details of the DB system you selected are displayed.
  4. In the list of databases, click the database for which you want to enable Database Management. Details of the database you selected are displayed.
  5. In the Database information section, under the Associated Services, check the status of Database Management.
  6. If the Database Management is displayed as Not Enabled, perform the following steps to enable Database Management.
  7. Click on Enable.
  8. The Enable Database Management window opens up.
  9. In the Database information section, provide the following details.
    1. Database type: Read-only. Type of the database.
    2. Database system: Read-only. Compartment in which the database is located.
    3. Database home: Read-only. Database home of the database.
    4. Database name: Read-only. Name of the database.
    5. Service name: The unique service name of the database. A default unique name is displayed which can be changed if required.
    6. Protocol: Select either the TCP or TCPS protocol to connect to the database. By default, the TCP protocol is selected.

      Note:

      If Oracle Data Guard is enabled after Database Management was enabled for a DB system 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 DB system after enabling Oracle Data Guard.

      Note:

      Database Management currently does not support Oracle Data Guard configuration and Database Management features are not available for standby databases.
    7. Port: Specify 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. You can select the port number from a range of 1 to 65535.
    8. Database wallet secret: This field is only displayed if TCPS is selected in the Protocol field.

      Select the secret that contains the database wallet from the drop-down list. 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 creating a secret in the Vault service, see Oracle Cloud Database-related Prerequisite Tasks.

      If the Database Management (dpd) service policy that grants Database Management the permission to read the secret that contains the database wallet is not created, then the 'System policies are required..' message is displayed. You can click Add policy to view and automatically create the service policy. For information on Vault service permissions required to use existing secrets or create new secrets, see Permissions Required to Enable Database Management for Oracle Cloud Databases.

  10. In the Specify credentials for the connection section, provide the following details.
    1. Database user name: Enter the database user name.
    2. Database 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 saving the database user password as a secret in the Vault service, see Oracle Cloud Database-related Prerequisite Tasks.

      If the Database Management (dpd) service policy that grants Database Management the permission to read the secret that contains the database user password is not created, then the 'System policies are required..' message is displayed. You can click Add policy to view and automatically create the service policy. For information on Vault service permissions required to use existing secrets or create new secrets, see Permissions Required to Enable Database Management for Oracle Cloud Databases.

  11. In the Private endpoint information section, select the private endpoint that will act as a representation of Database Management in the VCN in which the database can be accessed. You can choose the private endpoint from a different compartment as well. You must ensure that the appropriate Database Management private endpoint is available. Here are the two types of Database Management private endpoints:
    1. Private endpoint for single instance databases in the DB systems.
    2. Private endpoint for RAC databases in the DB system.
    3. 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.
  12. In the Management options section, choose between the following options.
    1. Full management: This includes fleet management, advanced Performance Hub and other SKU features along with basic management capabilities.
    2. Basic management: This includes basic monitoring metrics and the ASH Analytics and SQL Monitoring features in Performance Hub for databases.

    For more information on Database Management options, see About Management Options section in Enable Database Management for Oracle Cloud Databases.

  13. Click Enable Database Management.
  14. A confirmation message with a link to the Work requests section on the Database information page is displayed. Click the link to monitor the progress of the work request.
  15. In the Database Information section, under the Associated Services, verify if the status of Database Management is enabled.

If you encounter issues when enabling Database Management, to know about likely causes and solutions, see Issues Encountered When Enabling Database Management for Oracle Cloud Databases.

Edit Database Management for a Database

Perform the following steps to edit Database Management settings for a database.

  1. Open the navigation menu. Click Oracle Database, then click Oracle Base Database.
  2. Choose your Compartment. A list of DB systems is displayed.
  3. In the list of DB systems, click the DB system that contains the database for which you want to edit Database Management. Details of the DB system you selected are displayed.
  4. In the list of databases, click the database for which you want to edit Database Management. Details of the database you selected are displayed.
  5. In the Database information section, under the Associated Services, check the status of Database Management.
  6. If the Database Management is displayed as enabled, perform the following steps to edit Database Management.
  7. Click on Edit.
  8. The Edit Database Management window opens up.
  9. In the Database information section, provide the following details.
    1. Database type: Read-only. Type of the database.
    2. Database system: Read-only. Compartment in which the database is located.
    3. Database home: Read-only. Database home of the database.
    4. Database name: Read-only. Name of the database.
    5. Service name: The unique service name of the database. A default unique name is displayed which can be changed if required.
    6. Protocol: Select either the TCP or TCPS protocol to connect to the database. By default, the TCP protocol is selected.

      Note:

      If Oracle Data Guard is enabled after Database Management was enabled for a DB system 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 DB system after enabling Oracle Data Guard.

      Note:

      Database Management currently does not support Oracle Data Guard configuration and Database Management features are not available for standby databases.
    7. Port: Specify 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. You can select the port number from a range of 1 to 65535.
    8. Database wallet secret: This field is only displayed if TCPS is selected in the Protocol field.

      Select the secret that contains the database wallet from the drop-down list. 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 creating a secret in the Vault service, see Oracle Cloud Database-related Prerequisite Tasks.

      If the Database Management (dpd) service policy that grants Database Management the permission to read the secret that contains the database wallet is not created, then the 'System policies are required..' message is displayed. You can click Add policy to view and automatically create the service policy. For information on Vault service permissions required to use existing secrets or create new secrets, see Permissions Required to Enable Database Management for Oracle Cloud Databases.

  10. In the Specify credentials for the connection section, provide the following details.
    1. Database user name: Enter the database user name.
    2. Database 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 saving the database user password as a secret in the Vault service, see Oracle Cloud Database-related Prerequisite Tasks.

      If the Database Management (dpd) service policy that grants Database Management the permission to read the secret that contains the database user password is not created, then the 'System policies are required..' message is displayed. You can click Add policy to view and automatically create the service policy. For information on Vault service permissions required to use existing secrets or create new secrets, see Permissions Required to Enable Database Management for Oracle Cloud Databases.

  11. In the Private endpoint information section, select the private endpoint that will act as a representation of Database Management in the VCN in which the database can be accessed. You can choose the private endpoint from a different compartment as well. You must ensure that the appropriate Database Management private endpoint is available. Here are the two types of Database Management private endpoints:
    1. Private endpoint for single instance databases in the DB systems.
    2. Private endpoint for RAC databases in the DB system.
    3. 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.
  12. In the Management options section, choose between the following options.
    1. Full management: This includes fleet management, advanced Performance Hub and other SKU features along with basic management capabilities.
    2. Basic management: This includes basic monitoring metrics and the ASH Analytics and SQL Monitoring features in Performance Hub for databases.

    For more information on Database Management options, see About Management Options section in Enable Database Management for Oracle Cloud Databases.

  13. Click Save Changes.
  14. A confirmation message with a link to the Work requests section on the Database information page is displayed. Click the link to monitor the progress of the work request.
  15. In the Database Information section, under the Associated Services, verify if the status of Database Management is enabled.

If you encounter issues when enabling Database Management, to know about likely causes and solutions, see Issues Encountered When Enabling Database Management for Oracle Cloud Databases.

Disable Database Management for a Database

Perform the following steps to disable Database Management for a database.

  1. Open the navigation menu. Click Oracle Database, then click Oracle Base Database.
  2. Choose your Compartment. A list of DB systems is displayed.
  3. In the list of DB systems, click the DB system that contains the database for which you want to disable Database Management. Details of the DB system you selected are displayed.
  4. In the list of databases, click the database for which you want to disable Database Management. Details of the database you selected are displayed.
  5. In the Database information section, under the Associated Services, check the status of Database Management.
  6. If the Database Management is displayed as enabled, then click on Disable to disable Database Management.
  7. A confirmation message with a link to the Work requests section on the Database information page is displayed. Click the link to monitor the progress of the work request.
  8. In the Database Information section, under the Associated Services, verify if the status of Database Management is disabled.

Enable Database Management for a Pluggable Database

Note:

You can also enable Database Management for a database from the Database Management Administration page. For more information, see Enable Database Management for Oracle Cloud Databases.

Prerequisite

To enable the Database Management for a pluggable database, the following prerequisite is required.

  1. The Database Management must be enabled for the associated database with Full Management option. To enable Database Management for databases, see Enable Database Management for a Database.

    For more information on Database Management options, see About Management Options section in Enable Database Management for Oracle Cloud Databases.

Procedure

Perform the following steps to enable Database Management for pluggable databases.

  1. Open the navigation menu. Click Oracle Database, then click Oracle Base Database.
  2. Choose your Compartment. A list of DB systems is displayed.
  3. In the list of DB systems, click the DB system that contains the pluggable database for which you want to enable Database Management. Details of the DB system you selected are displayed.
  4. In the list of databases, click the database that contains the pluggable database for which you want to enable Database Management. Details of the Database you selected are displayed.
  5. Click Pluggable Databases in the Resources section of the page.
  6. In the list of pluggable databases, click the pluggable database for which you want to enable Database Management. Details of the pluggable database you selected are displayed.
  7. In the Database information section, under the Associated Services, check the status of Database Management.
  8. If the Database Management is displayed as Not Enabled, perform the following steps to enable Database Management.
  9. Click on Enable.
  10. The Enable Database Management window opens up.
  11. In the Database information section, provide the following details.
    1. Database type: Read-only. Type of the database.
    2. Database system: Read-only. Compartment in which the database is located.
    3. Database home: Read-only. Database home of the database.
    4. Database name: Read-only. Name of the database.
    5. Service name: The unique service name of the database. A default unique name is displayed which can be changed if required.
    6. Protocol: Select either the TCP or TCPS protocol to connect to the database. By default, the TCP protocol is selected.

      Note:

      If Oracle Data Guard is enabled after Database Management was enabled for a DB system 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 DB system after enabling Oracle Data Guard.

      Note:

      Database Management currently does not support Oracle Data Guard configuration and Database Management features are not available for standby databases.
    7. Port: Specify 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. You can select the port number from a range of 1 to 65535.
    8. Database wallet secret: This field is only displayed if TCPS is selected in the Protocol field.

      Select the secret that contains the database wallet from the drop-down list. 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 creating a secret in the Vault service, see Oracle Cloud Database-related Prerequisite Tasks.

      If the Database Management (dpd) service policy that grants Database Management the permission to read the secret that contains the database wallet is not created, then the 'System policies are required..' message is displayed. You can click Add policy to view and automatically create the service policy. For information on Vault service permissions required to use existing secrets or create new secrets, see Permissions Required to Enable Database Management for Oracle Cloud Databases.

  12. In the Specify credentials for the connection section, provide the following details.
    1. Database user name: Enter the database user name.
    2. Database 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 saving the database user password as a secret in the Vault service, see Oracle Cloud Database-related Prerequisite Tasks.

      If the Database Management (dpd) service policy that grants Database Management the permission to read the secret that contains the database user password is not created, then the 'System policies are required..' message is displayed. You can click Add policy to view and automatically create the service policy. For information on Vault service permissions required to use existing secrets or create new secrets, see Permissions Required to Enable Database Management for Oracle Cloud Databases.

  13. In the Private endpoint information section, select the private endpoint that will act as a representation of Database Management in the VCN in which the database can be accessed. You can choose the private endpoint from a different compartment as well. You must ensure that the appropriate Database Management private endpoint is available. Here are the two types of Database Management private endpoints:
    1. Private endpoint for single instance databases in the DB systems.
    2. Private endpoint for RAC databases in the DB system.
    3. 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.
  14. Click Enable Database Management.
  15. A confirmation message with a link to the Work requests section on the Database information page is displayed. Click the link to monitor the progress of the work request.
  16. In the Database Information section, under the Associated Services, verify if the status of Database Management is enabled.

If you encounter issues when enabling Database Management, to know about likely causes and solutions, see Issues Encountered When Enabling Database Management for Oracle Cloud Databases.

Edit Database Management for a Pluggable Database

Perform the following steps to edit Database Management for pluggable databases.

  1. Open the navigation menu. Click Oracle Database, then click Oracle Base Database.
  2. Choose your Compartment. A list of DB systems is displayed.
  3. In the list of DB systems, click the DB system that contains the pluggable database for which you want to edit Database Management. Details of the DB system you selected are displayed.
  4. In the list of databases, click the database that contains the pluggable database for which you want to edit Database Management. Details of the Database you selected are displayed.
  5. Click Pluggable Databases in the Resources section of the page.
  6. In the list of pluggable databases, click the pluggable database for which you want to edit Database Management. Details of the pluggable database you selected are displayed.
  7. In the Database information section, under the Associated Services, check the status of Database Management.
  8. If the Database Management is displayed as enabled, perform the following steps to edit Database Management.
  9. Click on Edit.
  10. The Edit Database Management window opens up.
  11. In the Database information section, provide the following details.
    1. Database type: Read-only. Type of the database.
    2. Database system: Read-only. Compartment in which the database is located.
    3. Database home: Read-only. Database home of the database.
    4. Database name: Read-only. Name of the database.
    5. Service name: The unique service name of the database. A default unique name is displayed which can be changed if required.
    6. Protocol: Select either the TCP or TCPS protocol to connect to the database. By default, the TCP protocol is selected.

      Note:

      If Oracle Data Guard is enabled after Database Management was enabled for a DB system 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 DB system after enabling Oracle Data Guard.

      Note:

      Database Management currently does not support Oracle Data Guard configuration and Database Management features are not available for standby databases.
    7. Port: Specify 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. You can select the port number from a range of 1 to 65535.
    8. Database wallet secret: This field is only displayed if TCPS is selected in the Protocol field.

      Select the secret that contains the database wallet from the drop-down list. 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 creating a secret in the Vault service, see Oracle Cloud Database-related Prerequisite Tasks.

      If the Database Management (dpd) service policy that grants Database Management the permission to read the secret that contains the database wallet is not created, then the 'System policies are required..' message is displayed. You can click Add policy to view and automatically create the service policy. For information on Vault service permissions required to use existing secrets or create new secrets, see Permissions Required to Enable Database Management for Oracle Cloud Databases.

  12. In the Specify credentials for the connection section, provide the following details.
    1. Database user name: Enter the database user name.
    2. Database 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 saving the database user password as a secret in the Vault service, see Oracle Cloud Database-related Prerequisite Tasks.

      If the Database Management (dpd) service policy that grants Database Management the permission to read the secret that contains the database user password is not created, then the 'System policies are required..' message is displayed. You can click Add policy to view and automatically create the service policy. For information on Vault service permissions required to use existing secrets or create new secrets, see Permissions Required to Enable Database Management for Oracle Cloud Databases.

  13. In the Private endpoint information section, select the private endpoint that will act as a representation of Database Management in the VCN in which the database can be accessed. You can choose the private endpoint from a different compartment as well. You must ensure that the appropriate Database Management private endpoint is available. Here are the two types of Database Management private endpoints:
    1. Private endpoint for single instance databases in the DB systems.
    2. Private endpoint for RAC databases in the DB system.
    3. 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.
  14. Click Save Changes.
  15. A confirmation message with a link to the Work requests section on the Database information page is displayed. Click the link to monitor the progress of the work request.
  16. In the Database Information section, under the Associated Services, verify if the status of Database Management is enabled.

If you encounter issues when enabling Database Management, to know about likely causes and solutions, see Issues Encountered When Enabling Database Management for Oracle Cloud Databases.

Disable Database Management for a Pluggable Database

Perform the following steps to disable Database Management for pluggable databases.

  1. Open the navigation menu. Click Oracle Database, then click Oracle Base Database.
  2. Choose your Compartment. A list of DB systems is displayed.
  3. In the list of DB systems, click the DB system that contains the pluggable database for which you want to disable Database Management. Details of the DB system you selected are displayed.
  4. In the list of databases, click the database that contains the pluggable database for which you want to disable Database Management. Details of the Database you selected are displayed.
  5. Click Pluggable Databases in the Resources section of the page.
  6. In the list of pluggable databases, click the pluggable database for which you want to disable Database Management. Details of the pluggable database you selected are displayed.
  7. In the Database information section, under the Associated Services, check the status of Database Management.
  8. If the Database Management is displayed as Enabled, perform the following steps to disable Database Management.
  9. Click on Disable.
  10. A confirmation message with a link to the Work requests section on the Database information page is displayed. Click the link to monitor the progress of the work request.
  11. In the Database Information section, under the Associated Services, verify if the status of Database Management is Disabled.