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 the Oracle server. (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_RW.ORA configuration file, whether or not a current instance of that installed database server is running.

Table E-1 lists the variables of the applTable and indicates which ones have been implemented for the Oracle server.

Table E-1 applTable Variables Implemented for the Oracle Server

Variable Name	Oracle Server
applIndex	x
applName	x
applDirectoryName
applVersion	x
applUptime	x
applOperStatus	x
applLastChange	x
applInboundAssociations	x
applOutboundAssociations
applLastInboundActivity
applLastOutboundActivity

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.

A description of all implemented applTable variables follows.

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
applLastInboundActivity	1.3.6.1.2.1.27.1.1.12
applLastOutboundActivity	1.3.6.1.2.1.27.1.1.13

applIndex

Syntax

INTEGER (0 - 2147483647)

Max-Access

not-accessible

Explanation

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

applIndex is implemented for each of the Oracle server 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 applications.

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

Typical Range

5 - 25 characters

Significance

very important for the Oracle server

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

1 - 1,000

Significance

less important

Related Variables

none

Suggested Presentation

gauge, ala Tach