Oracle SNMP Support Reference Guide

Contents Glossary Index Home Previous Next

rdbmsSrvParamTable

The rdbmsSrvParamTable contains configuration parameters for a database server installed on this managed node. This table roughly corresponds to the oraDbConfigTable of the private Oracle Database MIB, covered in Appendix A. If you are developing an Oracle-specific application, you not need to concern yourself with this table; instead, you should focus your attention on oraDbConfigTable, which has been designed for more convenient use.

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
* Variables marked with an asterisk are not supported. Attempts to access these variables may result in errors.

Table E - 5. rdbmsDbSrvParamTable Variables and Corresponding Object IDs

Oracle is not implementing the following rdbmsSrvParamTable variables:

rdbmsSrvParamName

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

rdbmsSrvParamSubIndex

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

rdbmsSrvParamCurrValue

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

Contents Glossary Index Home Previous Next