All MIBs › ORADB-MIB › oraDbTablespaceState
oraDbTablespaceState
Module: ORADB-MIB
OID (symbolic): ORADB-MIB::oraDbTablespaceState
OID (numeric): 1.3.6.1.4.1.111.4.1.2.1.5
Node type: OBJECT-TYPE
Type: INTEGER
Access: read-only
Description: The current accessibility of this tablespace. If a tablespace is offline(2), then SQL statements cannot reference objects contained in the tablespace. An invalid(3) tablespace is one that has been dropped.
What is oraDbTablespaceState?
This enumerated value reports whether a tablespace is online(1) and available for use, offline(2) so SQL statements can't reach objects in it, or invalid(3) because it has been dropped. Monitoring tools typically alert immediately if a production tablespace unexpectedly shows offline.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.111.4.1.2.1.5 snmpwalk -v2c -c public <target> ORADB-MIB::oraDbTablespaceState
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.111.4.1.2.1.5.1 snmpget -v2c -c public <target> ORADB-MIB::oraDbTablespaceState.1
SNMPv3 example:
snmpget -v3 -l authPriv -u snmpv3-user -a SHA -A "AuthPassword1" -x AES -X "PrivPassword1" <target> oraDbTablespaceState.1
Start monitoring Oracle database server/RDBMS instance (performance counters) with a free 30-day trial of IPNetwork Monitor. Create custom SNMP monitor using the ORADB-MIB::oraDbTablespaceState OID value, configure state conditions and alerts, and monitor any Oracle database server/RDBMS instance (performance counters) from a single console.
OID Breakdown
Upper-level ancestors (7 from the standard OID tree / other modules)
| Numeric OID | Name | Module |
|---|---|---|
| 1 | iso | LANART-AGENT |
| 1.3 | org | AirPair-MIB |
| 1.3.6 | dod | AirPair-MIB |
| 1.3.6.1 | internet | AirPair-MIB |
| 1.3.6.1.4 | private | AirPair-MIB |
| 1.3.6.1.4.1 | enterprises | AirPair-MIB |
| 1.3.6.1.4.1.111 | oracle | ORACLE-AGENT-MIB |
| Numeric OID | Name | Module |
|---|---|---|
| 1.3.6.1.4.1.111.4 | oraDbMIB | ORADB-MIB |
| 1.3.6.1.4.1.111.4.1 | oraDbObjects | ORADB-MIB |
| 1.3.6.1.4.1.111.4.1.2 | oraDbTablespaceTable | ORADB-MIB |
| 1.3.6.1.4.1.111.4.1.2.1 | oraDbTablespaceEntry | ORADB-MIB |
| 1.3.6.1.4.1.111.4.1.2.1.5 | oraDbTablespaceState | ORADB-MIB |