ORALISTENER-MIB

All MIBs › ORALISTENER-MIB

Category: Database

Description: Monitors Oracle Net listener process status, connection counts, and service registrations.

Start monitoring vendor-neutral, standards-based MIB, any SNMPv3-capable network device (SNMP engine identity/boot/clock status) with a free 30-day trial of IPNetwork Monitor. Import MIBs, browse SNMP OIDs, create custom SNMP monitors, configure alerts, and monitor any SNMP-enabled network device from a single console.

What Is ORALISTENER-MIB?

ORALISTENER-MIB is a vendor-specific SNMP module for monitoring the Oracle Net Listener, the background process that accepts incoming client connections and routes them to Oracle database instances. It exposes a listener table describing each configured listener's identity, version, configuration files, and operational parameters such as trace and security levels. Its core monitoring value is software/process status: it reports oraListenerStartDate and oraListenerUptime so an administrator can confirm the listener process is running continuously and detect unexpected restarts, and it surfaces log/trace/parameter file paths used for troubleshooting connectivity failures. It is a companion module to ORADB-MIB and relies on general SNMPv2-SMI textual conventions rather than any DB-specific standard. It is deployed on Oracle database hosts so that network monitoring tools can detect listener downtime independently of the database engine itself, since a database can be healthy while its listener is down and unreachable. Engineers can download the ORALISTENER-MIB file directly to load it into their MIB browser.

IPNetwork Monitor allows you to monitor SNMP objects defined in ORALISTENER-MIB. Use the built-in SNMP Monitoring Browser to explore available variables, view their current values and descriptions, and select the objects you want to monitor. You can then create SNMP monitors, configure thresholds, and receive alerts when monitored values change.

Supported Devices

Oracle database server
Oracle Net Listener process host

Monitoring Examples

An operator polls oraListenerTable/oraListenerEntry using oraListenerIndex to enumerate configured listeners, then checks oraListenerUptime and oraListenerStartDate to confirm the listener process has not silently restarted. If oraListenerUptime unexpectedly resets to a low value, it indicates a listener crash or manual bounce, prompting a check of oraListenerLogFile and oraListenerTraceFile for the root cause. oraListenerSecurityLevel can also be monitored to flag configuration drift toward a less secure setting.

What Can Be Monitored

listener uptime
listener start time
listener version
trace level
security level
log/trace/parameter file locations

Imported Objects

From RFC-1212

OBJECT-TYPE

From RFC-1215

TRAP-TYPE

From RFC1155-SMI

Counter
Gauge
TimeTicks
enterprises

From RFC1213-MIB

DisplayString

OIDs

