Oracle SNMP Support Reference Guide Release 8.1.7 Part Number A85249-01 |
Library | Service | Contents | Index

# D
Interpreting Variables of the Public RDBMS MIB

This appendix provides information to help you interpret individual variables in the Oracle implementation of the public RDBMS MIB. Note that this appendix emphasizes Oracle's implementation. For information concerning other implementation alternatives for these variables, refer to MIB itself.

This appendix includes sections covering public RDBMS MIB variables that Oracle implements in the following tables

- rdbmsDbTable

- rdbmsDbInfoTable

- rdbmsSrvTable

- rdbmsSrvInfoTable

- rdbmsSrvParamTable

- rdbmsRelTable

- rdbmsTraps

Note that Oracle does not implement the following tables of the public RDBMS MIB:

- rdbmsDbParamTable

- rdbmsDbLimitedResourceTable

- rdbmsSrvLimitedResourceTable

Attempts to access any of the variables that Oracle is not implementing results in noSuchName (SNMPv1) or noSuchInstance (SNMPv2) being returned.

## rdbmsDbTable

The rdbmsDbTable contains general information on each database installed on the managed node. 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 rdbmsDbTable represents a given database installed on the node. Each entry is indexed by rdbmsDbIndex. The current values of the rdbmsDbTable variables are retrieved from a variety of sources on the managed node.

Oracle implements all rdbmsDbTable variables; Table D-1lists each of them, together with its corresponding object ID.

##### Table D-1 rdbmsDbTable Variables and Corresponding Object IDs

Variable Name | Object ID
--- | ---
rdbmsDbIndex | 1.3.6.1.2.1.39.1.1.1.1
rdbmsDbPrivateMIBOID | 1.3.6.1.2.1.39.1.1.1.2
rdbmsDbVendorName | 1.3.6.1.2.1.39.1.1.1.3
rdbmsDbName | 1.3.6.1.2.1.39.1.1.1.4
rdbmsDbContact | 1.3.6.1.2.1.39.1.1.1.5

### rdbmsDbIndex

Syntax

INTEGER (1 - 2147483647)

Max-Access

not-accessible

Explanation

A numeric index, unique among all of the vendors' databases installed on this managed node. This value is a surrogate for the conceptually unique key, which is {vendorOID, databasename }. In the Oracle implementation, the value of this variable when not running the Oracle Parallel Server is the value of rdbmsSrvIndex for this installed database server.

Typical Range

1 - 10

Significance

very important

Related Variables

rdbmsSrvIndex

Suggested Presentation

not applicable

### rdbmsDbPrivateMIBOID

Syntax

OBJECT IDENTIFIER

Max-Access

read-only

Explanation

Displays the authoritative identification for the private MIB of this installed database. In the Oracle implementation, the value of rdbmsDbVendorOID is hardcoded as the root of Oracle's OID subtree (1.3.6.1.4.1.111).

Typical Range

1.3.6.1.4.1.111 (only)

Significance

very important

Related Variables

rdbmsSrvVendorOID

Suggested Presentation

simple string

### rdbmsDbVendorName

Syntax

DisplayString

Max-Access

read-only

Explanation

Displays the name of the vendor whose RDBMS manages this installed database, for informational purposes. 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

rdbmsSrvVendorName

Suggested Presentation

icon or simple string

### rdbmsDbName

Syntax

DisplayString

Max-Access

read-only

Explanation

Displays the name of this installed database, in product-specific format. In the Oracle implementation, the value of rdbmsDbName is retrieved from the DB__NAME variable in SNMP.ORA. This name is globally unique and includes domain information.

Typical Range

5 - 25 characters

Significance

important

Related Variables

rdbmsSrvName

Suggested Presentation

icon or simple string

### rdbmsDbContact

Syntax

DisplayString

Max-Access

read-write

Explanation

Displays the name of the contact person for this installed database, 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

2 - 255 characters

Significance

important

Related Variables

rdbmsSrvContact

Suggested Presentation

simple string

## rdbmsDbInfoTable

The rdbmsDbInfoTable contains additional general information about actively opened database instances on the managed node. If an installed database has been configured for SNMP support but is not actively opened, then attempts to access corresponding instances in this table may result in either noSuchName (SNMPv1), or noSuchInstance (SNMPv2). "Actively opened" is determined by the values of all the rdbmsRelState entries for this database in the rdbmsRelTable.

