This documentation supports the on-premises releases of StreamWeaver upto version 3.16. For the SaaS releases, see the BMC Helix Intelligent Integrations documentation.

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

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

No results.




 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*