ORALISTENER-MIB Table View

Table-centric layout grouping table, row, and column objects.

Standard view Table view
Tables
6
Rows
6
Columns
37

oraListenerTable

table mandatory
.1.3.6.1.4.1.111.5.1.1 · 1 row entry · 13 columns
Open in standard view 
The table of information about the generic network listeners 
installed on a system.
oraListenerEntry entry .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
oraListenerIndex mandatory
A numeric index, unique among all the generic listeners
on this host.
Integer32
Textual Convention: COPS-PR-SPPIInteger32 Integer32
Type Constraints:
range: -2147483648..2147483647
 .1.3.6.1.4.1.111.5.1.1.1.1
oraListenerName mandatory
The name of this generic listener.
RFC1213-MIBDisplayString
Textual Convention: RFC1213-MIBDisplayString OctetString
 .1.3.6.1.4.1.111.5.1.1.1.2
oraListenerVersion mandatory
The version number of this generic listener, in vendor specific
format.
RFC1213-MIBDisplayString
Textual Convention: RFC1213-MIBDisplayString OctetString
 .1.3.6.1.4.1.111.5.1.1.1.3
oraListenerStartDate mandatory
The date and time at which ths generic listener was started.
RFC1213-MIBDisplayString
Textual Convention: RFC1213-MIBDisplayString OctetString
 .1.3.6.1.4.1.111.5.1.1.1.4
oraListenerUptime mandatory
The value of sysUpTime at the time the generic listener
was last started.
RFC1155-SMITimeTicks
Textual Convention: RFC1155-SMITimeTicks Unsigned32
Type Constraints:
range: 0..4294967295
 .1.3.6.1.4.1.111.5.1.1.1.5
oraListenerTraceLevel mandatory
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:
1level1
2level2
3level3
4user
5level5
6admin
7level7
8level8
9level9
10level10
11level11
12level12
13level13
14level14
15level15
16level16
17off
 .1.3.6.1.4.1.111.5.1.1.1.6
oraListenerSecurityLevel mandatory
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:
1on
2off
 .1.3.6.1.4.1.111.5.1.1.1.7
oraListenerParameterFile mandatory
indicates the name of the file to which configuration
information is stored. Default is $ORACLE_HOME/network/admin/
<listener_name>.ora.
RFC1213-MIBDisplayString
Textual Convention: RFC1213-MIBDisplayString OctetString
 .1.3.6.1.4.1.111.5.1.1.1.8
oraListenerLogFile mandatory
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
Textual Convention: RFC1213-MIBDisplayString OctetString
 .1.3.6.1.4.1.111.5.1.1.1.9
oraListenerTraceFile mandatory
indicates the name of the file to which trace information is
written. Default is $ORACLE_HOME/network/trace/<listener_name>.trc.
RFC1213-MIBDisplayString
Textual Convention: RFC1213-MIBDisplayString OctetString
 .1.3.6.1.4.1.111.5.1.1.1.10
oraListenerState mandatory
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:
1up
2down
 .1.3.6.1.4.1.111.5.1.1.1.11
oraListenerNumberOfServices mandatory
indicates the number of different types services: dedicated
sever, dispatcher, or prespawned shadow, configured with the
generic listener.
Integer32
Textual Convention: COPS-PR-SPPIInteger32 Integer32
Type Constraints:
range: -2147483648..2147483647
 .1.3.6.1.4.1.111.5.1.1.1.12
oraListenerContact mandatory
The textual identification of the contact person for this
managed listener, together with information on how to contact
this person.
RFC1213-MIBDisplayStringr/w
Textual Convention: RFC1213-MIBDisplayString OctetString
 .1.3.6.1.4.1.111.5.1.1.1.13

oraDedicatedSrvTable

