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:
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) | No prerequisites |
| Cloud Infrastructure | Autonomous Databases - full features (includes basic features plus SQL Explorer, and ADDM Spotlight) | Autonomous Database Full Feature Support |
| Cloud Infrastructure | Bare Metal, Virtual Machines and ExaDB-D Databases | Prerequisites for Enabling Database Cloud Service Databases and Exadata Cloud Service |
| 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 |
| 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 | EM Warehouse (continuous ingestion of EM data via Cloud Bridge) | Enterprise Manager Warehouse |
| 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.
You can also setup the EM Warehouse to continuously ingest Enterprise Manager repository data (from one or more repositories) and store it in an ADW Warehouse or OCI Object Store. See: Enterprise Manager Warehouse.
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
- Discover the database: this creates a shell resource in OCI that Ops Insights will connect to.
- Create a database connector and attach the management agent you just installed to it.
- Repeat the prior steps for each PDB, if your databases are container databases.