ORALISTENER-MIB Table View

The table of information about the generic network listeners 
installed on a system.

oraListenerEntry row .1.3.6.1.4.1.111.5.1.1.1

An entry for a single generic network listener on the host.

Indexes

oraListenerIndex

Column	Syntax	OID
oraListenerIndexmandatory A numeric index, unique among all the generic listeners on this host.	Integer32 Type Constraints: range: -2147483648..2147483647	.1.3.6.1.4.1.111.5.1.1.1.1
oraListenerNamemandatory The name of this generic listener.	RFC1213-MIBDisplayString	.1.3.6.1.4.1.111.5.1.1.1.2
oraListenerVersionmandatory The version number of this generic listener, in vendor specific format.	RFC1213-MIBDisplayString	.1.3.6.1.4.1.111.5.1.1.1.3
oraListenerStartDatemandatory The date and time at which ths generic listener was started.	RFC1213-MIBDisplayString	.1.3.6.1.4.1.111.5.1.1.1.4
oraListenerUptimemandatory The value of sysUpTime at the time the generic listener was last started.	RFC1155-SMITimeTicks Type Constraints: range: 0..4294967295	.1.3.6.1.4.1.111.5.1.1.1.5
oraListenerTraceLevelmandatory 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.	Enumeration Enumerated Values: 1 level1 2 level2 3 level3 4 user 5 level5 6 admin 7 level7 8 level8 9 level9 10 level10 11 level11 12 level12 13 level13 14 level14 15 level15 16 level16 17 off	.1.3.6.1.4.1.111.5.1.1.1.6
oraListenerSecurityLevelmandatory 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…	Enumeration Enumerated Values: 1 on 2 off	.1.3.6.1.4.1.111.5.1.1.1.7
oraListenerParameterFilemandatory indicates the name of the file to which configuration information is stored. Default is $ORACLE_HOME/network/admin/ <listener_name>.ora.	RFC1213-MIBDisplayString	.1.3.6.1.4.1.111.5.1.1.1.8
oraListenerLogFilemandatory 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.	RFC1213-MIBDisplayString	.1.3.6.1.4.1.111.5.1.1.1.9
oraListenerTraceFilemandatory indicates the name of the file to which trace information is written. Default is $ORACLE_HOME/network/trace/<listener_name>.trc.	RFC1213-MIBDisplayString	.1.3.6.1.4.1.111.5.1.1.1.10
oraListenerStatemandatory 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…	Enumeration Enumerated Values: 1 up 2 down	.1.3.6.1.4.1.111.5.1.1.1.11
oraListenerNumberOfServicesmandatory indicates the number of different types services: dedicated sever, dispatcher, or prespawned shadow, configured with the generic listener.	Integer32 Type Constraints: range: -2147483648..2147483647	.1.3.6.1.4.1.111.5.1.1.1.12
oraListenerContactmandatory The textual identification of the contact person for this managed listener, together with information on how to contact this person.	RFC1213-MIBDisplayStringr/w	.1.3.6.1.4.1.111.5.1.1.1.13

The table of the dedicated servers associated with an system
identifier (SID) of the database.

oraDedicatedSrvEntry row .1.3.6.1.4.1.111.5.1.2.1

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 …

Indexes

oraSIDName oraDedicatedSrvIndex

Column	Syntax	OID
oraDedicatedSrvIndexmandatory A numeric index, unique among all the dedicated servers.	Integer32 Type Constraints: range: -2147483648..2147483647	.1.3.6.1.4.1.111.5.1.2.1.1
oraDedicatedSrvEstablishedConnectionsmandatory indicates how many incoming connection requests have been accepted by the dedicated server.	RFC1155-SMICounter Type Constraints: range: 0..4294967295	.1.3.6.1.4.1.111.5.1.2.1.2
oraDedicatedSrvRejectedConnectionsmandatory indicates how many incoming connection requests have been rejected by the dedicated server.	RFC1155-SMICounter Type Constraints: range: 0..4294967295	.1.3.6.1.4.1.111.5.1.2.1.3

The table of the dispatchers associated with an system
identifier (SID) of the database.

oraDispatcherEntry row .1.3.6.1.4.1.111.5.1.3.1

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…

Indexes

oraSIDName oraDispatcherIndex

