Job Status Change

Before Enterprise Manager 12c , job status change was sent using oraEM4JobAlert trap type. From Enterprise Manager 12c onwards, the event type corresponding to these alerts is the job_status_change alert. The value for the oraEMNGEventType in an Enterprise Manager 12c or 13c trap would be set to 'Job Status Change'.

Table -18 Job Status Change Mappings

Pre-12c OID Number Pre-12c OID Name 12c and later OID Number 12c and later OID Name

1.3.6.1.4.1.111.15.1.2.1.2.1

oraEM4JobAlertJobName

1.3.6.1.4.1.111.15.3.1.1.29.1

oraEMNGEventSourceObjName

1.3.6.1.4.1.111.15.1.2.1.3.1

oraEM4JobAlertJobOwner

1.3.6.1.4.1.111.15.3.1.1.33.1

oraEMNGEventSourceObjOwner

1.3.6.1.4.1.111.15.1.2.1.4.1

oraEM4JobAlertJobType

1.3.6.1.4.1.111.15.3.1.1.32.1

oraEMNGEventSourceObjSubType

1.3.6.1.4.1.111.15.1.2.1.5.1

oraEM4JobAlertJobStatus

1.3.6.1.4.1.111.15.3.1.1.62.1

oraEMNGEventTypeAttr2

1.3.6.1.4.1.111.15.1.2.1.6.1

oraEM4JobAlertTargets

1.3.6.1.4.1.111.15.3.1.1.23.1

oraEMNGEventTargetType and

NA

NA

1.3.6.1.4.1.111.15.3.1.1.21.1

oraEMNGEventTargetName

1.3.6.1.4.1.111.15.1.2.1.7.1

oraEM4JobAlertTimeStamp

1.3.6.1.4.1.111.15.3.1.1.10.1

oraEMNGEventReportedTime

1.3.6.1.4.1.111.15.1.2.1.8.1

oraEM4JobAlertRuleName

1.3.6.1.4.1.111.15.3.1.1.39.1

oraEMNGEventRuleSetName

1.3.6.1.4.1.111.15.1.2.1.9.1

oraEM4JobAlertRuleOwner

1.3.6.1.4.1.111.15.3.1.1.41.1

oraEMNGEventRuleOwner

1.3.6.1.4.1.111.15.1.2.1.10.1

oraEM4JobAlertMetricName

NA

NA

1.3.6.1.4.1.111.15.1.2.1.11.1

oraEM4JobAlertMetricValue

NA

NA

1.3.6.1.4.1.111.15.1.2.1.12.1

oraEM4JobAlertContext

1.3.6.1.4.1.111.15.3.1.1.44.1

oraEMNGEventContextAttrs

1.3.6.1.4.1.111.15.1.2.1.13.1

oraEM4JobAlertKeyName

NA

NA

1.3.6.1.4.1.111.15.1.2.1.14.1

oraEM4JobAlertKeyValue

NA

NA

1.3.6.1.4.1.111.15.1.2.1.15.1

oraEM4JobAlertSeverity

NA

NA

1.3.6.1.4.1.111.15.1.2.1.16.1

oraEM4JobAlertJobId

NA

NA

1.3.6.1.4.1.111.15.1.2.1.17.1

oraEM4JobAlertJobExecId

1.3.6.1.4.1.111.15.3.1.1.61.1

oraEMNGEventTypeAttr1

* Note: When mapping 1.3.6.1.4.1.111.15.1.1.1.7.1 oraEM4AlertKeyValue to a12c or 13c metric_alert event to 1.3.6.1.4.1.111.15.1.1.1.7.1 oraEM4AlertKeyValue, you must look at 1.3.6.1.4.1.111.15.3.1.1.84.1 oraEMNGEventTypeAttr24. 

if oraEMNGEventTypeAttr24 is null
       then
         oraEM4AlertKeyValue is null
 
       if oraEMNGEventTypeAttr24 value =  "Number of keys=1"
         oraEM4AlertKeyValue --> oraEMNGEventTypeAttr8
 
       if oraEMNGEventTypeAttr24 value =  "Number of keys=x" where x is greater than 1
         => check the values for the following pairs of attributes. 
            <oraEMNGEventTypeAttr10, oraEMNGEventTypeAttr11>
            <oraEMNGEventTypeAttr12, oraEMNGEventTypeAttr13>
            <oraEMNGEventTypeAttr14, oraEMNGEventTypeAttr15>
            <oraEMNGEventTypeAttr16, oraEMNGEventTypeAttr17>
            <oraEMNGEventTypeAttr18, oraEMNGEventTypeAttr19>
            <oraEMNGEventTypeAttr20, oraEMNGEventTypeAttr21>
            <oraEMNGEventTypeAttr22, oraEMNGEventTypeAttr23>
            ...
            ...

As many pairs as the number of parts present in the key would be populated, the rest of it will be set to null.

For each non-null pair of attributes, the first attribute provides the name for that part of the key and second attribute provides the value for that part of the key.

Note:

OID 1.3.6.1.4.1.111.15.3.1.1.13.1 specifies the event type. Examples:

For a metric_alert event type

oraEMNGEventType=Metric Alert

For a target_availability event type,

oraEMNGEventType=Target Availability

For a job_status_change event type

oraEMNGEventType=Job Status Change