OID symbolic	OID numeric	Type	Access	Description
oracle	1.3.6.1.4.1.111
oraListenerMIB	1.3.6.1.4.1.111.5
oraListenerObjects	1.3.6.1.4.1.111.5.1
oraListenerTable	1.3.6.1.4.1.111.5.1.1		not-accessible	The table of information about the generic network listeners installed on a system.
oraListenerEntry	1.3.6.1.4.1.111.5.1.1.1		not-accessible	An entry for a single generic network listener on the host.
INT oraListenerIndex	1.3.6.1.4.1.111.5.1.1.1.1	INTEGER	read-only	A numeric index, unique among all the generic listeners on this host.
STR oraListenerName	1.3.6.1.4.1.111.5.1.1.1.2	DisplayString	read-only	The name of this generic listener.
STR oraListenerVersion	1.3.6.1.4.1.111.5.1.1.1.3	DisplayString	read-only	The version number of this generic listener, in vendor specific format.
STR oraListenerStartDate	1.3.6.1.4.1.111.5.1.1.1.4	DisplayString	read-only	The date and time at which ths generic listener was started.
TIK oraListenerUptime	1.3.6.1.4.1.111.5.1.1.1.5	TimeTicks	read-only	The value of sysUpTime at the time the generic listener was last started.
INT oraListenerTraceLevel	1.3.6.1.4.1.111.5.1.1.1.6	INTEGER	read-only	indicates the level of detail the trace facility the generic listener records for events. The greater the level is, the more detailed the level of tracing is.
INT oraListenerSecurityLevel	1.3.6.1.4.1.111.5.1.1.1.7	INTEGER	read-only	indicates whether the generic listener is password-protected or not. If security is 'on', password is required to perform certain DBA tasks asgainst the listener using the listener control utility. If security is 'off', password is not required.
STR oraListenerParameterFile	1.3.6.1.4.1.111.5.1.1.1.8	DisplayString	read-only	indicates the name of the file to which configuration information is stored. Default is $ORACLE_HOME/network/admin/ .ora.
STR oraListenerLogFile	1.3.6.1.4.1.111.5.1.1.1.9	DisplayString	read-only	indicates the directory in which to find the log file that is automatically generated for listener events. Default is operating system specific; on UNIX, for example, it is $ORACLE_HOME/network/log.
STR oraListenerTraceFile	1.3.6.1.4.1.111.5.1.1.1.10	DisplayString	read-only	indicates the name of the file to which trace information is written. Default is $ORACLE_HOME/network/trace/.trc.
INT oraListenerState	1.3.6.1.4.1.111.5.1.1.1.11	INTEGER	read-only	indicates the current state of the generic listener. 'down' indicates that the generic listener is not available for any use, but is know to the agent. 'up' indicates that the generic listener is running and available for generic use. This would be inspected by an agent on receipt of an oraListenerState trap.
INT oraListenerNumberOfServices	1.3.6.1.4.1.111.5.1.1.1.12	INTEGER	read-only	indicates the number of different types services: dedicated sever, dispatcher, or prespawned shadow, configured with the generic listener.
STR oraListenerContact	1.3.6.1.4.1.111.5.1.1.1.13	DisplayString	read-write	The textual identification of the contact person for this managed listener, together with information on how to contact this person.
oraDedicatedSrvTable	1.3.6.1.4.1.111.5.1.2		not-accessible	The table of the dedicated servers associated with an system identifier (SID) of the database.
oraDedicatedSrvEntry	1.3.6.1.4.1.111.5.1.2.1		not-accessible	An entry relating a dedicated server to a SID. The table is indexed first by oraSIDName, and then oraDedicatedSrvIndex so that all dedicated servers associated with a given SID can be found by SNMP traversal operations (get-next and get-bulk).
INT oraDedicatedSrvIndex	1.3.6.1.4.1.111.5.1.2.1.1	INTEGER	read-only	A numeric index, unique among all the dedicated servers.
CTR oraDedicatedSrvEstablishedConnections	1.3.6.1.4.1.111.5.1.2.1.2	Counter	read-only	indicates how many incoming connection requests have been accepted by the dedicated server.
CTR oraDedicatedSrvRejectedConnections	1.3.6.1.4.1.111.5.1.2.1.3	Counter	read-only	indicates how many incoming connection requests have been rejected by the dedicated server.
oraDispatcherTable	1.3.6.1.4.1.111.5.1.3		not-accessible	The table of the dispatchers associated with an system identifier (SID) of the database.
oraDispatcherEntry	1.3.6.1.4.1.111.5.1.3.1		not-accessible	An entry relating a dispatcher to a SID. The table is indexed first by oraSIDName, and then oraDispatcherIndex so that all dispatchers associated with a given SID can be found by SNMP traversal operations (get-next and get-bulk).
INT oraDispatcherIndex	1.3.6.1.4.1.111.5.1.3.1.1	INTEGER	read-only	A numeric index, unique among all the dispatchers.
CTR oraDispatcherEstablishedConnections	1.3.6.1.4.1.111.5.1.3.1.2	Counter	read-only	indicates how many incoming connection requests have been accepted by the dispatcher.
CTR oraDispatcherRejectedConnections	1.3.6.1.4.1.111.5.1.3.1.3	Counter	read-only	indicates how many incoming connection requests have been rejected by the dispatcher.
GAU oraDispatcherCurrentConnections	1.3.6.1.4.1.111.5.1.3.1.4	Gauge	read-only	indicates the number of connection requests currently being redirected to the dispatcher.
INT oraDispatcherMaximumConnections	1.3.6.1.4.1.111.5.1.3.1.5	INTEGER	read-only	indicates the greatest number of connection requests that will ever be accepted by the dispatcher.
INT oraDispatcherState	1.3.6.1.4.1.111.5.1.3.1.6	INTEGER	read-only	indicates the current state of the dispatcher. 'blocked' indicates that the dispatcher is temporarily not accepting redirected connectioin requests. 'ready' indicates that the dispacher is ready to accept any redirected conenction requests.
STR oraDispatcherProtocolInfo	1.3.6.1.4.1.111.5.1.3.1.7	DisplayString	read-only	indicates the protocol of the dispatcher listens on as well as protocol specific information. The exact format will be vendor and host specific.
oraPrespawnedSrvTable	1.3.6.1.4.1.111.5.1.4		not-accessible	The table of the prespawned servers associated with a SID.
oraPrespawnedSrvEntry	1.3.6.1.4.1.111.5.1.4.1		not-accessible	An entry relating a prespawned server to a SID. The table is indexed first by oraSIDName, and then oraPrespawnedSrvIndex so that all prespawned servers associated with a given SID can be found by SNMP traversal operations (get-next and get-bulk).
INT oraPrespawnedSrvIndex	1.3.6.1.4.1.111.5.1.4.1.1	INTEGER	read-only	A numeric index, unique among all the prespawned servers.
CTR oraPrespawnedSrvEstablishedConnections	1.3.6.1.4.1.111.5.1.4.1.2	Counter	read-only	indicates how many incoming connection requests have been accepted by the prespawned server.
CTR oraPrespawnedSrvRejectedConnections	1.3.6.1.4.1.111.5.1.4.1.3	Counter	read-only	indicates how many incoming connection requests have been rejected by the prespawned server.
GAU oraPrespawnedSrvCurrentConnections	1.3.6.1.4.1.111.5.1.4.1.4	Gauge	read-only	indicates the number of connection requests currently being redirected to the prespawned server.
INT oraPrespawnedSrvMaximumConnections	1.3.6.1.4.1.111.5.1.4.1.5	INTEGER	read-only	indicates the greatest number of connection requests that will ever be accepted by the prespawned server.
INT oraPrespawnedSrvState	1.3.6.1.4.1.111.5.1.4.1.6	INTEGER	read-only	indicates the current state of the prespawned server. 'blocked' indicates that the prespawned server is temporarily not accepting redirected connection requests. 'ready' indicates the prespawned server is ready to accept any redirected conenction requests.
STR oraPrespawnedSrvProtocolInfo	1.3.6.1.4.1.111.5.1.4.1.7	DisplayString	read-only	indicates the protocol of the prespawned server listens on as well as protocol specific information. The exact format will be vendor and host specific.
STR oraPrespawnedSrvProcessorID	1.3.6.1.4.1.111.5.1.4.1.8	DisplayString	read-only	indicates the process ID of the prespawned server.
oraSIDTable	1.3.6.1.4.1.111.5.1.5		not-accessible	The table of information about the SIDs of the databases for whom the listener listens on. The system identifier (SID) specifies the ORACLE System ID of the database server.
oraSIDEntry	1.3.6.1.4.1.111.5.1.5.1		not-accessible	An entry relating a SID to a generic listener.
INT oraSIDListenerIndex	1.3.6.1.4.1.111.5.1.5.1.1	INTEGER	read-only	A numeric index, unique among all the generic listeners.
STR oraSIDName	1.3.6.1.4.1.111.5.1.5.1.2	DisplayString	read-only	The name of the SID. There is a one-to-one correspondence between database and SID.
GAU oraSIDCurrentConnectedClients	1.3.6.1.4.1.111.5.1.5.1.3	Gauge	read-only	indicates the total number of currently connected clients thru this SID.
CTR oraSIDReservedConnections	1.3.6.1.4.1.111.5.1.5.1.4	Counter	read-only	indicates the total number of reserved connections for clients on this SID.
oraListenAddressTable	1.3.6.1.4.1.111.5.1.6		not-accessible	The table of information about the addresses that the listener is listening at.
oraListenAddressEntry	1.3.6.1.4.1.111.5.1.6.1		not-accessible	An entry relating the listen addresses to a generic listener.
INT oraListenAddressIndex	1.3.6.1.4.1.111.5.1.6.1.1	INTEGER	read-only	A numeric index, unique among all the listen addresses.
STR oraListenAddress	1.3.6.1.4.1.111.5.1.6.1.2	DisplayString	read-only	The addresses to whom the listener is listening at.
oraListenerTraps	1.3.6.1.4.1.111.5.2
NTF oraListenerStateChange	1.3.6.1.4.1.111.5.2.0.1			An rdbmsStateChange trap signifies that one of the generic listeners managed by this agent has changed its oraListenerState in a way that makes it less accessible for use.

RFC description

Oracle private MIB for monitoring and managing the Oracle Listener component of Oracle Net Services. Provides SNMP objects for tracking listener status, connection information, and events on Oracle database infrastructure.

Start monitoring Oracle database server (Oracle Net Listener process) with a free 30-day trial of IPNetwork Monitor. Import MIBs, browse SNMP OIDs, create custom SNMP monitors, configure alerts, and monitor any SNMP-enabled network device from a single console.

Download ORALISTENER-MIB

What Is ORALISTENER-MIB?

Supported Devices

Monitoring Examples

What Can Be Monitored

This MIB depends on

Related MIBs

RFC description