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 and Ops Insights (Doc ID 2857604.1).

To create an Autonomous Database monitoring credential see Creating the Autonomous Database Monitoring Credentials for Oracle Cloud Ops Insights (Doc ID 2933173.1).

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 and click Observability and Management. Under Ops Insights, click Administration and then 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 on Update prerequisites polices button.

   Figure 2-4 Policy advisor warning

   
2. Click Add Databases. The Add Databases to Ops Insights dialog displays.
3. Click on the desired Telemetry. Available telemetries are:
   • Cloud Infrastructure: Autonomous databases running in OCI, Exadata Cloud Service databases, Virtual Machine, Bare Metal, and HeatWave MySQL Database Service.
   • Enterprise Manager: Databases monitored and managed via Enterprise Manager. You'll need to select the EM Bridge. In addition, you'll also need to select the destination compartment as shown in the next step.
   • Agent Service: Databases monitored by the OCI Management Agent Service. You'll need to select the destination compartment as shown in the next step. In addition, you'll also need to select an external connector.
4. Select the Compartment that contains the database that you want to enable for Ops Insights.
   Note
   
   This is not needed for Enterprise Manager databases (you select the EM bridge instead) and you choose the destination compartment.

   For Management Agent databases you must also select the connector after selecting the database 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.
5. Select a database to enable.
   Note
   
   Autonomous Databases, Enterprise Manager databases, and HeatWave MySQL Database Systems allow you to multi-select databases for enablement. The multi-select feature is not available for databases monitored by Management Agents, Virtual Machine, or Bare Metal. Alternatively, for Exadata, you can bulk enable the entire the entire Exadata system.
6. Click Add Databases. The enable request is submitted for processing. Depending on 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 database.

Available Actions

Once you've added a database to Ops Insights, in addition to enabling and disabling the database, you can also add tags and move these resources to different compartments (only Enterprise Manager databases can be moved). These actions can be accessed by clicking the vertical ellipses for any database in the Database Fleet table.