Each entry in the applTable represents one of these three applications on the managed node. Each applTable entry for the Oracle7 database server application 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 Multiprotocol Interchange and Oracle Names applications only represent current instances of those services. If an Oracle Multiprotocol Interchange or 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 F - 1 lists the variables of the applTable and indicates which ones have been implemented for each of the three Oracle services (the Oracle7 database server, the Oracle Multiprotocol Interchange and Oracle Names).
| Variable Name | Oracle7 Server | Oracle Multiprotocol Interchange | Oracle Names |
| applIndex | x | x | x |
| applName | x | x | x |
| applDirectoryName | |||
| applVersion | x | x | x |
| applUptime | x | x | |
| applOperStatus | x | x | |
| applLastChange | x | x | |
| applInboundAssociations | x | x | |
| applOutboundAssociations | x | ||
| applAccumulatedInboundAssociations | x | x | |
| applAccumulatedOutboundAssociations | x | x | |
| applLastInboundActivity | x | ||
| applLastOutboundActivity | x | ||
| applRejectedInboundAssociations | x | x | |
| applFailedOutboundAssociations | x | x | |
The only applTable variable that is not implemented for any of these three Oracle services is applDirectory, because it only has meaning for sites using OSI directory services.
Table F - 2 lists the implemented variables of the applTable and their 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.
| 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 Oracle7 database server, Oracle Multiprotocol Interchange and Oracle Names 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 each of the Oracle7 database server, Oracle Multiprotocol Interchange and Oracle Names applications. |
| For the Oracle7 database server, the value of applName is the value of the SID parameter in the SNMP.ORA configuration file. | |
| For the Oracle Multiprotocol Interchange, the value of applName is retrieved from the CMANAGER_NAME parameter of the INTCHG.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 Oracle7 server database and the Oracle Multiprotocol Interchange (less important for Oracle Names) |
| 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 Oracle7 database server, Oracle Multiprotocol Interchange and Oracle Names 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 (Oracle7 database server or Oracle Multiprotocol Interchange) 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 database server and Oracle Multiprotocol Interchange applications. | |
| 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 Oracle7 database server and Oracle Multiprotocol Interchange applications. |
| 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 database server, these tables are the rdbmsDbTable and rdbmsSrvTable of the public RDBMS MIB only. All tables of the private Oracle Database MIB and the Oracle Multiprotocol Interchange services 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 Oracle7 database server and the Oracle Multiprotocol Interchange applications. | |
| 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 Oracle7 database server and Oracle Multiprotocol Interchange services. |
| For an Oracle7 database server configured for dynamic single threaded processes, this value is the number of application instances, as retrieved from SESSIONS_CURRENT in V$LICENSE. | |
| For the Oracle Multiprotocol Interchange, any connection functions as both an inbound and outbound association. Thus, this value corresponds to the value for oraCmanagerCurrentConnectionsInUse, which is the total of all active connections for all of the pumps. | |
| Typical Range | 0 - 5 (Oracle Multiprotocol Interchange, Oracle Names)1 - 1,000 (Oracle7 database server) |
| Significance | less important |
| Related Variables | none |
| Suggested Presentation | gauge, ala Tach (Names |
| Syntax | Gauge32 |
| Max-Access | read-only |
| Explanation | Indicates the number of current associations to this application, for which it is the initiator. This variable is implemented for the Oracle Multiprotocol Interchange application. |
| For the Oracle Multiprotocol Interchange, any connection functions as both an inbound and outbound association. Thus, this value corresponds to the value for oraCmanagerCurrentConnectionsInUse, which is the total of all active connections for all of the pumps. | |
| Typical Range | 0 - 5 |
| Significance | less important |
| Related Variables | onrsServerRequestsForwarded |
| Suggested Presentation | gauge, ala Tach |
| 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 Multiprotocol Interchange and Oracle Names services. |
| For the Oracle Multiprotocol Interchange, any connection functions as both an inbound and outbound association. Thus, this value is the sum of the values of oraCmanagerAccumulatedSuccessfulConnections and oraCmanagerAccumulatedFailedConnections, which is the total of all failed and successful connections for all of the pumps since startup of this Oracle Multiprotocol Interchange instance. | |
| For the Oracle Names service, this value is derived from an internal table. | |
| Typical Range | 0..4294967295 |
| Significance | very important |
| Related Variables | appleAccumulatedOutboundAssociations (Oracle Multiprotocol Interchange), oraServerDeletesReceived (Oracle Names), oraServerQueriesReceived (Oracle Names), oraServerRenamesReceived (Oracle Names), oraServerUpdatesReceived (Oracle Names) |
| Suggested Presentation | rolling counter or gauge |
| 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 Multiprotocol Interchange and Oracle Names services. |
| For the Oracle Multiprotocol Interchange, any connection functions as both an inbound and outbound association. Thus, this value is the sum of the values of oraCmanagerAccumulatedSuccessfulConnections and oraCmanagerAccumulatedFailedConnections, which is the total of all failed and successful connections for all of the pumps since startup of this Oracle Multiprotocol Interchange instance. | |
| For the Oracle Names service, this value is derived from an internal table. | |
| Typical Range | 0..4294967295 |
| Significance | important |
| Related Variables | appleAccumulatedInboundAssociations (Oracle Multiprotocol Interchange) |
| Suggested Presentation | counter |
| Syntax | TimeStamp |
| Max-Access | read-only |
| Explanation | Indicates the value of sysUptime at the time of the last inbound association for this application. sysUptime is maintained by the master agent on this managed node. If the last association occurred prior to the last initialization of the network subsystem, then this object contains a value of zero. This variable is implemented for the Oracle Multiprotocol Interchange service. |
| For the Oracle Multiprotocol Interchange, any connection functions as both an inbound and outbound association. Thus, this value corresponds directly to that for appleLastOutboundActivity in the Oracle Multiprotocol Interchange's case. This value is calculated from the time stamp of the most recent Interchange connection, the timestamp for the most recent initialization of the Oracle Multiprotocol Interchange, and the value of applLastChange. | |
| Typical Range | 0..4294967295 |
| Significance | important |
| Related Variables | appleLastOutboundActivity |
| Suggested Presentation | simple string or notch on a timeline. |
| Syntax | TimeStamp |
| Max-Access | read-only |
| Explanation | Indicates the value of sysUptime at the time of the last outbound association for this application. sysUptime is maintained by the master agent on this managed node. If the last association occurred before the last initialization of the network subsystem, then this object contains a value of 0. This variable is implemented for the Oracle Multiprotocol Interchange service only. |
| For the Oracle Multiprotocol Interchange, any connection functions as both an inbound and outbound association. Thus, this value corresponds directly to that for appleLastOutboundActivity in the Oracle Multiprotocol Interchange's case. This value is calculated from the time stamp of the most recent Oracle Multiprotocol Interchange connection, the timestamp for the most recent initialization of the Interchange, and the value of applLastChange. | |
| Typical Range | 0..4294967295 |
| Significance | important |
| Related Variables | applLastInboundActivity |
| Suggested Presentation | simple string or notch on a time-line |
| 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 Multiprotocol Interchange and Oracle Names services. |
| For the Oracle Multiprotocol Interchange, any connection functions as both an inbound and outbound association. Thus, this value corresponds to the value for oraCmanagerAccumulatedFailedConnections, which is the total of all failed connections for all of the pumps since the last Oracle Multiprotocol Interchange instance startup. | |
| 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 | oraCmanagerAccumulatedFailedConnections (Oracle Multiprotocol Interchange) |
| Suggested Presentation | rolling counter or gauge/time with warning light |
| 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 Multiprotocol Interchange and Oracle Names services. |
| For the Oracle Multiprotocol Interchange, any connection functions as both an inbound and outbound association. Thus, this value corresponds to the value for oraCmanagerAccumulatedFailedConnections, which is the total of all failed connections for all of the pumps since the last Interchange instance startup. | |
| 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 | oraCmanagerAccumulatedFailedConnections (Oracle Multiprotocol Interchange) |
| Suggested Presentation | rolling counter or gauge/time with warning light |