E
Interpreting Implemented Variables of the Network Services MIB

This appendix provides information to help you interpret those variables of the public Network Services MIB, Version 2 (RFC 1565) that Oracle has implemented. Specifically, it includes a section covering SNMP variables in the following table:

• applTable

applTable

The applTable contains generic variables designed to apply to all types of network service applications. Certain variables of the applTable have been implemented for two of the Oracle services: the Oracle server and Oracle Names. (The Listener does not make use of any Network Services MIB variables.)

Each entry in the applTable represents one of these three applications on the managed node. Each applTable entry for the Oracle server applications represents a database server that has been configured in the SNMP.ORA configuration file, whether or not a current instance of that installed database server is running. In contrast, applTable entries for the Oracle Names applications only represent current instances of those services. If an Oracle Names service is configured in SNMP.ORA, but is not currently running, it would not appear as an entry in the applTable. Each applTable entry is indexed by applIndex.

Table E-1 lists the variables of the applTable and indicates which ones have been implemented for each of the three Oracle services (the Oracle server and Oracle Names).

Table E-1 applTable Variables Implemented for Two Oracle Services

Variable Name	Oracle Server	Oracle Names
applIndex	x	x
applName	x	x
applDirectoryName
applVersion	x	x
applUptime	x
applOperStatus	x
applLastChange	x
applInboundAssociations	x
applOutboundAssociations
applAccumulatedInboundAssociations		x
applAccumulatedOutboundAssociations		x
applLastInboundActivity
applLastOutboundActivity
applRejectedInboundAssociations		x
applFailedOutboundAssociations		x

The only applTable variable that is not implemented for any of these Oracle services is applDirectory, because it only has meaning for sites using OSI directory services.

Table E-2 lists the implemented variables of the applTable and their corresponding object IDs.

Table E-2 applTable Variables and Corresponding Object IDs

Variable Name	Object ID
applIndex	1.3.6.1.2.1.27.1.1.1
applName	1.3.6.1.2.1.27.1.1.2
applDirectoryName	1.3.6.1.2.1.27.1.1.3
applVersion	1.3.6.1.2.1.27.1.1.4
applUptime	1.3.6.1.2.1.27.1.1.5
applOperStatus	1.3.6.1.2.1.27.1.1.6
applLastChange	1.3.6.1.2.1.27.1.1.7
applInboundAssociations	1.3.6.1.2.1.27.1.1.8
applOutboundAssociations	1.3.6.1.2.1.27.1.1.9
applAccumulatedInboundAssociations	1.3.6.1.2.1.27.1.1.10
applAccumulatedOutboundAssociations	1.3.6.1.2.1.27.1.1.11
applLastInboundActivity	1.3.6.1.2.1.27.1.1.12
applLastOutboundActivity	1.3.6.1.2.1.27.1.1.13
applRejectedInboundAssociations	1.3.6.1.2.1.27.1.1.14
applFailedOutboundAssociations	1.3.6.1.2.1.27.1.1.15

A description of all implemented applTable variables follows.

applIndex

Syntax

INTEGER (0 - 2147483647)

Max-Access

not-accessible

Explanation

An index to uniquely identify the application. This integer is assigned in the SNMP.ORA file.

applIndex is implemented for each of the Oracle server, and Oracle Names services.

Typical Range

0 - 2147483647

Significance

very important

Related Variables

applName

Suggested Presentation

not applicable

applName

Syntax

DisplayString

Max-Access

read-only

Explanation

Indicates the name by which the network service application chooses to be known. applName is implemented for the Oracle server, and Oracle Names applications.

For the Oracle server, the value of applName is the value of the SID parameter in the SNMP.ORA configuration file.

For the Oracle Names service, the value of applName is retrieved from the NAMES.SERVER_NAME field of the NAMES.ORA file. All Oracle Names tables use appleName as an index.

Typical Range

5 - 25 characters

Significance

very important for the Oracle server (less important for Oracle Names)

Related Variables

applIndex

Suggested Presentation

simple string

applVersion

Syntax

DisplayString

Max-Access

read-only

Explanation

Indicates the version of the application software. The value is retrieved internally.

applVersion is implemented for each of the Oracle server, and Oracle Names applications.

Typical Range

1 - 15 characters

Significance

less important

Related Variables

none

