Oracle SNMP Support Reference Guide -- Contents

Benefits of Oracle SNMP Support

How SNMP Works

The Components of SNMP

Management Station

Requirements for Implementing Oracle SNMP Support

Management Framework

Management Application

Managed Node

Master Agent

Subagent

Oracle Enterprise Manager

Intelligent Agents

Management Information Base (MIB)

How SNMP Communications Are Performed

SNMP Support On Oracle

Configuring SNMP on Windows NT

Installing the SNMP Network Service

Configuring the SNMP Network Service

Integrating SNMP with the Intelligent Agent

Installing the Agent

Configuring the SNMP Services File

Modifying the Master Peer Agent Configuration File

Starting the SNMP Environment

Verifying Active UDP Ports

Manually Starting SNMP Services

Starting and Stopping SNMP Services by Batch File

Testing the SNMP Environment

Testing the Value of an OID

Testing Oracle Specific Values

Configuring SNMP on UNIX Platforms

Using only an SNMP Console

Configuring the SNMP Master Agent

Starting the SNMP Agents

Loading the Oracle MIBs

Configuring SNMP with Enterprise Manager

Oracle Products Providing SNMP Support

Oracle Database

Listener

Oracle Names

Oracle Enterprise Manager

MIBs Supporting These Products

Network Services MIB

Public RDBMS MIB

Private Oracle Database MIB

Other Oracle Private MIBs

Interpreting SNMP OIDs

Interpreting Oracle OIDs

Interpreting OIDs for Oracle-Implemented Public MIBs

Interpreting OIDs for Instances of Oracle MIB Variables

Using MIB Variables for Different Purposes

Using a Sufficient Sample Size to Calculate Tuning Ratios

Presenting Performance Ratios Graphically

Scaling MIB Variable Values Dynamically

Working Around the Wraparound

Most Useful Database Instance Performance Ratios

Variable name

oraDbSysTable

oraDbTablespaceTable

oraDbTablespaceIndex

oraDbTablespaceName

oraDbTablespaceSizeAllocated

oraDbTablespaceSizeUsed

oraDbTablespaceState

oraDbTablespaceLargestAvailableChunk

oraDbDataFileTable

oraDbDataFileIndex

oraDbDataFileName

oraDbDataFileSizeAllocated

oraDbDataFileDiskReads

oraDbDataFileDiskWrites

oraDbDataFileDiskReadBlocks

oraDbDataFileDiskWrittenBlocks

oraDbDataFileDiskReadTimeTicks

oraDbDataFileDiskWriteTimeTicks

oraDbLibraryCacheTable

oraDbLibraryCacheIndex

oraDbLibraryCacheNameSpace

oraDbLibraryCacheGets

oraDbLibraryCacheGetHits

oraDbLibraryCachePins

oraDbLibraryCachePinHits

oraDbLibraryCacheReloads

oraDbLibraryCacheInvalidations

oraDbLibraryCacheSumTable

oraDbLibraryCacheSumGets

oraDbLibraryCacheSumGetHits

oraDbLibraryCacheSumPins

oraDbLibraryCacheSumPinHits

oraDbLibraryCacheSumReloads

oraDbLibraryCacheSumInvalidations

oraDbSGATable

oraDbSGAFixedSize

oraDbSGAVariableSize

oraDbSGADatabaseBuffers

oraDbSGARedoBuffers

oraDbConfigTable

oraDbConfigDbBlockBuffers

oraDbConfigDbBlockCkptBatch

oraDbConfigDbBlockSize

oraDbConfigDbFileSimWrites

oraDbConfigDbMultiBlockReadCount

oraDbConfigDistLockTimeout

oraDbConfigDistRecoveryConnectHold

oraDbConfigDistTransactions

oraDbConfigLogArchiveBufferSize

oraDbConfigLogArchiveBuffers

oraDbConfigLogBuffer

oraDbConfigLogCheckpointInterval

oraDbConfigLogCheckpointTimeout

oraDbConfigLogFiles

oraDbConfigMaxRollbackSegments

oraDbConfigMTSMaxDispatchers

oraDbConfigMTSMaxServers

oraDbConfigMTSServers

oraDbConfigOpenCursors

oraDbConfigOpenLinks

oraDbConfigOptimizerMode

oraDbConfigProcesses

oraDbConfigSerializable

oraDbConfigSessions

oraDbConfigSharedPool

oraDbConfigSortAreaSize

oraDbConfigSortAreaRetainedSize

oraDbConfigTransactions

oraDbConfigTransactionsPerRollback

oraRepSchemaTable

oraRepMasterSchema Table

oraRepMasterSchemaRequestErrors

oraRepMasterSchemaResolvedConflicts

oraRepMasterSchemaOtherMasters

oraRepSnapshotSchemaTable

oraRepSnapshotSchemaMaster

oraRepSnapshotSchemaSnapshots

oraRepLinkTable

oraRepLinkIndex

oraRepLinkName

