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.

System Prerequisites
  • 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
Note

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.
Data transfer from Enterprise Manager to Ops Insights is configured in two steps:
  1. Set up target-level data transfer from Enterprise Manager to OCI Object Storage.
  2. Set up data transfer from OCI Object Storage to Ops Insights.
Each step involves setting up a data transfer bridge. There are two bridges involved in Enterprise Manager-Ops Insights communication:
  • 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.
Note

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

Before setting up the EM Bridge, you need to create Identity and Access Management (IAM) policies in order to read from the configured Object Storage Bucket. Create a dynamic group and provide permissions for the dynamic group to access the data in the above Object Storage compartment. Additionally, add policies to use the 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.

Note

The Object Storage bucket must already exist before creating an EM Bridge.

Graphic illustrates the data flow from Enterprise Manager to Ops Insights

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.

When selecting the OCI Service while enabling Data Export select the appropriate service for your needs:
  • 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
Note

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.