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 VMware Aria Operations |
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 VMware Aria Operations ‘Resources’ |
MGMT$TARGET_ASSOCIATIONS |
None |
This view contains data used to define relationships between Oracle ‘Resources’ in VMware Aria Operations |
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
Creating a Least Privileged User
GRANT CONNECT TO LPU;
ALTER USER LPU DEFAULT ROLE ALL;
GRANT OEM_MONITOR TO LPU;
GRANT EXEMPT ACCESS POLICY TO LPU;
GRANT SELECT ON SYSMAN.MGMT$AVAILABILITY_CURRENT TO LPU;
GRANT SELECT ON SYSMAN.MGMT$DB_ASSOC_DATA TO LPU;
GRANT SELECT ON SYSMAN.MGMT$DB_CPU_USAGE TO LPU;
GRANT SELECT ON SYSMAN.MGMT$DB_DATAFILES TO LPU;
GRANT SELECT ON SYSMAN.MGMT$DB_DBNINSTANCEINFO TO LPU;
GRANT SELECT ON SYSMAN.MGMT$DB_SGA TO LPU;
GRANT SELECT ON SYSMAN.MGMT$GROUP_MEMBERS TO LPU;
GRANT SELECT ON SYSMAN.MGMT$HW_NIC TO LPU;
GRANT SELECT ON SYSMAN.MGMT$INCIDENTS TO LPU;
GRANT SELECT ON SYSMAN.MGMT$METRIC_CURRENT TO LPU;
GRANT SELECT ON SYSMAN.MGMT$METRIC_DETAILS TO LPU;
GRANT SELECT ON SYSMAN.MGMT$TARGET TO LPU;
GRANT SELECT ON SYSMAN.MGMT$TARGET_ASSOCIATIONS TO LPU;
