Oracle SNMP Support Reference Guide Release 8.0.3 A53704_01 |
|
This appendix provides information to help you interpret the variables of the private Oracle Enterprise Manager MIB which are implemented in this release. Specifically, it includes sections covering SNMP variables in the following tables:
Table F-1 lists the variables of the oraAgentEventTable and their corresponding Object IDs.
A description of each of these variables follows.
INTEGER
read-only
Index for OraAgentEventTable.
not applicable
very important
none
alarm
DisplayString
read-only
mandatory
The name of the event that occurred.
not applicable
very important
none
alarm
INTEGER
read-only
mandatory
The ID of the registration that generated this event occurrence.
not applicable
very important
none
alarm
DisplayString
read-only
mandatory
The name of the service (database, SQL*Net listener, etc.) being monitored by this event.
not applicable
very important
none
alarm
DateAndTime
read-only
mandatory
The time at which this event was detected.
not applicable
very important
none
alarm
INTEGER {warning(1), alert(2)}
read-only
mandatory
A relative measure of the severity of the event.
not applicable
very important
none
alarm
DisplayString
read-only
mandatory
The name of the user who registered for this event.
not applicable
Very important
Alarm
Integer
read-only
mandatory
The ID of the Enterprise Manager console application through which this event was registered.
not applicable
Very important
Alarm
DisplayString
read-only
mandatory
Message associated with the event.
not applicable
very important
none
alarm
DisplayString
read-only
mandatory
The arguments that were passed to the script that detected this event.
not applicable
very important
none
alarm
DisplayString
read-only
mandatory
The results generated by the script that detected this event.
not applicable
very important
none
alarm
Unlike other SNMP variables, a trap variable is not an agent's response to a management station's request for information. Rather, it is a unsolicited message that an agent can send to a management station when that agent notices that some condition has occurred (a threshold has been reached, for example).
All events discovered by the Oracle Enterprise Manager agent can be configured to send an SNMP trap when the event occurs.
Traps sent out by the Oracle Enterprise Manager agent can be received by any tool that is listening on the standard UDP port 162 and is able to perform the required ASN.1 decoding. There is a wide variety of such products, ranging from free software available over the Internet to sophisticated network management platforms including HP's OpenView, Sun's Solstice, and IBM's NetView/6000.
This feature of the Oracle Enterprise Manager agent is available on platforms that support SNMP and only if the extensible SNMP master agent is started. The agent attempts to connect to the SNMP master agent at startup time. If this fails, either because the platform does not support SNMP or the master agent is not started, then no traps are sent. The destination of all traps is determined by the configuration matter of the SNMP master agent. See your operating system-specific documentation for details.
Table F-2 lists each oraAgentTraps variable and its corresponding object ID.
{oraAgentEventName, oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults}
The Enterprise Manager agent has detected an occurrence of an event for which it has no specific trap.
not applicable
very important
oraAgentEventName, oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults
alarm
{oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage}
The database whose name is specified by oraAgentEventService has gone down.
not applicable
very important
oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage
alarm
{oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventResults}
The Enterprise Manager agent has found a new message in the alert log of the database specified by oraAgentEventService. The text of the alert is found in oraAgentEventResults.
not applicable
very important
oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventResults
alarm
{oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage}
The Enterprise Manager agent was unable to establish a new connection to the database specified by oraAgentEventService.
not applicable
very important
oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage
alarm
{oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventResults}
One or more user sessions on the database specified by oraAgentEventService hold locks that block other processes. A list of these lock-holding sessions is found in oraAgentEventResults.
not applicable
very important
oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventResults
alarm
{oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults}
The available space remaining on the archive device of the database specified by oraAgentEventService has passed a configured threshold. The amount (number of bytes) of space remaining on the device is found in oraAgentEventResults.
not applicable
very important
oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults
alarm
{oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults}
The available space remaining in the dump area of the database specified by oraAgentEventService has passed a configured threshold. The amount (number of bytes) of space remaining in the area is found in oraAgentEventResults.
not applicable
very important
oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults
alarm
{oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults}
One or more segments in tablespaces of the database specified by oraAgentEventService are closer than a configured threshold to their max extents. A list of segment names, their tablespaces, and their number of remaining extents is found in oraAgentEventResults.
not applicable
very important
oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults
alarm
{oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults}
One or more segments in tablespaces of the database specified by oraAgentEventService cannot allocate additional extents. A list of tablespace names, segment names, segment types, next extent sizes, and largest available chunks is found in oraAgentEventResults.
not applicable
very important
oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults}
alarm
{oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults}
The number of datafiles in the database specified by oraAgentEventService has reached a configured percentage of the maximum allowable number. The current number is found in oraAgentEventResults.
not applicable
very important
oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults
alarm
{oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults }
The number of existing locks in the database specified by oraAgentEventService has reached a configured percentage of the maximum allowable number. The current number of locks and the maximum are found in oraAgentEventResults.
not applicable
very important
oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults
alarm
{oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults}
The number of processes used by the database specified by oraAgentEventService has reached a configured percentage of the maximum allowable number. The current number of processes and the maximum are found in oraAgentEventResults.
not applicable
very important
oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults
alarm
{oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults}
The number of sessions open with the database specified by oraAgentEventService has reached a configured percentage of the maximum allowable number. The current number of sessions and the maximum are found in oraAgentEventResults.
not applicable
very important
oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults
alarm
{oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults }
The number of users connected to the database specified by oraAgentEventService has reached a configured percentage of the maximum allowable number. The current number of users and the maximum are found in oraAgentEventResults.
not applicable
very important
oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults
alarm
{oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults}
The buffer cache hit ratio for the database specified by oraAgentEventService has dipped below a configured threshold. The current buffer cache hit ratio is found in oraAgentEventResults.
not applicable
very important
oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults
alarm
{oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults}
One or more tables or clusters in the database specified by oraAgentEventService have chained rows. A list of the affected tables and clusters is found in oraAgentEventResults.
not applicable
very important
oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults
alarm
{oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults}
The data dictionary cache miss ratio for the database specified by oraAgentEventService has exceeded a configured threshold. The current data dictionary cache miss ratio is found in oraAgentEventResults.
not applicable
very important
oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults
alarm
{oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults}
The physical disk I/O rate for the database specified by oraAgentEventService has exceeded a configured threshold. The current disk I/O rate is found in oraAgentEventResults.
not applicable
very important
oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults
alarm
{oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults }
The library cache miss ratio for the database specified by oraAgentEventService has exceeded a configured threshold. The current library cache miss ratio is found in oraAgentEventResults.
not applicable
very important
oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults
alarm
{oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults}
The network I/O rate for the database specified by oraAgentEventService has exceeded a configured threshold. The current network I/O rate is found in oraAgentEventResults.
not applicable
very important
oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults
alarm
{oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults}
The response time by the database specified by oraAgentEventService to an application has exceeded a configured threshold. The measured response time is found in oraAgentEventResults.
not applicable
very important
oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults
alarm
{oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults }
The value of a V$SYSSTAT parameter on the database specified by oraAgentEventService has exceeded a configured threshold. The current value of the parameter is found in oraAgentEventResults.
not applicable
very important
oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults
alarm
{oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults}
The change in value of a v$sysstat parameter on the database specified by oraAgentEventService has exceeded a configured threshold. The current value of the parameter is found in oraAgentEventResults.
not applicable
very important
oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults
The change in value of a V$SYSSTAT parameter on the database specified by oraAgentEventService has exceeded a configured threshold. The current value of the parameter is found in oraAgentEventResults.
alarm
{oraAgentEventID, oraAgentEventService,oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage }
The listener whose name is specified by oraAgentEventService has gone down.
not applicable
very important
oraAgentEventID, oraAgentEventService,oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage
alarm
{oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults }
The CPU load for the host has exceeded a configured threshold. The current CPU load is found in oraAgentEventResults.
not applicable
very important
oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults
alarm
{oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults }
The CPU utilization for the host has exceeded a configured threshold. The current CPU utilization is found in oraAgentEventResults.
not applicable
very important
{oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults }
alarm
{oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults }
The paging rate for the host has exceeded a configured threshold. The current paging rate is found in oraAgentEventResults.
not applicable
very important
oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults
alarm
{oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults }
The amount of available space remaining in the swap area for the host has dipped below a configured threshold. The amount of currently available swap space is found in oraAgentEventResults.
not applicable
very important
oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults
alarm
{oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults}
The amount of available space remaining on one or more disks attached to the host has dipped below a configured threshold. The names of affected disks and the amount of currently available space on each is found in oraAgentEventResults.
not applicable
very important
oraAgentEventID, oraAgentEventService, oraAgentEventTime, oraAgentEventSeverity, oraAgentEventUser, oraAgentEventAppID, oraAgentEventMessage, oraAgentEventArguments, oraAgentEventResults
alarm