Preface

This guide covers the Oracle SNMP Support feature and the public and private MIBs that support its use with certain products. This information is provided to assist you in developing SNMP-based management applications for these products.

Audience

This manual is intended primarily for third-party developers of SNMP-based management applications. While these readers may have a good working knowledge of SNMP, they may not be as familiar with relational databases, or Oracle products in particular. A secondary audience for this manual includes database administrators, who may be familiar with Oracle products, but who may be less familiar with SNMP.

Documentation Accessibility

Our goal is to make Oracle products, services, and supporting documentation 
accessible, with good usability, to the disabled community. To that end, our 
documentation includes features that make information available to users of 
assistive technology. This documentation is available in HTML format, and contains 
markup to facilitate access by the disabled community. Standards will continue to 
evolve over time, and Oracle Corporation is actively engaged with other 
market-leading technology vendors to address technical obstacles so that our 
documentation can be accessible to all of our customers. For additional information, 
visit the Oracle Accessibility Program Web site at
 http://www.oracle.com/accessibility/

Accessibility of Code Examples in Documentation

JAWS, a Windows screen reader, may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, JAWS may not always read a line of text that consists solely of a bracket or brace.

Related Oracle Publications

Several other Oracle publications include information relating to topics covered in this manual. Where the system (Oracle7, Oracle8i, or Oracle 9i) is not specified, consult your system-specific documentation:

• Oracle9i Database Concepts

  Includes a technical introduction to the Oracle Database Server, and covers important topics including:

  • basic database structure and operation
  • system architecture
  • data access
  • programmatic constructs
  • database security
  • distributed database processing
  • database backup and recovery

  Refer to this book for further information on database topics and terms mentioned in this manual.

• Oracle9i Database Reference

  Includes reference information on sources from which the values for private Oracle database MIB variable are retrieved, including:

  • configuration parameters for the Oracle9i Server
  • data dictionary tables
  • dynamic performance tables

  Refer to this book for further information on SNMP-retrievable parameters and variables for the public and private database MIBs.

• Oracle9i Database Performance Guide and Reference

  Describes how to tune the Oracle Server, and includes information on:

  • configuration parameters for the Oracle9i Server
  • data dictionary tables
  • dynamic performance tables

  Refer to this book if you choose to learn about certain SNMP-retrievable variables as they relate to various database performance tuning tasks. Such task-oriented information can provide further context for the MIB variable reference information of the Oracle SNMP Support Reference Guide.

• Oracle Net Services Reference Guide

  Describes Oracle Net Services, including:

  • the purpose, function and architecture of Oracle Net Services
  • configuration parameters for the various Oracle Net Services components, such as Oracle Net, the listener, and Oracle Names

  Refer to this book for further information about the Oracle Net Services components.

• Oracle operating system-specific manuals include installation instructions for Oracle SNMP Support on a given platform.

  Refer to this book for installation instructions and other information that is platform or operating system specific.

• Oracle Net Services Reference Guide

  Refer to this book for configuration information for

  • Oracle Enterprise Manager
• Oracle Intelligent Agent User's Guide

  Refer to this book for configuration information for

  • the Intelligent Agent
  • Oracle Enterprise Manager SNMP support

How This Manual Is Organized

The Oracle SNMP Support Reference Guide includes five chapters and six appendices.

Chapter 1

Provides a general overview of Oracle SNMP Support for the Oracle Database Server, Listener, Oracle Connection Manager, Oracle Names and Oracle Enterprise Manager. It covers the benefits, basic terms and components of the feature.

Chapter 2

Provides procedures to configure SNMP on Windows NT, Unix, and the Oracle Enterprise Manager.

Chapter 3

Describes the Oracle products providing SNMP support, the MIBs supporting these products, and how to interpret SNMP object identifiers (OIDs).

Chapter 4

Includes suggestions to assist you in developing the most useful management applications for Oracle products. Using a sufficient sample size to calculate ratios, presenting performance ratios graphically, scaling values dynamically, working around the wraparound, and the top twenty database performance ratios are covered.

Chapter 5

Covers the format used to describe MIB variables in the appendices of this manual.

Appendix A

Provides information to help you interpret and present individual variables of the private Oracle Database MIBs. These variables support monitoring of the Oracle Server.

Appendix B

Provides information to help you interpret and present individual variables of the private Oracle Listener MIB. These variables support monitoring of the listener service.

Appendix C

Provides information to help you interpret and present individual variables of the private Oracle Names MIB. These variables support monitoring of the Oracle Net Services components.

Appendix D

Provides information to help you interpret and present individual variables of the public RDBMS MIB. These variables support monitoring of the Oracle.

Appendix E

Provides information to help you interpret and present individual variables of the public Network Services MIB. These variables support monitoring of the Oracle Server and Oracle Net Services components.

Appendix F

Provides information to help you interpret and present individual variables of the private Oracle Enterprise Manager MIB. These variables support monitoring of databases with Oracle Enterprise Manager.

Other Related Documents

Any developer of management applications for Oracle SNMP Support must be familiar with SNMP concepts. Standard texts include:

• How to Manage Your Network Using SNMP: The Networking Management Practicum, Marshall T. Rose, Keith McCloghrie, Prentice Hall, 1994.
• Managing Internetworks with SNMP, Third edition, Mark A. Miller, M & T Books, 1999.
• SNMP, SNMPv2, and RMON: The Practical Network Management, Second edition, William Stallings, Addison-Wesley, 1996.
• Total SNMP: Exploring the Simple Network Management Protocol, Second Edition, Sean J. Harnedy, Prentice Hall, 1997.

Relevant RFCs include:

• RFC 1441, Introduction to version 2 of the Internet-standard Network Management Framework.
• RFC 1442, Structure of Management Information for version 2 of the Simple Network Management Protocol.
• RFC 1565, The Network Services Monitoring MIB.
• RFC 1697, The RDBMS MIB.

Relevant Oracle MIB Definitions include:

• Oracle RDBMS MIB
• Oracle Listener MIB
• Oracle Names MIB

Notational Conventions

The following syntax conventions are used in this manual:

Monospace normal

Monospace shows computer display or contains text you must enter exactly as shown.

Monospace italics

Monospace in italics represents a command parameter or variable. Substitute an appropriate value.

UPPERCASE

Uppercase characters within the text represent command names, filenames, and directory names. Note that in case-sensitive operating systems, such as UNIX, these names may not necessarily be in upper-case.

Italics

Text in italics usually indicates a variable for which you need to substitute a value. Italics are also used to draw attention to the first instance of a defined term in the text.