Each entry in the rdbmsDbInfoTable represents a particular actively opened database instance on the node. Each entry is indexed by rdbmsDbIndex. However, because rdbmsDbTable contains an entry for each database installed on that node, whether or not it is actively open, there may or may not be a one-to-one correspondence between entries in the two tables at any point in time. The current value of the rdbmsDbInfoTable variable are retrieved from a variety of sources on the managed node.

Table D-2 lists each rdbmsDbInfoTable variable that Oracle is implementing, together with its corresponding object ID.

##### Table D-2 rdbmsDbInfoTable Variables and Corresponding Object IDs

Variable Name | Object ID
--- | ---
rdbmsDbInfoProductName | 1.3.6.1.2.1.39.1.2.1.1
rdbmsDbInfoVersion | 1.3.6.1.2.1.39.1.2.1.2
rdbmsDbInfoSizeUnits | 1.3.6.1.2.1.39.1.2.1.3
rdbmsDbInfoSizeAllocated | 1.3.6.1.2.1.39.1.2.1.4
rdbmsDbInfoSizeUsed | 1.3.6.1.2.1.39.1.2.1.5
rdbmsDbInfoLastBackup* | 1.3.6.1.2.1.39.1.2.1.6

* Variables marked with an asterisk are not supported.
Attempts to access these variables may result in errors.

Note that Oracle is not implementing rdbmsDbInfoLastBackup because Oracle allows individual tablespaces to be backed up; thus, the time of the last full database backup is not meaningful.

### rdbmsDbInfoProductName

Syntax

DisplayString

Max-Access

read-only

Explanation

Displays the textual product name of the server that created or last restructured this database instance. In the Oracle implementation, the value of this variable is retrieved from the BANNER field in V$VERSION.

Typical Range

253 characters

Significance

important

Related Variables

rdbmsSrvProductName

Suggested Presentation

icon or simple string

### rdbmsDbInfoVersion

Syntax

DisplayString

Max-Access

read-only

Explanation

Displays the version number of the server that created or last restructured this database instance. The format is specific to the product. In the Oracle implementation, the value of this variable is derived internally.

Typical Range

not applicable

Significance

important (depending on the application)

Related Variables

applVersion

Suggested Presentation

simple string

### rdbmsDbInfoSizeUnits

Syntax

INTEGER (1) bytes, (2) kbytes, (3) mbytes, (4) gbytes, or (5) tbytes.

Max-Access

read-write

Explanation

Displays the units used to measure the size of this database instance, as indicated by the values for rdbmsDbInfoSizeAllocated and rdbmsDbInfoSizeUsed. In the Oracle implementation, the value of rdbmsDbInfoSizeUnits is the least that allows rdbmsDbInfoSizeAllocated to be expressed as a 32-bit integer.

(1) bytes, indicates size measured in bytes; (2) kbytes, indicates units of kilobytes; (3) mbytes, indicates units of megabytes; (4) gbytes, indicates units of gigabytes; or (5) tbytes, indicates units of terabytes. Each of these unit measurements are binary multiples (1K = 1024).

Typical Range

enumerated 1 - 5

Significance

very important

Related Variables

rdbmsDbInfoSizeAllocated, rdbmsDbInfoSizeUsed

Suggested Presentation

simple string

### rdbmsDbInfoSizeAllocated

Syntax

INTEGER (1 - 2147483647)

Max-Access

read-write

Explanation

Displays the estimated size of this database instance (in rdbmsDbInfoSizeUnits), which is the disk space that has been allocated to it and is no longer available to users on this host. The rdbmsDbInfoSizeAllocated variable does not necessarily indicate the amount of space actually in use for database data; rdbmsDbInfoSizeUsed retrieves this value instead. In the Oracle implementation, the value of this variable is the sum of the BYTES field for the rows of the DBA_DATA_FILES tables.

Typical Range

1 - 2147483647

Significance

very important

Related Variables

rdbmsDbInfoSizeUnits, rdbmsDbInfoSizeUsed

Suggested Presentation

simple string or gauge

### rdbmsDbInfoSizeUsed

Syntax

INTEGER (1 - 2147483647)

Max-Access

read-only

Explanation

