To enable one or more databases for Ops Insights, log in to OCI and do the following:
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.
Click Add Databases. The Add Databases to Ops Insights dialog displays.
Click on the desired Telemetry. Available telemetries are:
Cloud Infrastructure: Autonomous databases running in OCI, and at Exadata
Cloud@Customer, Exadata Database Service on
Dedicated Infrastructure , Virtual Machine, and
Bare Metal.
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, this includes HeatWave MySQL Database Systems, and external MySQL Database Systems. 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.
For external MySQL Database Systems a connector is chosen by default, if you wish to override select the connector to use from the multi-select table.
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.
For Exadata Cloud @Customer Autonomous databases full features are checked by default. The basic feature set is not available for these databases.
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.
Select a database to enable.
Note
Autonomous Databases, Enterprise Manager databases, HeatWave MySQL Database Systems, and external MySQL Database System 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.
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.
Note
Autonomous Databases, databases monitored by
Management Agents, Virtual Machine, Bare Metal, and Exadata Cloud Service follow the
DBaaS resource compartment.