Skip Headers
Oracle® Enterprise Manager SNMP Support Reference Guide
Release 10.2
Part Number B16244-01
Home
Book List
Index
Master Index
Contact Us
Next
View PDF
Contents
List of Examples
List of Figures
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
Part I List of Chapters
1
Overview of Oracle SNMP Support
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
How SNMP Communications Are Performed
Oracle Enterprise Manager and SNMP
SNMP Trap Notification
SNMP Fetchlets
SNMP Receivelets
Enterprise Manager SNMP Subagent
Management Information Base (MIB)
2
Configuring SNMP for Oracle
Configuring SNMP on Microsoft Windows Platforms
Installing the SNMP Network Service
Configuring the SNMP Network Service
Integrating SNMP with Enterprise Manager SNMP Subagent
Installing the Peer Executables
Configuring the SNMP Services File
Modifying the Oracle SNMP Peer Master 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 Platform
Using only an SNMP Console
Configuring the SNMP Master Agent
Starting the SNMP Agents
Loading the Oracle MIBs
Configuring SNMP with Enterprise Manager
Controlling Enterprise Manager SNMP Subagent
Setting Up SNMP Trap Notifications
3
Oracle MIB Overview
Oracle Products Providing SNMP Support
Oracle Database
Oracle Listener
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
4
Reading the MIB Variable Descriptions
Variable Name Description
MIB Definition
5
Designing Management Applications Based on Oracle MIBs
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
Part II List of Appendices
A
Configuration Files
Configuration Files
User-configurable Parameters
B
Interpreting Variables of the Oracle Database MIB
oraDbSysTable
oraDbSysConsistentChanges
oraDbSysConsistentGets
oraDbSysDbBlockChanges
oraDbSysDbBlockGets
oraDbSysFreeBufferInspected
oraDbSysFreeBufferRequested
oraDbSysParseCount
oraDbSysPhysReads
oraDbSysPhysWrites
oraDbSysRedoEntries
oraDbSysRedoLogSpaceRequests
oraDbSysRedoSyncWrites
oraDbSysSortsDisk
oraDbSysSortsMemory
oraDbSysSortsRows
oraDbSysTableFetchRowid
oraDbSysTableFetchContinuedRow
oraDbSysTableScanBlocks
oraDbSysTableScanRows
oraDbSysTableScansLong
oraDbSysTableScansShort
oraDbSysUserCalls
oraDbSysUserCommits
oraDbSysUserRollbacks
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
oraDbConfigDbBlockSize
oraDbConfigDbMultiBlockReadCount
oraDbConfigLogBuffer
oraDbConfigLogCheckpointInterval
oraDbConfigLogCheckpointTimeout
oraDbConfigOpenCursors
oraDbConfigOpenLinks
oraDbConfigOptimizerMode
oraDbConfigProcesses
oraDbConfigSessions
oraDbConfigSharedPool
oraDbConfigSortAreaSize
oraDbConfigSortAreaRetainedSize
oraDbConfigTransactions
oraDbConfigTransactionsPerRollback
C
Interpreting Variables of the Oracle Network Listener MIB
oraListenerTable
oraListenerIndex
oraListenerName
oraListenerVersion
oraListenerStartDate
oraListenerUptime
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
D
Interpreting Variables of the Public RDBMS MIB
rdbmsDbTable
rdbmsDbIndex
rdbmsDbPrivateMIBOID
rdbmsDbVendorName
rdbmsDbName
rdbmsDbContact
rdbmsDbInfoTable
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
rdbmsRelState
rdbmsTraps
rdbmsStateChange
E
Interpreting Implemented Variables of the Network Services MIB
applTable
applIndex
applName
applVersion
applUptime
applOperStatus
applLastChange
applInboundAssociations
F
Interpreting Variables of the Enterprise Manager MIB
oraEM4AlertTable
oraEM4AlertTargetName
oraEM4AlertTargetType
oraEM4AlertHostName
oraEM4AlertMetricName
oraEM4AlertKeyName
oraEM4AlertKeyValue
oraEM4AlertTimeStamp
oraEM4AlertSeverity
oraEM4AlertMessage
oraEM4AlertRuleName
oraEM4AlertRuleOwner
oraEM4AlertMetricValue
oraEM4AlertContext
oraEM4JobAlertTable
oraEM4JobAlertJobName
oraEM4JobAlertJobOwner
oraEM4JobAlertJobType
oraEM4JobAlertJobStatus
oraEM4JobAlertTargets
oraEM4JobAlertTimeStamp
oraEM4JobAlertRuleName
oraEM4JobAlertRuleOwner
oraEM4JobAlertMetricName
oraEM4JobAlertMetricValue
oraEM4JobAlertContext
oraEM4JobAlertKeyName
oraEM4JobAlertKeyValue
oraEM4JobAlertSeverity
Glossary
Index