Displays the estimated size of this database instance (in rdbmsDbInfoSizeUnits), actually in use for database data. In the Oracle implementation, the value of rdbmsDbInfoSizeUsed is the sum of values in the BYTES field of DBA_DATA_FILES minus the sum of values in the BYTES field of DBA_FREE_SPACE. rdbmsDbInfoSizeUsed should always be less than or equal to rdbmsDbInfoSizeAllocated.

Typical Range

1 - 2147483647

Significance

very important

Related Variables

rdbmsDbInfoSizeAllocated, rdbmsDbInfoSizeUnits

Suggested Presentation

gauge

## rdbmsSrvTable

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 D-3 lists each of them, together with its corresponding object ID.

##### Table D-3 rdbmsDbSrvTable Variables and Corresponding Object IDs

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

### rdbmsSrvPrivateMIBOID

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

### rdbmsSrvVendorName

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

### rdbmsSrvProductName

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

### rdbmsSrvContact

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

## rdbmsSrvInfoTable

The rdbmsSrvInfoTable contains additional information about each database server instance actively running on the managed node. The visibility of a database server instance in rdbmsSrvInfoTable is determined by the value of the corresponding applOperStatus object for that database server. (For details about applOperStatus, see Appendix E, "Interpreting Implemented Variables of the Network Services MIB.") Monitoring these variables is important for tuning server functions such as I/O, access and activity.

Each entry in the rdbmsDbSrvInfoTable represents a given actively opened database server instance on the node. Each entry is indexed by applIndex. The current value of each rdbmsSrvInfoTable variable is retrieved directly from various V$ dynamic performance tables of this database server instance.

Table D-4 lists each of the rdbmsDbInfoTable variables that Oracle is implementing, together with its corresponding object ID.

##### Table D-4 rdbmsDbSrvInfoTable Variables and Corresponding Object IDs

Variable Name | Object ID
--- | ---
rdbmsSrvInfoStartupTime | 1.3.6.1.2.1.39.1.6.1.1
rdbmsSrvInfoFinishedTransactions | 1.3.6.1.2.1.39.1.6.1.2
rdbmsSrvInfoDiskReads | 1.3.6.1.2.1.39.1.6.1.3
rdbmsSrvInfoLogicalReads | 1.3.6.1.2.1.39.1.6.1.4
rdbmsSrvInfoDiskWrites | 1.3.6.1.2.1.39.1.6.1.5
rdbmsSrvInfoLogicalWrites | 1.3.6.1.2.1.39.1.6.1.6
rdbmsSrvInfoPageReads | 1.3.6.1.2.1.39.1.6.1.7
rdbmsSrvInfoPageWrites | 1.3.6.1.2.1.39.1.6.1.8
rdbmsSrvInfoDiskOutOfSpaces* | 1.3.6.1.2.1.39.1.6.1.9
rdbmsSrvInfoRequestsHandled | 1.3.6.1.2.1.39.1.6.1.10
rdbmsSrvInfoRequestsRecvs* | 1.3.6.1.2.1.39.1.6.1.11
rdbmsSrvInfoRequestSends* | 1.3.6.1.2.1.39.1.6.1.12
rdbmsSrvInfoHighwaterIn-boundAssociations | 1.3.6.1.2.1.39.1.6.1.13
rdbmsSrvInfoMaxInboundAssociations | 1.3.6.1.2.1.39.1.6.1.14

* Variables marked with an asterisk are not supported.
Attempts to access these variables may result in errors.

Oracle is not implementing the following rdbmsDbInfoTable variables:

- rdbmsSrvInfoDiskOutOfSpaces

- rdbmsSrvInfoRequestRecvs

- rdbmsSrvInfoRequestSends

### rdbmsSrvInfoStartupTime

Syntax

DateAndTime

Max-Access

read-only

Explanation

Displays the date and time at which this server was last started. In the Oracle implementation, the value of this variable is computed from the STARTUP TIME-JULIAN and STARTUP TIME-SECONDS fields in V$INSTANCE.

Typical Range

not applicable

Significance

important

Related Variables

applUpTime

Suggested Presentation

simple string

### rdbmsSrvInfoFinishedTransactions

Syntax

Gauge32

Max-Access

read-only

Explanation

