Oracle® Enterprise Manager SNMP Support Reference Guide Release 10.2 Part Number B16244-01 |
|
|
View PDF |
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:
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 |
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
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
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
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
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
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
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