Help us improve your experience.

Let us know what you think.

Do you have time for a two-minute survey?

 

Oracle Enterprise Manager

 

The JSA DSM for Oracle Enterprise Manager collects events from an Oracle Enterprise Manager device. The Real-time Monitoring Compliance feature of Oracle Enterprise Manager generates the events.

The following table lists the specifications for the Oracle Enterprise Manager DSM:

Table 1: Oracle Enterprise Manager DSM Specifications

Specification

Value

Manufacturer

Oracle

DSM name

Oracle Enterprise Manager

RPM file name

DSM-OracleEnterpriseManager-JSA_version-Buildbuild_number.noarch.rpm

Supported versions

Oracle Enterprise Manager Cloud Control 12c

Protocol

JDBC

Recorded event types

Audit

Compliance

Automatically discovered?

No

Includes identity?

Yes

Includes custom properties?

No

More information

Oracle Enterprise Manager (http://www.oracle.com/us/products/enterprise-manager/index.html)

The original format of the events are rows in an Oracle Enterprise Manager database view (sysman.mgmt$ccc_all_observations). JSA polls this view for new rows and uses them to generate events. For more information, see Compliance Views (http://docs.oracle.com/cd/E24628_01/doc.121/e57277/ch5_complianceviews.htm#BABBIJAA)

To collect events from Oracle Enterprise Manager, complete the following steps:

  1. If automatic updates are not enabled, download and install the most recent version of the Oracle Enterprise Manager DSM RPM on your JSA Console.

  2. Ensure that the Oracle Enterprise Manager system is configured to accept connections from external devices.

  3. Add an Oracle Enterprise Manager log source on the JSA Console. The following table describes the parameters that require specific values for Oracle Enterprise Manager event collection:

    Table 2: Oracle Enterprise Manager Log Source Parameters

    Parameter

    Description

    Log Source type

    Oracle Enterprise Manager

    Protocol Configuration

    JDBC

    Database Type

    Oracle

    Database Name

    The Service Name of Oracle Enterprise Manager database.

    To view the available service names, run the lsnrctl status command on the Oracle host.

    IP or Hostname

    The IP address or host name of host for Oracle Enterprise Manager database.

    Port

    The port that is used by the Oracle Enterprise Manager database.

    Username

    The user name of the account that has right to access the sysman.mgmt$ccc_all_observations table.

    Predefined Query

    none

    Table Name

    sysman.mgmt$ccc_all_observations

    Select List

    *

    Compare Field

    ACTION_TIME

    Use Prepared Statements

    True