Displays the number of transactions (visible to this server) upon which either COMMIT or ABORT operations have been completed since startup of this database server instance. Some database operations, such as read-only queries, may not result in the creation of a transaction. In the Oracle implementation, the value of this variable is the sum of USER ROLLBACKS and USER COMMITS from V$SYSSTAT.

Typical Range

0 - 4294967295

Significance

very important

Related Variables

none

Suggested Presentation

counter

### rdbmsSrvInfoDiskReads

Syntax

Counter32

Max-Access

read-only

Explanation

Displays the total number of reads of database files this server has issued to the operating system since startup of this database server instance. In the Oracle implementation, the value of this variable is retrieved from PHYSICAL READS in V$SYSSTAT.

Typical Range

0 - 4294967295

Significance

very important

Related Variables

rdbmsSrvInfoLogicalReads, rdbmsSrvInfoPageReads

Suggested Presentation

counter

### rdbmsSrvInfoLogicalReads

Syntax

Counter32

Max-Access

read-only

Explanation

Displays the total number of logical reads of database files that this server has made internally since startup. This value and the value of rdbmsSrvInfoDiskReads reveal the effect of caching on read operations. In the Oracle implementation, the value of this variable is the sum of CONSISTENT GETS and DB BLOCK GETS in V$SYSSTAT.

Typical Range

0 - 4294967295

Significance

very important

Related Variables

rdbmsSrvInfoDiskReads

Suggested Presentation

counter

### rdbmsSrvInfoDiskWrites

Syntax

Counter32

Max-Access

read-only

Explanation

Displays the total number of writes to database files this server has issued to the operating system since startup. In the Oracle implementation, the value of this variable is retrieved from PHYSICAL WRITES in V$SYSSTAT.

Typical Range

0 - 4294967295

Significance

very important

Related Variables

rdbmsSrvInfoPageWrites, rdbmsSrvInfoLogicalWrites

Suggested Presentation

counter

### rdbmsSrvInfoLogicalWrites

Syntax

Counter32

Max-Access

read-only

Explanation

The total number of times parts of the database files have been marked "dirty" and in need of writing to the disk. This value and rdbmsSrvInfoDiskWrites give some indication of the effect of "write-behind" strategies in reducing the number of disk writes compared to database operations. Because the writes may be done by servers other than those marking the parts of the database files dirty, these values may only be meaningful when aggregated across all servers sharing a common cache. Numbers are not comparable between products. In the Oracle implementation, the value of this variable is retrieved from DB BLOCK CHANGES in V$SYSSTAT.

Typical Range

0..4294967295

Significance

very important

Related Variables

rdbmsSrvInfoDiskWrites

Suggested Presentation

counter32

### rdbmsSrvInfoPageReads

Syntax

Counter32

Max-Access

read-only

Explanation

Displays the total number of pages in database files this server has read since startup of this database server instance. "Pages" are product-specific units of disk I/O operations. This value, together with the value of rdbmsSrvInfoDisksReads, reveals the effect of any grouping read-ahead that may be used to enhance performance of some queries, such as scans. In the Oracle implementation, the value of this variable is the sum of all PHYBLKRD entries in V$FILESTAT.

Typical Range

0 - 4294967295

Significance

very important

Related Variables

rdbmsSrvInfoDiskReads

Suggested Presentation

counter

### rdbmsSrvInfoPageWrites

Syntax

Counter32

Max-Access

read-only

Explanation

Displays the total number of pages in database files this server has written since this startup of this database server instance. Pages are product-specific units of disk I/O. This value, together with the value of rdbmsSrvInfoDiskWrites, shows the effect of write strategies that collapse logical writes of continuous pages into single calls to the operating system. In the Oracle implementation, the value of this variable is the sum of all PHYBLKWRT entries in V$FILESTAT.

Typical Range

0 - 4294967295

Significance

very important

Related Variables

rdbmsSrvInfoDiskWrites

Suggested Presentation

counter

### rdbmsSrvInfoRequestsHandled

Syntax

Counter32

Max-Access

read-only

Explanation

Displays the total number of requests made to the server on inbound associations since this startup of this database server instance.

rdbmsSrvInfoRequestsHandled is intended to encapsulate high level semantic operations between clients and servers, or between peers. For example, one request might correspond to a SELECT or an INSERT statement. In contrast to rdbmsSrvInfoDiskReads or rdbmsSrvInfoDiskWrites, this variable is not intended to capture disk I/O operations.

