Oracle Enterprise Manager Cloud Control

StreamWeaver-supported versions

Oracle Enterprise Manager Cloud Control versions: 13.C

StreamWeaver data acquisition methods

Oracle Enterprise Manager Cloud Control JDBC

Prerequisites. TNS entry with a TCP port enabled

OEM CC TNS entry information	Examples
Host	oraclecc.example.com
Port	1521
SID (database name)	EMREP
Schema	SYSMAN
User Name	SYSMAN
Password	Password

Example TNS entry file (tnsnames.ora):

net_service_name=
(DESCRIPTION_LIST=
  (DESCRIPTION=
  (ADDRESS=(PROTOCOL=tcp)(HOST=oraclecc.example.com)(PORT=1521))
  (CONNECT_DATA=
    (SERVICE_NAME=EMREP)))

If you require read-only access to the SYSMAN tables, then you can follow these commands to enable the user with appropriate permissions to access OEM

CREATE USER "READONLY_USER"
   IDENTIFIED BY xxxxxxx
   DEFAULT TABLESPACE "MGMT_TABLESPACE"
   TEMPORARY TABLESPACE "TEMP"
   QUOTA 512 M ON "MGMT_TABLESPACE"
   ACCOUNT UNLOCK
/-- allow logon
GRANT "CONNECT" TO "READONLY_USER";-- ignore Fine Grained Access Control
GRANT EXEMPT ACCESS POLICY to READONLY_USER;-- EM 13c has editions enabled
-- Do the same to avoid
-- ORA-38818: illegal reference to editioned object SYSMAN.MGMT$...
ALTER USER READONLY_USER ENABLE EDITIONS;
--
GRANT SELECT ANY DICTIONARY TO READONLY_USER;
--
GRANT OEM_MONITOR TO READONLY_USER;
--
GRANT SELECT_CATALOG_ROLE to READONLY_USER;
-- Grant access to individual tables
GRANT SELECT ON SYSMAN.MGMT$ALERT_CURRENT to READONLY_USER;
GRANT SELECT ON SYSMAN.MGMT$EVENTS to READONLY_USER;
GRANT SELECT ON SYSMAN.MGMT$METRIC_DETAILS to READONLY_USER;
GRANT SELECT ON SYSMAN.MGMT$TARGET to READONLY_USER;
GRANT SELECT ON SYSMAN.MGMT$TARGET_ASSOCIATIONS to READONLY_USER;
GRANT SELECT ON SYSMAN.MGMT$TARGET_PROPERTIES to READONLY_USER;
GRANT SELECT ON SYSMAN.MGMT$TARGET_TYPE to READONLY_USER;

Click here to return to Step-by-Step Configuration Guide

Related articles appear here based on the labels you select. Click to edit the macro and add or change labels.

No results.

Oracle Enterprise Manager Cloud Control

Related articles

On this page