Each entry in the rdbmsSrvParamTable represents a particular configuration parameter for a database server on the node. Each entry is indexed first by applIndex, then by rdbmsSrvParamName, and finally by rdbmsSrvParamSubIndex; thus, there normally is a one-to-many relationship between a database server and its configuration parameters, and a one-to-many relationship between a configuration parameter and its multiple values. (For details about applIndex, see Appendix F, "Interpreting Implemented Variables of the Network Services MIB.") However, in the Oracle implementation, multiple values for a configuration parameter are concatenated into a single entry for that parameter. The current value of each rdbmsSrvInfoTable variable is retrieved directly from a corresponding variable in the INIT.ORA configuration file for this database server.
Entries for a server must be present if the value of the corresponding applOperStatus object is up (1). (See Appendix F for more information on the applOperStatus object.) If an instance of applOperStatus is not up (not 1), then attempts to access corresponding instances in this table may result in either noSuchName (SNMPv1) or noSuchInstance (SNMPv2) being returned by the agent.
Table E - 5 lists each rdbmsSrvParamTable variable that Oracle is implementing, together with its corresponding object ID.
Variable Name | Object ID |
rdbmsSrvParamName | 1.3.6.1.2.1.39.1.7.1.1 |
rdbmsSrvParamSubIndex | 1.3.6.1.2.1.39.1.7.1.2 |
rdbmsSrvParamID* | 1.3.6.1.2.1.39.1.7.1.3 |
rdbmsSrvParamCurrValue | 1.3.6.1.2.1.39.1.7.1.4 |
rdbmsSrvComment* | 1.3.6.1.2.1.39.1.7.1.5 |
Table E - 5. rdbmsDbSrvParamTable Variables and Corresponding Object IDs
Oracle is not implementing the following rdbmsSrvParamTable variables:
Syntax | DisplayString (1..64) |
Max-Access | not-accessible |
Explanation | Displays the name of a configuration parameter for a server. This name is product-specific. The length is limited to 64 characters to minimize traffic of keys and to fit on one line. In the Oracle implementation, the value of this variable is the name of a parameter in the INIT.ORA file. |
Typical Range | 1 - 45 characters |
Significance | less important |
Related Variables | each oraDbConfigTable variable |
Suggested Presentation | simple string |
Syntax | INTEGER (1 - 2147483647) |
Max-Access | not-accessible |
Explanation | The subindex value for this parameter. In this Oracle implementation, the value of this variable is always 1. |
Typical Range | 1 (only) |
Significance | less important |
Related Variables | none |
Suggested Presentation | not applicaable |
Syntax | DisplayString |
Max-Access | read-write |
Explanation | Displays the current value for this configuration parameter, as retrieved from the INIT.ORA file in the Oracle implementation. |
Typical Range | 0 - 255 characters |
Significance | less important |
Related Variables | oraDbConfigTable variables |
Suggested Presentation | simple string |