In the Oracle implementation, the value of this variable is retrieved from "user calls" in V$SYSSTAT.

Typical Range

0 - 4294967295

Significance

very important

Related Variables

rdbmsSrvInfoRequestRecvs, rdbmsSrvInfoRequestSends

Suggested Presentation

counter

### rdbmsSrvInfoHighwaterInboundAssociations

Syntax

Gauge32

Max-Access

read-only

Explanation

Displays the greatest number of inbound associations that have been simultaneously open to this server since this startup of this database server instance. In the Oracle implementation, the value of this variable is retrieved from SESSION_HIGHWATER in V$LICENSE.

Typical Range

0 - value of rdbmsSrvInfoMaxInboundAssociations

Significance

important

Related Variables

rdbmsSrvInfoMaxInboundAssociations

Suggested Presentation

gauge

### rdbmsSrvInfoMaxInboundAssociations

Syntax

INTEGER (1..2147483647)

Max-Access

read-write

Explanation

Displays the greatest number of inbound associations that can be simultaneously open with this server. If there is no limit, then the value should be zero. In the Oracle implementation, the value of this variable is retrieved from SESSIONS_MAX in V$LICENSE.

Typical Range

1 - 2147483647

Significance

important

Related Variables

applInboundAssociations, rdbmsSrvInfoHighwaterInboundAssociations

Suggested Presentation

simple string

## 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 E, "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 E 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 D-5 lists each rdbmsSrvParamTable variable that Oracle is implementing, together with its corresponding object ID.

##### Table D-5 rdbmsDbSrvParamTable Variables and Corresponding Object IDs

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.

Oracle is not implementing the following rdbmsSrvParamTable variables:

- rdbmsSrvParamComment

- rdbmsSrvParamID

### 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 applicable

### 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

## rdbmsRelTable

The rdbmsRelTable indicates how databases and servers on this managed node are related. In the standard Oracle implementation, one server supports one database; nevertheless, this table has been implemented in order to fully adhere to the public RDBMS MIB standard.

Each entry in the rdbmsDbRelTable represents a mapping between a database server and a database on the node. Each entry is indexed first by rdbmsDbIndex, and then by applIndex; thus, for the standard Oracle configuration of one server per database, these two indices are the same. (For details on applIndex, see Appendix E, "Interpreting Implemented Variables of the Network Services MIB.)

Table D-6 lists the rdbmsRelTable variable that Oracle is implementing, together with its corresponding object ID.

##### Table D-6 rdbmsRelTable Variables and Corresponding Object IDs

Variable Name | Object ID
--- | ---
rdbmsRelState | 1.3.6.1.2.1.39.1.9.1.1
rdbmsRelActiveTime | 1.3.6.1.2.1.39.1.9.1.2

### rdbmsRelState

Syntax

INTEGER (2) active or (5) unavailable.

Max-Access

read-write

Explanation

Displays the state of this server's access to this database. Oracle implements (2) active and unavailable (5) only. Active (2) means the server is actively using the database. Unavailable (5) means the database is not available through this server.

Typical Range

2 or 5

Significance

very important

Related Variables

appleOperStatus, rdbmsStateChange

Suggested Presentation

icon or alarm

## rdbmsTraps

Unlike other SNMP variables, a trap variable is not an agent's response to a management station's request for information. Rather, it is a message that an agent can send unsolicited to a management station when that agent notices that some condition has occured (a threshold has been reached, for example).

Table D-7 lists each rdbmsTraps variable and its corresponding object ID.

##### Table D-7 rdbmsTraps Variables and Corresponding Object IDs

Variable Name | Object ID
--- | ---
rdbmsStateChange | 1.3.6.1.2.39.2.1.1.1

### rdbmsStateChange

Objects

{rdbmsRelState }

Explanation

An rdbmsStateChange trap signifies that one of the database servers this on this node has changed its rdbmsRelState in a way that makes it less accessible for use. In the Oracle implementation, active (2) is considered fully accessible. The state sent with the trap is the new, less accessible state ((5) unavailable).

Typical Range

5 (only)

Significance

very important

Related Variables

rdbmsRelState

Suggested Presentation

alarm

| Copyright © 1996-2000, Oracle Corporation. All Rights Reserved. |
Library | Service | Contents | Index