oraRepLinkDeferredTransactions

oraRepLinkErrors

oraRepLinkAdminRequests

oraListenerTraceLevel

oraListenerSecurityLevel

oraListenerParameterFile

oraListenerLogFile

oraListenerTraceFile

oraListenerState

oraListenerNumberOfServices

oraListenerContact

oraSIDTable

oraSIDListenerIndex

oraSIDName

oraSIDCurrentConnectedClients

oraSIDReservedConnections

oraDedicatedSrvTable

oraDedicatedSrvIndex

oraDedicatedSrvEstablishedConnections

oraDedicatedSrvRejectedConnections

oraDispatcherTable

OraDispatcherIndex

oraDispatcherEstablishedConnections

oraDispatcherRejectedConnections

oraDispatcherCurrentConnections

oraDispatcherMaximumConnections

oraDispatcherState

oraDispatcherProtocolInfo

oraPrespawnedSrvTable

oraPrespawnedSrvIndex

oraPrespawnedSrvEstablishedConnections

oraPrespawnedSrvRejectedConnections

oraPrespawnedSrvCurrentConnections

oraPrespawnedSrvMaximumConnections

oraPrespawnedSrvState

oraPrespawnedSrvProtocolInfo

oraPrespawnedSrvProcessorID

oraListenAddressTable

oraListenAddressIndex

oraListenAddress

oraListenerTraps

oraListenerStateChange

oraNamesTNSTable

oraNamesTNSTraceLevel

oraNamesTNSParameterFile

oraNamesTNSRunningTime

oraNamesConfigTable

oraNamesConfigAdminRegion

oraNamesConfigAuthorityRequired

oraNamesConfigAutoRefreshExpire

oraNamesConfigAutoRefreshRetry

oraNamesConfigCacheCheckpointFile

oraNamesConfigCacheCheckpointInterval

oraNamesConfigDefaultForwardersOnly

oraNamesConfigForwardingAvailable

oraNamesConfigForwardingDesired

oraNamesConfigLogStatsInterval

oraNamesConfigMaxReforwards

oraNamesConfigNoModifyRequests

oraNamesConfigResetStatsInterval

oraNamesConfigServerName

oraNamesServerTable

oraNamesServerQueriesReceived

oraNamesServerQueriesTotalTime

oraNamesServerCorruptMessagesReceived

oraNamesServerResponsesSent

oraNamesServerAliasLoopsDetected

oraNamesServerLookupsAttempted

oraNamesServerCreatedOnLookup

oraNamesServerLookupFailures

oraNamesServerExactMatches

oraNamesServerForwardFailures

oraNamesServerForwardTimeouts

oraNamesServerResponsesReceived

oraNamesServerRequestsForwarded

oraNamesServerReloadCheckFailures

oraNamesServerName

oraNamesServerAdminRegion

rdbmsDbTable

rdbmsDbInfoProductName

rdbmsDbInfoVersion

rdbmsDbInfoSizeUnits

rdbmsDbInfoSizeAllocated

rdbmsDbInfoSizeUsed

rdbmsSrvTable

rdbmsSrvPrivateMIBOID

rdbmsSrvVendorName

rdbmsSrvProductName

rdbmsSrvContact

rdbmsSrvInfoTable

rdbmsSrvInfoStartupTime

rdbmsSrvInfoFinishedTransactions

rdbmsSrvInfoDiskReads

rdbmsSrvInfoLogicalReads

rdbmsSrvInfoDiskWrites

rdbmsSrvInfoLogicalWrites

rdbmsSrvInfoPageReads

rdbmsSrvInfoPageWrites

rdbmsSrvInfoRequestsHandled

rdbmsSrvInfoHighwaterInboundAssociations

rdbmsSrvInfoMaxInboundAssociations

rdbmsSrvParamTable

rdbmsSrvParamName

rdbmsSrvParamSubIndex

rdbmsSrvParamCurrValue

rdbmsRelTable

rdbmsTraps

applTable

applInboundAssociations

applAccumulatedInboundAssociations

applAccumulatedOutboundAssociations

applRejectedInboundAssociations

applFailedOutboundAssociations

oraAgentEventTable

oraAgentEventSeverity

oraAgentEventUser

oraAgentEventAppID

oraAgentEventMessage

oraAgentEventArguments

oraAgentEventResults

oraAgentTraps

oraAgentEventOcc

Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Overview of Oracle SNMP Support

2 Configuring SNMP for Oracle

3 Oracle MIB Overview

4 Designing Management Applications Based on Oracle MIBs

5 Reading the MIB Variable Descriptions

A Interpreting Variables of the Oracle Database MIB

B Interpreting Variables of the Oracle Network Listener MIB

C Interpreting Variables of the Oracle Names MIB

D Interpreting Variables of the Public RDBMS MIB

E Interpreting Implemented Variables of the Network Services MIB

F Interpreting Variables of the Enterprise Manager MIB

Glossary

Index