Oracle SNMP Support Reference Guide
The rdbmsSrvTable contains generic information on each database server installed on the managed node. In the standard Oracle configuration, one server supports one database. Thus, while the content of rdbmsSrvTable essentially mirrors the content of rdbmsDbTable, Oracle has chosen to implement both tables in order to fully adhere to one of the central precepts of the public RDBMS MIB standard. This precept is that a distinction between the database and its server must be made, in order to account for other vendors' architectures.
Any installed database that has been configured for SNMP support, whether or not it is actively opened, is represented by a row in the rdbmsDbTable. Each entry in the rdbmsSrvTable represents a given database server on the node. Each entry is indexed by applIndex. The current value of each rdbmsSrvTable variable is retrieved directly from a variety of sources on the managed node.
Oracle implements all rdbmsSrvTable variables. Table E - 3 lists each of them, together with its corresponding object ID.
| Variable Name
| Object ID
|
| rdbmsSrvPrivateMIBOID
| 1.3.6.1.2.1.39.1.5.1.1
|
| rdbmsSrvVendorName
| 1.3.6.1.2.1.39.1.5.1.2
|
| rdbmsSrvProductName
| 1.3.6.1.2.1.39.1.5.1.3
|
| rdbmsSrvContact
| 1.3.6.1.2.1.39.1.5.1.4
|
Table E - 3. rdbmsDbSrvTable Variables and Corresponding Object IDs
| Syntax | OBJECT IDENTIFIER |
| Max-Access | read-only |
| Explanation | Displays the authoritative identification for the private MIB for this server. In the Oracle implementation, the value of this variable is hardcoded as the root of Oracle's OID subtree (1.3.6.1.4.1.111). If no OBJECT IDENTIFIER exists for the private MIB, attempts to access this object will return noSuchName (SNMPv1) or noSuchInstance (SNMPv2). |
| Typical Range | 1.3.6.1.4.1.111 (only)
|
| Significance | very important |
| Related Variables | rdbmsDbVendorOID
|
| Suggested Presentation | simple string
|
| Syntax | DisplayString |
| Max-Access | read-only |
| Explanation | Displays the name of the vendor of this installed database server. In the Oracle implementation, the value of this variable is hardcoded in the subagent as "Oracle". |
| Typical Range | 6 characters (only)
|
| Significance | important |
| Related Variables | rdbmsDbVendorName
|
| Suggested Presentation | icon or simple string
|
| Syntax | DisplayString |
| Max-Access | read-only |
| Explanation | Displays the product name of this server. In the Oracle implementation, the value of this variable is hardcoded as "Oracle7 server." |
| Typical Range | 14 characters (only)
|
| Significance | important |
| Related Variables | rdbmsDbInfoProductName
|
| Suggested Presentation | icon or simple string
|
| Syntax | DisplayString |
| Max-Access | read-write |
| Explanation | Displays the textual identification of the contact person for this managed server, together with information indicating how to contact this person. In the Oracle implementation, the value of this variable is retrieved from the SNMP.ORA configuration file. |
| Typical Range | 0 - 255 characters
|
| Significance | important |
| Related Variables | rdbmsDbContact
|
| Suggested Presentation | simple string
|