Column	Syntax	OID
oraDispatcherIndexmandatory A numeric index, unique among all the dispatchers.	Integer32 Type Constraints: range: -2147483648..2147483647	.1.3.6.1.4.1.111.5.1.3.1.1
oraDispatcherEstablishedConnectionsmandatory indicates how many incoming connection requests have been accepted by the dispatcher.	RFC1155-SMICounter Type Constraints: range: 0..4294967295	.1.3.6.1.4.1.111.5.1.3.1.2
oraDispatcherRejectedConnectionsmandatory indicates how many incoming connection requests have been rejected by the dispatcher.	RFC1155-SMICounter Type Constraints: range: 0..4294967295	.1.3.6.1.4.1.111.5.1.3.1.3
oraDispatcherCurrentConnectionsmandatory indicates the number of connection requests currently being redirected to the dispatcher.	RFC1155-SMIGauge Type Constraints: range: 0..4294967295	.1.3.6.1.4.1.111.5.1.3.1.4
oraDispatcherMaximumConnectionsmandatory indicates the greatest number of connection requests that will ever be accepted by the dispatcher.	Integer32 Type Constraints: range: -2147483648..2147483647	.1.3.6.1.4.1.111.5.1.3.1.5
oraDispatcherStatemandatory 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 redirec…	Enumeration Enumerated Values: 1 blocked 2 ready	.1.3.6.1.4.1.111.5.1.3.1.6
oraDispatcherProtocolInfomandatory indicates the protocol of the dispatcher listens on as well as protocol specific information. The exact format will be vendor and host specific.	RFC1213-MIBDisplayString	.1.3.6.1.4.1.111.5.1.3.1.7

The table of the prespawned servers associated with a SID.

oraPrespawnedSrvEntry row .1.3.6.1.4.1.111.5.1.4.1

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 operatio…

Indexes

oraSIDName oraPrespawnedSrvIndex

Column	Syntax	OID
oraPrespawnedSrvIndexmandatory A numeric index, unique among all the prespawned servers.	Integer32 Type Constraints: range: -2147483648..2147483647	.1.3.6.1.4.1.111.5.1.4.1.1
oraPrespawnedSrvEstablishedConnectionsmandatory indicates how many incoming connection requests have been accepted by the prespawned server.	RFC1155-SMICounter Type Constraints: range: 0..4294967295	.1.3.6.1.4.1.111.5.1.4.1.2
oraPrespawnedSrvRejectedConnectionsmandatory indicates how many incoming connection requests have been rejected by the prespawned server.	RFC1155-SMICounter Type Constraints: range: 0..4294967295	.1.3.6.1.4.1.111.5.1.4.1.3
oraPrespawnedSrvCurrentConnectionsmandatory indicates the number of connection requests currently being redirected to the prespawned server.	RFC1155-SMIGauge Type Constraints: range: 0..4294967295	.1.3.6.1.4.1.111.5.1.4.1.4
oraPrespawnedSrvMaximumConnectionsmandatory indicates the greatest number of connection requests that will ever be accepted by the prespawned server.	Integer32 Type Constraints: range: -2147483648..2147483647	.1.3.6.1.4.1.111.5.1.4.1.5
oraPrespawnedSrvStatemandatory 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 acc…	Enumeration Enumerated Values: 1 blocked 2 ready	.1.3.6.1.4.1.111.5.1.4.1.6
oraPrespawnedSrvProtocolInfomandatory indicates the protocol of the prespawned server listens on as well as protocol specific information. The exact format will be vendor and host specific.	RFC1213-MIBDisplayString	.1.3.6.1.4.1.111.5.1.4.1.7
oraPrespawnedSrvProcessorIDmandatory indicates the process ID of the prespawned server.	RFC1213-MIBDisplayString	.1.3.6.1.4.1.111.5.1.4.1.8

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 row .1.3.6.1.4.1.111.5.1.5.1

An entry relating a SID to a generic listener.

Indexes

oraSIDName

Column	Syntax	OID
oraSIDListenerIndexmandatory A numeric index, unique among all the generic listeners.	Integer32 Type Constraints: range: -2147483648..2147483647	.1.3.6.1.4.1.111.5.1.5.1.1
oraSIDNamemandatory The name of the SID. There is a one-to-one correspondence between database and SID.	RFC1213-MIBDisplayString	.1.3.6.1.4.1.111.5.1.5.1.2
oraSIDCurrentConnectedClientsmandatory indicates the total number of currently connected clients thru this SID.	RFC1155-SMIGauge Type Constraints: range: 0..4294967295	.1.3.6.1.4.1.111.5.1.5.1.3
oraSIDReservedConnectionsmandatory indicates the total number of reserved connections for clients on this SID.	RFC1155-SMICounter Type Constraints: range: 0..4294967295	.1.3.6.1.4.1.111.5.1.5.1.4

The table of information about the addresses that the listener
is listening at.

oraListenAddressEntry row .1.3.6.1.4.1.111.5.1.6.1

An entry relating the listen addresses to a generic listener.

Indexes

oraListenerIndex oraListenAddressIndex

Column	Syntax	OID
oraListenAddressIndexmandatory A numeric index, unique among all the listen addresses.	Integer32 Type Constraints: range: -2147483648..2147483647	.1.3.6.1.4.1.111.5.1.6.1.1
oraListenAddressmandatory The addresses to whom the listener is listening at.	RFC1213-MIBDisplayString	.1.3.6.1.4.1.111.5.1.6.1.2