Adding Enterprise Manager Targets
You can use Ops Insights to perform resource analysis against databases and hosts managed by Enterprise Manager.
Enterprise Manager lets you transfer data from Enterprise Manager targets and Oracle Management Repository (OMR) to an OCI Object Storage bucket, where it is easily accessed by Ops Insights.
- Oracle Enterprise Manager 13c Release 5 Update 13 (13.5.0.13) or above
- Oracle Enterprise Manager Agents must be on 13c Release 13 (13.5.0.13) or above.
- Database Plug-in version 13.5.0.13 or above
For Enterprise Manager 13c Release 5 Update 19 (13.5.0.19) installations, Enterprise Manager Agents and Database Plug-ins must be version 13c Release 5 Update 17 (13.5.0.17) or above.
- Set up target-level data transfer from Enterprise Manager to OCI Object Storage.
- Set up data transfer from OCI Object Storage to Ops Insights.
- An Enterprise Manager Cloud Bridge to move target-level data from Enterprise Manager to OCI Object Storage bucket.
- An Ops Insights EM Bridge to move data from the OCI Object Storage bucket to Ops Insights for analysis.
Oracle recommends updating Oracle (Enterprise Manager) Management Agents to at least Oracle Enterprise Manager 13c Release 5 Update 13 (13.5.0.13) as the newer agent versions resolve operational issues affecting databases using the Cloud Bridge.
EM Bridge Prerequisites
opsi-enterprise-manager-bridge
resource, which is part of opsi-family
aggregate resource-type. The following examples illustrate the policy creation process.
- Example rule for bridge dynamic group where the resource can be in any compartment in tenancy:
ALL {resource.type='opsienterprisemanagerbridge'}
- Example rule for bridge dynamic group with specific resource compartment OCID:
ALL {resource.type='opsienterprisemanagerbridge', resource.compartment.id = <opsienterprisemanagerbridge_resource_compartment_OCID>}
- Example policy to allow the dynamic group READ access to the Object Storage bucket:
allow dynamic-group <group_name> to read object-family in compartment <bucket_compartment_name> where ANY{target.bucket.name=<embridge-bucket>}
Data Flow
Once Enterprise Manager to Ops Insights connectivity is set up, your target data is automatically uploaded at frequent intervals to the Object Storage bucket so that Ops Insights is always working with the most recent target data.
The following graphic illustrates how target data flows from Enterprise Manager to an OCI service once the configuration process has been completed. Highlighted in red is the portion of the setup you will perform for Ops Insights.
The Object Storage bucket must already exist before creating an EM Bridge.
For instructions on setting up Enterprise Manager target-level data transfer to the Object Storage bucket and setting up the Cloud Bridge for Ops Insights, see Integrating Enterprise Manager with OCI Services in the Enterprise Manager Cloud Control Administrator's Guide.
- Ops Insights: Capacity Planning and SQL Warehouse: For Exadata Insights, Host Capacity Planning, Database Capacity Planning, SQL Warehouse, and SQL Explorer.
- Ops Insights: Exadata Warehouse
For troubleshooting Ops Insights service setup from Enterprise Manager 13c see MOS note: Troubleshooting OCI Ops Insights Service Setup from Enterprise Manager 13c (Doc ID 2913953.1) MOS 2913953.1.