Enable Databases for the Service

Monitoring Credentials

Before adding a database, ensure that you have proper monitoring credentials set up. For instructions on how to set up External and Cloud Oracle Database monitoring credentials (Virtual Machine, Bare Metal, and Exadata), see Creating the Oracle Database Monitoring Credentials for Oracle Cloud Infrastructure Database Management, Ops Insights and Stack Monitoring (Article ID 2933173).

To create an Autonomous AI Database monitoring credential, see OCI : Creating the Autonomous AI Database Monitoring Credentials for Oracle Cloud Ops Insights (Article ID KB95891).

Enable Databases for Ops Insights

To enable one or more databases for Ops Insights, log in to OCI and do the following:

1. Open the navigation menu, click Observability & Management, and then click Ops Insights.
2. In the left pane, click Administration, and then click Database fleet.

   The Database fleet administration page displays.

   Note
   
   If deprecated policy statements are detected, Policy Advisor will display a banner requiring a policy update to the new CRISP format, to update click Update prerequisites polices. For information on deprecated policies, see Service Principal Policy Removal.
3. Click Add Databases.
4. Click on the desired Telemetry. Available telemetries are:
   • Cloud Infrastructure: Autonomous AI Databases running in OCI, at Exadata Cloud@Customer, Exadata Database Service on Dedicated Infrastructure, Virtual Machine, and Bare Metal. Multicloud databases such as Oracle Database@AWS and Oracle Database@Azure.
   • OCI Management Agent: External Oracle databases monitored by the OCI Management Agent service.
   • Enterprise Manager: Databases monitored and managed via Enterprise Manager. You'll need to select the EM Bridge.
5. Select the Services to enable for the selected databases. Ops Insights and Database Management are displayed and can be enabled together.
   Note
   
   

   • If a service is already enabled for the selected database, its enablement request is skipped.
   • For supported Cloud Infrastructure and OCI Management Agent resources, Database Management is displayed and can be enabled together with Ops Insights.
   • If Database Management is selected for an External Database, a Diagnostics & Management licensing option must be specified. For information, see Enable Diagnostics & Management for External Databases.
   • When Enterprise Manager telemetry is selected, only Ops Insights is displayed because Database Management is not supported.
6. Select the Compartment that contains the databases for which you want to enable the services.
   Note
   
   

   • For Enterprise Manager databases, select the EM bridge compartment and the EM bridge.
   • For OCI Management Agent telemetry:
     • Only connected External Databases can be selected for enablement. If the External Database is not listed, click Register external database to register it. For information, see Create a Handle for an External Database.
     • If an External Database is not connected, click the Actions icon () and click Connect. After the connection is active, select the External Database. For information, see Add a Connection.

     Ops Insights supports external PDBs and Non-CDBs, but not external CDBs.

   • For Exadata Cloud@Customer Autonomous AI Databases, full features are checked by default. The basic feature set is not available for these databases.
7. Select the database or databases to enable. Optionally, if there are many databases and you know which ones you want to enable, you can filter the returned results based on database type.

   The list includes databases for which at least one selected service is not yet enabled. Review the service-status columns before selecting the databases.

   Note
   
   Autonomous AI Databases and Enterprise Manager databases allow you to select multiple databases for enablement. Multiple selection is not available for databases monitored by Management Agents, Virtual Machine, or Bare Metal. Alternatively, for Exadata, you can bulk enable the entire Exadata system.
8. Click Add databases. The enable request for the selected databases and services is submitted for processing. Depending on the amount of data that needs to be uploaded, it may take a few minutes for the process to complete. Data may take up to 24 hours to appear in Ops Insights for newly enabled databases.

Available Actions

After you add a database to Ops Insights, click the Actions menu for the database to perform actions such as enabling or disabling the database, adding tags, or moving the database to a different compartment. Only Enterprise Manager databases can be moved.