Oracle
SNMP Support Reference Guide
Release 8.0.5 A64404-01 |
|
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 three of the Oracle services: the Oracle7
and Oracle8 database servers 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 Oracle7
and Oracle8 database 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 Oracle7 and Oracle8 database servers and Oracle Names).
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.
INTEGER (0 - 2147483647)
not-accessible
An index to uniquely identify the application. This integer
is assigned in the SNMP.ORA file.
applIndex is implemented for each of the Oracle7 and Oracle8 database servers, and Oracle Names services.
0 - 2147483647
very important
applName
DisplayString
read-only
Indicates the name by which the network service application
chooses to be known. applName is implemented for each of the Oracle7 and
Oracle8 database servers, and Oracle Names applications.
For the Oracle7 and Oracle8 database servers, 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.
5 - 25 characters
very important for the Oracle7 and Oracle8 database servers (less important for Oracle Names)
applIndex
DisplayString
read-only
Indicates the version of the application software. The value
is retrieved internally.
applVersion is implemented for each of the Oracle7 and Oracle8 database servers, and Oracle Names applications.
1 - 15 characters
less important
none
TimeStamp
read-only
Indicates the value of sysUptime, a variable the master agent
maintains, which is taken at the time the particular application instance
(Oracle7 or Oracle8 database 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 Oracle7 and Oracle8 database servers.
0..4294967295
very important
none
INTEGER (1) up, and (2), down
read-only
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 Oracle7 and Oracle8 database servers.
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 Oracle7 and Oracle8 database servers, 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).
enumerated 1 or 2
very important
none
TimeStamp
read-only
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 Oracle7 and Oracle8 database servers.
0 - 4294967295
less important
applUpTime, sysUptime
Gauge32
read-only
Indicates the number of current associations to this application,
for which it is the responder. applInboundAssociations is implemented for
the Oracle7 and Oracle8 database servers.
For an Oracle7 or Oracle8 database server configured for dynamic single threaded processes, this value is the number of application instances, as retrieved from SESSIONS_CURRENT in V$LICENSE.
0 - 5 (Oracle Names)1 - 1,000 (Oracle7 and Oracle8 database server)
less important
none
Counter32
read-only
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.
0..4294967295
very important
oraServerDeletesReceived (Oracle Names), oraServerQueriesReceived (Oracle Names), oraServerRenamesReceived (Oracle Names), oraServerUpdatesReceived (Oracle Names)
Counter32
read-only
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.
0..4294967295
important
none
Counter32
read-only
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.
0..4294967295
important
None
rolling counter or gauge/time with warning light
Counter32
read-only
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.
0..4294967295
important
none
rolling counter or gauge/time with warning light