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) | Prerequisites for Autonomous Databases |
| Autonomous Databases - full features (includes basic features plus SQL Explorer, and ADDM Spotlight) | Enable Autonomous Databases & Full Feature Support | |
| Bare Metal, Virtual Machines and ExaDB-D Databases | Prerequisites for Enabling Database Cloud Service Databases and Exadata Cloud Service | |
| OCI Compute Instances | Perform Prerequisites for Deploying Management Agents on Compute Instances | |
| HeatWave MySQL Database Systems | No Prerequisites | |
| 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 |
| External MySQL Database Systems | Create an external MySQL Database System and Connectors |
| Source | Description | Prerequisite |
|---|---|---|
| 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 |
| Create external MySQL Database Systems and connectors | Mandatory for external MySQL Database Systems | Create an external MySQL Database System and Connectors |
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.
Create an external MySQL Database System and Connectors
- Register the External MySQL DB system. This includes all the required-prerequisites required for enabling Database Management, see Perform External MySQL DB System-related Prerequisite Tasks.
- Create the Database Management connector and enable the Database Management service, see Database Management for HeatWave and External MySQL.
- Use the connector created within the Database Management service to enable the Ops Insights service.
- Ensure the policies required for external MySQL Database Systems are implemented. For more information on setting policies automatically using Policy Advisor see Create and Manage Policies With Policy Advisor. For a complete list of policies required for external MySQL Database Systems and how to apply them using the console see Table 2-*.