Suggested Presentation

simple string

applUptime

Syntax

TimeStamp

Max-Access

read-only

Explanation

Indicates the value of sysUptime, a variable the master agent maintains, which is taken at the time the particular application instance (Oracle server) was last initialized.

If two requests for this variable return the same value, none of the counters associated with this application have been reset between the requests.

applUptime is implemented for the Oracle server.

Typical Range

0..4294967295

Significance

very important

Related Variables

none

Suggested Presentation

gauge or counter

applOperStatus

Syntax

INTEGER (1) up, and (2), down

Max-Access

read-only

Explanation

Indicates the operational status of the application. Oracle is implementing (1) up and (2) down. The UP value (1) indicates that the application is operational and available. The DOWN value (2) indicates that the application is not available. appleOperStatus is implemented for the Oracle server.

If the value of the applOperStatus variable for this application is 2, indicating that it is not available, then the subagent cannot connect to it. In this case, only those MIB table(s) that exist independently of the operational status of that application will be SNMP-accessible. For the Oracle server, these tables are the rdbmsDbTable and rdbmsSrvTable of the public RDBMS MIB only. All tables of the private Oracle Database MIB would be inaccessible when the value of applOperStatus is 2 (down).

Typical Range

enumerated 1 or 2

Significance

very important

Related Variables

none

Suggested Presentation

alarm or simple string

applLastChange

Syntax

TimeStamp

Max-Access

read-only

Explanation

Indicates the value of sysUptime at the time the network service application entered its current operational state. sysUptime is maintained by the master agent on this managed node. If the current state was entered prior to the last initialization of the local network management subsystem, then this object contains a value of 0.

applLastChange is implemented for the Oracle server.

Typical Range

0 - 4294967295

Significance

less important

Related Variables

applUpTime, sysUptime

Suggested Presentation

simple string

applInboundAssociations

Syntax

Gauge32

Max-Access

read-only

Explanation

Indicates the number of current associations to this application, for which it is the responder. applInboundAssociations is implemented for the Oracle server.

For an Oracle server configured for dynamic single threaded processes, this value is the number of application instances, as retrieved from SESSIONS_CURRENT in V$LICENSE.

Typical Range

0 - 5 (Oracle Names)1 - 1,000 (Oracle server)

Significance

less important

Related Variables

none

Suggested Presentation

gauge, ala Tach (Names

applAccumulatedInboundAssociations

Syntax

Counter32

Max-Access

read-only

Explanation

Indicates the total number of associations to this application for which it is the responder, since its initialization. This variable represents the overall request load. This variable is implemented for the Oracle Names services.

For the Oracle Names service, this value is derived from an internal table.

Typical Range

0..4294967295

Significance

very important

Related Variables

oraServerDeletesReceived (Oracle Names), oraServerQueriesReceived (Oracle Names), oraServerRenamesReceived (Oracle Names), oraServerUpdatesReceived (Oracle Names)

Suggested Presentation

rolling counter or gauge

applAccumulatedOutboundAssociations

Syntax

Counter32

Max-Access

read-only

Explanation

Indicates the forwarding load (the total number of associations to this application for which it is the initiator, since its initialization). This variable is implemented for the Oracle Names services.

For the Oracle Names service, this value is derived from an internal table.

Typical Range

0..4294967295

Significance

important

Related Variables

none

Suggested Presentation

counter

applRejectedInboundAssociations

Syntax

Counter32

Max-Access

read-only

Explanation

Indicates the total number of inbound associations the application entity has rejected, since application initialization. The variable is implemented for the Oracle Names services.

For Oracle Names, this value indicates client malfunction, or a possible inconsistency in configuration. It is retrieved from an internal table.

Typical Range

0..4294967295

Significance

important

Related Variables

None

oSuggested Presentation

rolling counter or gauge/time with warning light

applFailedOutboundAssociations

Syntax

Counter32

Max-Access

read-only

Explanation

Indicates the total number of associations since application initialization, for which the application entity is initiator and association establishment has failed. This variable is implemented for the Oracle Names services.

For Oracle Names, this variable indicates that remote servers are either down or not defined properly in this server's topology data. It is retrieved from an internal table.

Typical Range

0..4294967295

Significance

important

Related Variables

none

Suggested Presentation

rolling counter or gauge/time with warning light