The user account that the Management Pack uses to connect to the Oracle Enterprise Manager database must have read access to the SYSMAN database views listed in the table below.

OEM Management Repository (OMR) Views queried by the Management Pack for OEM

OMR View queried by the Management Pack Licensed Oracle MPs required to query View Why is the View queried?
MGMT$AVAILABILITY_CURRENT Diagnostics Pack for Oracle Database (if monitoring Databases or Oracle Hosts)
WebLogic Server Management Pack Enterprise Edition (if monitoring WebLogic) Provides availability status information for each Oracle target
MGMT$DB_ASSOC_DATA None Provides metadata for Oracle databases
MGMT$DB_CPU_USAGE None Contains CPU utilization data for Oracle databases
MGMT$DB_DATAFILES Database Lifecycle Management Pack for Oracle Database Provides details on Oracle database data files
MGMT$DB_DBNINSTANCEINFO Database Lifecycle Management Pack for Oracle Database Contains configuration information for Oracle databases
MGMT$DB_SGA Database Lifecycle Management Pack for Oracle Database Provides Oracle database SGA configuration settings for Oracle databases
MGMT$GROUP_MEMBERS None Used to determine membership in OEM groups
MGMT$HW_NIC None Provides IP addresses for EM monitored hosts
MGMT$INCIDENTS None Used to import EM incidents into vROps
MGMT$METRIC_CURRENT Diagnostics Pack for Oracle Database (if monitoring Databases or Oracle Hosts)
WebLogic Server Management Pack Enterprise Edition (if monitoring WebLogic) Contains the most recently collected metrics for Oracle targets
MGMT$METRIC_DETAILS Diagnostics Pack for Oracle Database (if monitoring Databases or Oracle Hosts)
WebLogic Server Management Pack Enterprise Edition (if monitoring WebLogic) Provides historical data for the metrics in MGMT$METRIC_CURRENT view
MGMT$TARGET None Used to determine distinct Oracle targets to use as vROps ‘Resources’
MGMT$TARGET_ASSOCIATIONS None This view contains data used to define relationships between Oracle ‘Resources’ in vROps

Access to a subset of these management repository views require one or more Oracle Management Packs to be licensed from Oracle in order to access the data within the views. A representative set of the most common Oracle Management Packs used in typical Enterprise Manager environments are:

  • Database Lifecycle Management Pack for Oracle Database
  • Diagnostics Pack for Oracle Database
  • WebLogic Server Management Pack Enterprise Edition