table mandatory
.1.3.6.1.4.1.111.5.1.2 · 1 row entry · 3 columns
Open in standard view 
The table of the dedicated servers associated with an system
identifier (SID) of the database.
oraDedicatedSrvEntry entry .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
oraDedicatedSrvIndex mandatory
A numeric index, unique among all the dedicated servers.
Integer32
Textual Convention: COPS-PR-SPPIInteger32 Integer32
Type Constraints:
range: -2147483648..2147483647
 .1.3.6.1.4.1.111.5.1.2.1.1
oraDedicatedSrvEstablishedConnections mandatory
indicates how many incoming connection requests have been
accepted by the dedicated server.
RFC1155-SMICounter
Textual Convention: RFC1155-SMICounter Unsigned32
Type Constraints:
range: 0..4294967295
 .1.3.6.1.4.1.111.5.1.2.1.2
oraDedicatedSrvRejectedConnections mandatory
indicates how many incoming connection requests have been
rejected by the dedicated server.
RFC1155-SMICounter
Textual Convention: RFC1155-SMICounter Unsigned32
Type Constraints:
range: 0..4294967295
 .1.3.6.1.4.1.111.5.1.2.1.3

oraDispatcherTable

table mandatory
.1.3.6.1.4.1.111.5.1.3 · 1 row entry · 7 columns
Open in standard view 
The table of the dispatchers associated with an system
identifier (SID) of the database.
oraDispatcherEntry entry .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
oraDispatcherIndex mandatory
A numeric index, unique among all the dispatchers.
Integer32
Textual Convention: COPS-PR-SPPIInteger32 Integer32
Type Constraints:
range: -2147483648..2147483647
 .1.3.6.1.4.1.111.5.1.3.1.1
oraDispatcherEstablishedConnections mandatory
indicates how many incoming connection requests have been
accepted by the dispatcher.
RFC1155-SMICounter
Textual Convention: RFC1155-SMICounter Unsigned32
Type Constraints:
range: 0..4294967295
 .1.3.6.1.4.1.111.5.1.3.1.2
oraDispatcherRejectedConnections mandatory
indicates how many incoming connection requests have been
rejected by the dispatcher.
RFC1155-SMICounter
Textual Convention: RFC1155-SMICounter Unsigned32
Type Constraints:
range: 0..4294967295
 .1.3.6.1.4.1.111.5.1.3.1.3
oraDispatcherCurrentConnections mandatory
indicates the number of connection requests currently being
redirected to the dispatcher.
RFC1155-SMIGauge
Textual Convention: RFC1155-SMIGauge Unsigned32
Type Constraints:
range: 0..4294967295
 .1.3.6.1.4.1.111.5.1.3.1.4
oraDispatcherMaximumConnections mandatory
indicates the greatest number of connection requests that
will ever be accepted by the dispatcher.
Integer32
Textual Convention: COPS-PR-SPPIInteger32 Integer32
Type Constraints:
range: -2147483648..2147483647
 .1.3.6.1.4.1.111.5.1.3.1.5
oraDispatcherState mandatory
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:
1blocked
2ready
 .1.3.6.1.4.1.111.5.1.3.1.6
oraDispatcherProtocolInfo mandatory
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
Textual Convention: RFC1213-MIBDisplayString OctetString
 .1.3.6.1.4.1.111.5.1.3.1.7

oraPrespawnedSrvTable

table mandatory
.1.3.6.1.4.1.111.5.1.4 · 1 row entry · 8 columns
Open in standard view 
The table of the prespawned servers associated with a SID.
oraPrespawnedSrvEntry entry .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
oraPrespawnedSrvIndex mandatory
A numeric index, unique among all the prespawned servers.
Integer32
Textual Convention: COPS-PR-SPPIInteger32 Integer32
Type Constraints:
range: -2147483648..2147483647
 .1.3.6.1.4.1.111.5.1.4.1.1
