Prerequisites for Enabling Resources

Ops Insights pulls in resource data from multiple sources. For example, some data may come from your databases (resources) in OCI and some data may come from on-premises databases. The Ops Insights interface allows you to select various telemetry types at setup time. Depending on the telemetry, adding resources require specific prerequisites to be met before enabling them for Ops Insights.

There are three telemetries where target data can be pulled from:

Here is a summary all prerequisites by telemetry type and by resource type:
Note

If you have not completed the setup for groups, users and policies, see OCI Prerequisites: Set Up Groups, Users and Policies.
Telemetry Type Resource Prerequisites
Cloud Infrastructure Autonomous Databases - basic features (includes Capacity Planning and SQL Warehouse) Prerequisites for Autonomous Databases
Cloud Infrastructure Autonomous Databases - full features (includes basic features plus SQL Explorer, and ADDM Spotlight) Enable Autonomous Databases & Full Feature Support
Cloud Infrastructure Bare Metal, Virtual Machines and ExaDB-D Databases Prerequisites for Enabling Database Cloud Service Databases and Exadata Cloud Service
Cloud Infrastructure Exadata Database Service on Cloud@Customer Prerequisites and Permissions
Enterprise Manager External databases, hosts and Engineered Systems using Oracle Enterprise Manager Adding Enterprise Manager Targets
Agent Service External databases and hosts using the OCI Management Agent Agent Service: OCI Management Agent Based Resources
Cloud Infrastructure OCI Compute Instances Perform Prerequisites for Deploying Management Agents on Compute Instances
HeatWave MySQL Database System MySQL Databases No prerequisites

Warehouses
Source Description Prerequiste
Directly from databases AWR Hub stores detailed database performance data from the Oracle Database Automatic Workload Repository (AWR) Analyze Automatic Workload Repository (AWR) Performance Data
Enterprise Manager Exadata Warehouse (repository of data from on-premises and cloud-based Oracle Engineered Systems monitored by Enterprise Manager) Exadata Warehouse

Cloud Infrastructure

If your resources exist in OCI, you will choose to add these resources using the telemetry option "Cloud Infrastructure". The prerequisites vary by the type of OCI resource as listed above.

Enterprise Manager

If your resources are already managed by Oracle Enterprise Manager, you can choose to add these resources using the telemetry option "Enterprise Manager". For complete details on prerequisites for enabling Enterprise Manager managed resources, see Adding Enterprise Manager Targets.

Exadata Warehouse is a repository of data from on-premises and cloud-based Oracle Engineered Systems monitored by Enterprise Manager. For prerequisites of this setup, see Exadata Warehouse.

Agent Service: OCI Management Agent Based Resources

In order to enable Ops Insights on hosts or database systems outside of the Oracle Cloud, not managed by Enterprise Manager, you need to deploy a Management Agent. The agent will enable data collection for these resources.

Summary of prerequisites for enabling agent-based resources:

Task Type Details
Install and configure an OCI Management Agent Mandatory On-premises hosts and databases: Install and configure an OCI Management Agent

OCI Compute: Deploy Management Agents on Compute Instances

Create external databases and connectors in the external database handles Mandatory for external databases Create external database handles and connectors in the external database service

Install and configure an OCI Management Agent

Install an OCI Management Agent in order to monitor a database or a host. The Oracle Cloud Infrastructure Management Agent is required to establish a connection with an external database during the discovery process and to enable communication and data collection.

While the first step (creating the dynamic group for the agent) is no longer required, this video provides a good overview of the Management Agent installation.

For complete information on how to install Management Agents, see Install Management Agents.

If the resources you are enabling reside on OCI Compute instances, see Deploy Management Agents on Compute Instances.

Create external database handles and connectors in the external database service

If your resources are databases, create external database handles and connectors in the external database (outside of Ops Insights). In summary, these are the required steps:
  1. Discover the database: this creates a shell resource in OCI that Ops Insights will connect to.
  2. Create a database connector and attach the management agent you just installed to it.
  3. Repeat the prior steps for each PDB, if your databases are container databases.
For more information, see Creating External Database Handles.