The oraEM4AlertTable describes the SNMP traps sent from Oracle Enterprise Manager for both metric severity alerts and policy violations.
Table A-12 lists the variables of the oraEM4AlertTable and their corresponding Object IDs.
Table A-12 oraEM4AlertTable Variables and Corresponding Object IDs
| Variable Name | Object ID |
|---|---|
|
oraEM4AlertTargetName |
1.3.6.1.4.1.111.15.1.1.1.2.1 |
|
oraEM4AlertTargetType |
1.3.6.1.4.1.111.15.1.1.1.3.1 |
|
oraEM4AlertHostName |
1.3.6.1.4.1.111.15.1.1.1.4.1 |
|
oraEM4AlertMetricName |
1.3.6.1.4.1.111.15.1.1.1.5.1 |
|
oraEM4AlertKeyName |
1.3.6.1.4.1.111.15.1.1.1.6.1 |
|
oraEM4AlertKeyValue |
1.3.6.1.4.1.111.15.1.1.1.7.1 |
|
oraEM4AlertTimeStamp |
1.3.6.1.4.1.111.15.1.1.1.8.1 |
|
oraEM4AlertSeverity |
1.3.6.1.4.1.111.15.1.1.1.9.1 |
|
oraEM4AlertMessage |
1.3.6.1.4.1.111.15.1.1.1.10.1 |
|
oraEM4AlertRuleName |
1.3.6.1.4.1.111.15.1.1.1.11.1 |
|
oraEM4AlertRuleOwner |
1.3.6.1.4.1.111.15.1.1.1.12.1 |
|
oraEM4AlertMetricValue |
1.3.6.1.4.1.111.15.1.1.1.13.1 |
|
oraEM4AlertContext |
1.3.6.1.4.1.111.15.1.1.1.14.1 |
|
oraEM4AlertCycleGuid |
1.3.6.1.4.1.111.15.1.1.1.15.1 |
|
oraEM4AlertRepeatCount |
1.3.6.1.4.1.111.15.1.1.1.16.1 |
|
oraEM4AlertUDTargetProperties |
1.3.6.1.4.1.111.15.1.1.1.17.1 |
|
oraEM4AlertAck |
1.3.6.1.4.1.111.15.1.1.1.18.1 |
|
oraEM4AlertAckBy |
1.3.6.1.4.1.111.15.1.1.1.19.1 |
|
oraEM4AlertNotifType |
1.3.6.1.4.1.111.15.1.1.1.20.1 |
|
oraEM4AlertViolationGuid |
1.3.6.1.4.1.111.15.1.1.1.21.1 |
A description of each of these variables follows.
Syntax
DisplayString
Max-Access
Read-only
Status
Mandatory
Explanation
The name of the target to which this alert applies.
Typical Range
Not applicable
Significance
Very important
Syntax
DisplayString
Max-Access
read-only
Status
Mandatory
Explanation
The type of the target to which this alert applies.
Typical Range
Not applicable
Significance
Very important
Syntax
DisplayString
Max-Access
Read-only
Status
Mandatory
Explanation
The name of the host on which this alert originated.
Typical Range
Not applicable
Significance
Very important
Syntax
DisplayString
Max-Access
Read-only
Status
Mandatory
Explanation
The name of the metric or policy which generated this alert.
Typical Range
Not applicable
Significance
Very important
Syntax
DisplayString
Max-Access
Read-only
Status
Mandatory
Explanation
The name of the key-column, if present, for the metric which generated this alert.
Typical Range
Not applicable
Significance
Very important
Syntax
DisplayString
Max-Access
Read-only
Status
Mandatory
Explanation
The value of the key-column, if present, for the metric which generated this alert.
Typical Range
Not applicable
Significance
Very important
Syntax
DisplayString
Max-Access
read-only
Status
Mandatory
Explanation
The time at which this alert was generated.
Typical Range
Not applicable
Significance
Important
Syntax
DisplayString
Max-Access
Read-only
Status
Mandatory
Explanation
The severity of the alert (for example, Clear, Informational, Warning, Critical, Unreachable Start, Blackout End, Blackout Start, Metric Error Clear, Metric Error Start, Status Pending).
Typical Range
Critical, warning, clear
Significance
Very important
Syntax
DisplayString
Max-Access
Read-only
Status
Mandatory
Explanation
The message associated with the alert.
Typical Range
Not applicable
Significance
Very important
Syntax
DisplayString
Max-Access
Read-only
Status
Mandatory
Explanation
The name of the notification rule that caused this notification.
Typical Range
Not applicable
Significance
Important
Syntax
DisplayString
Max-Access
Read-only
Status
Mandatory
Explanation
The owner of the notification rule that caused this notification.
Typical Range
Not applicable
Significance
Important
Syntax
DisplayString
Max-Access
Read-only
Status
Mandatory
Explanation
The value of the metric which caused this alert to be generated.
Typical Range
Not applicable
Significance
Important
Syntax
DisplayString
Max-Access
Read-only
Status
Mandatory
Explanation
A comma separated list of metric column names and values associated with the metric that caused this alert to be generated.
Typical Range
Not applicable
Significance
Important
Syntax
DisplayString
Max-Access
Read-only
Status
Mandatory
Explanation
An Enterprise Manager-generated identifier that is unique for the lifecycle of an alert.
Typical Range
Not applicable
Significance
Important
Syntax
DisplayString
Max-Access
Read-only
Status
Mandatory
Explanation
The repeat notification counter for the alert.
Typical Range
Not applicable
Significance
Important
Syntax
DisplayString
Max-Access
Read-only
Status
Mandatory
Explanation
User-defined target properties associated with the target.
Typical Range
Not applicable
Significance
Important
Syntax
DisplayString
Max-Access
Read-only
Status
Mandatory
Explanation
Acknowledged status flag associated with the alert. 1 indicates acknowledged. 0 indicates unacknowledged.
Typical Range
Not applicable
Significance
Important
Syntax
DisplayString
Max-Access
Read-only
Status
Mandatory
Explanation
Acknowledged By value associated with the alert.
Typical Range
Not applicable
Significance
Important
Syntax
DisplayString
Max-Access
Read-only
Status
Mandatory
Explanation
Notification type.
Possible values:
1 - Normal
4 - Repeat
9 - Duration
Typical Range
Not applicable
Significance
Important