Enable Databases for the Service

Once a database is enabled, you'll be able to use Ops Insights Capacity Planning and Oracle SQL Warehouse features to optimize performance and resource usage.

Note

The data may take up to 24 hours to appear.

If you want to view more granular data (7 days or less), you can select a smaller time range.

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, 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.
  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, 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. 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 and Enterprise Manager databases 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 Enable. 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.