Oracle Cloud Infrastructure Documentation

Enable Diagnostics & Management for External Databases

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

To enable Diagnostics & Management for External 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 External in the Deployment type filter.

    The External Databases in the compartment are listed on the Managed databases page. These External Databases could have been registered either in the Oracle Cloud Infrastructure External Database service or in Database Management.

    Note

    On the Managed databases page, in addition to enabling Database Management features for External Databases, you can also perform the following tasks:
    • Click Register external databases to register an External Database. The option to register External Databases in the Database Management interface uses the same panel as in the External Database service. For information, see Create a Handle for an External Database.
    • Click Connect in the Status column to connect to an already registered External Database. The option to add a connection to an External Database in the Database Management interface is slightly different from the panel in the External Database service. For information, see Add a Connection.
    • Click Discover system and select an option to discover External Database Systems and Exadata Infrastructure. For more information, see Access Database Management Administration.
  5. In the Diagnostics & Management column, click Enable.
    Note

    If you're enabling Diagnostics & Management for a PDB, then you must first enable it for the associated CDB.
  6. On the Select database page of the Enable Diagnostics & Management panel:
    1. Review the automatically filled details such as the deployment type, database type and name.
    2. Select an External Database connector from the drop-down list.
      Note

      • If a connection is not added to the External Database or if you want to use a different connector, click + New connector to add a new connector and select it. For information, see Add a Connection.
      • If you're enabling Diagnostics & Management for a database in an Oracle Data Guard configuration that contains a physical standby database in mounted state, you must ensure that the connector is created by a monitoring user with the SYSDG privilege. If the SYSDG privilege is not granted to the monitoring user, metric collection may stop for the new standby databases following a role switchover or failover.
    3. Select a license option.
      Note

      • The Bring Your Own License (BYOL) subscription does not apply to the Oracle Database Standard Edition. For information on the BYOL subscription, see About Bring Your Own License Subscriptions.
      • If you're enabling Diagnostics & Management for a PDB, then you do not have to select a license option as it's inherited from the associated CDB.
    4. Click Next.
  7. On the Review page of the Enable Diagnostics & Management panel, review the selected database and Diagnostics & Management feature details and click Submit.
    A View work request button is displayed in the Feature to enable section and you can click it to view the status of the task and associated log messages and error messages, if any.

On the Managed databases page, Enabled is displayed in the Diagnostics & Management column after it's successfully enabled. On the left pane, click Diagnostics & Management to go to the Oracle Database fleet summary page and begin using its features.

To disable Diagnostics & Management for an External Database, on the Managed databases page, click the Actions icon (Actions) for the External Database and click View features. In the Features supported on <database name> panel, click Disable in the Diagnostics & Management section.

Add a Connection

You can add a connection to enable Database Management Diagnostics & Management for External Databases.

If a connection to an External Database is not created or if you want to use a different connector to enable Diagnostics & Management, you can use one of the following options on the Managed databases page:

  • Click Connect in the Status column and add a connection.
  • Click Enable in the Diagnostics & Management column and add a connection on the Select database page of the Enable Diagnostics & Management panel.

Note that you must have the required Management Agent permissions to add a connection. For information, see Permissions Required to Enable Diagnostics & Management for External Databases.

To add a connection on the Select database page of the Enable Diagnostics & Management panel:
  1. On the Managed databases page for External Databases, click Enable in the Diagnostics & Management column. For information, see Enable Diagnostics & Management for External Databases.
  2. On the Select database page in the Enable Diagnostics & Management panel, click + New connector.
  3. In the Add connection panel:
    1. Provide connector information:
      • Connector display name: Optionally, edit the default name assigned to the connector to help you easily identify the resource.
      • Agent: Select the Management Agent to establish a connection. By default, the compartment selected on the Managed databases page is displayed, however, you can click Change compartment and select another compartment, if required.
    2. Specify connection string information:
      1. DNS hostname or SCAN name: Enter the fully-qualified domain name (FQDN) or IP address for a single instance External Database or the FQDN of the Single Client Access Name (SCAN) listener or the SCAN virtual IP address for a RAC External Database.
      2. Port: Enter the port number.
      3. Service: Enter the service name of the External Database.
      4. Protocol: Select either the TCP or TCPS protocol to connect to the External Database.
      5. TLS secret: Select the Oracle Cloud Infrastructure Vault service 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 TLS secret panel is displayed and you can create a new secret. For detailed information on how to create a TLS secret in the Vault service, see Create a Connection to an External Database.
    3. Specify the credentials required to connect to the External Database:
      1. User name: Enter the database user name.
      2. Database user password: Enter the database user password.
      3. Role: Select the role from the available options.
      4. Credential name prefix: Specify the first part of the full credential name. This value is prefixed to a system-generated credential name to create the full credential name.
      5. Credential name: Review the credential name of the connection.
    4. Click Add connection.
On adding a new connection, you can select it on the Select database page of the Enable Diagnostics & Management panel.