oraPrespawnedSrvEstablishedConnections mandatory
indicates how many incoming connection requests have been
accepted by the prespawned server.
RFC1155-SMICounter
Textual Convention: RFC1155-SMICounter Unsigned32
Type Constraints:
range: 0..4294967295
 .1.3.6.1.4.1.111.5.1.4.1.2
oraPrespawnedSrvRejectedConnections mandatory
indicates how many incoming connection requests have been
rejected by the prespawned server.
RFC1155-SMICounter
Textual Convention: RFC1155-SMICounter Unsigned32
Type Constraints:
range: 0..4294967295
 .1.3.6.1.4.1.111.5.1.4.1.3
oraPrespawnedSrvCurrentConnections mandatory
indicates the number of connection requests currently being
redirected to the prespawned server.
RFC1155-SMIGauge
Textual Convention: RFC1155-SMIGauge Unsigned32
Type Constraints:
range: 0..4294967295
 .1.3.6.1.4.1.111.5.1.4.1.4
oraPrespawnedSrvMaximumConnections mandatory
indicates the greatest number of connection requests that
will ever be accepted by the prespawned server.
Integer32
Textual Convention: COPS-PR-SPPIInteger32 Integer32
Type Constraints:
range: -2147483648..2147483647
 .1.3.6.1.4.1.111.5.1.4.1.5
oraPrespawnedSrvState mandatory
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:
1blocked
2ready
 .1.3.6.1.4.1.111.5.1.4.1.6
oraPrespawnedSrvProtocolInfo mandatory
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
Textual Convention: RFC1213-MIBDisplayString OctetString
 .1.3.6.1.4.1.111.5.1.4.1.7
oraPrespawnedSrvProcessorID mandatory
indicates the process ID of the prespawned server.
RFC1213-MIBDisplayString
Textual Convention: RFC1213-MIBDisplayString OctetString
 .1.3.6.1.4.1.111.5.1.4.1.8

oraSIDTable

table mandatory
.1.3.6.1.4.1.111.5.1.5 · 1 row entry · 4 columns
Open in standard view 
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 entry .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
oraSIDListenerIndex mandatory
A numeric index, unique among all the generic listeners.
Integer32
Textual Convention: COPS-PR-SPPIInteger32 Integer32
Type Constraints:
range: -2147483648..2147483647
 .1.3.6.1.4.1.111.5.1.5.1.1
oraSIDName mandatory
The name of the SID. There is a one-to-one correspondence
between database and SID.
RFC1213-MIBDisplayString
Textual Convention: RFC1213-MIBDisplayString OctetString
 .1.3.6.1.4.1.111.5.1.5.1.2
oraSIDCurrentConnectedClients mandatory
indicates the total number of currently connected clients
thru this SID.
RFC1155-SMIGauge
Textual Convention: RFC1155-SMIGauge Unsigned32
Type Constraints:
range: 0..4294967295
 .1.3.6.1.4.1.111.5.1.5.1.3
oraSIDReservedConnections mandatory
indicates the total number of reserved connections for
clients on this SID.
RFC1155-SMICounter
Textual Convention: RFC1155-SMICounter Unsigned32
Type Constraints:
range: 0..4294967295
 .1.3.6.1.4.1.111.5.1.5.1.4

oraListenAddressTable

table mandatory
.1.3.6.1.4.1.111.5.1.6 · 1 row entry · 2 columns
Open in standard view 
The table of information about the addresses that the listener
is listening at.
oraListenAddressEntry entry .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
oraListenAddressIndex mandatory
A numeric index, unique among all the listen addresses.
Integer32
Textual Convention: COPS-PR-SPPIInteger32 Integer32
Type Constraints:
range: -2147483648..2147483647
 .1.3.6.1.4.1.111.5.1.6.1.1
oraListenAddress mandatory
The addresses to whom the listener is listening at.
RFC1213-MIBDisplayString
Textual Convention: RFC1213-MIBDisplayString OctetString
 .1.3.6.1.4.1.111.5.1.6.1.2