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.

Related Oracle Publications

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

• Oracle Server Concepts

  Includes a technical introduction to the Oracle 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.

• Oracle Server Reference

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

  • configuration parameters for the Oracle7 or Oracle8 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.

• Oracle Server Tuning Guide

  Describes how to tune the Oracle7 or Oracle8 Server, and includes information on:

  • configuration parameters for the Oracle7 or Oracle8 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.

• Understanding SQL*Net

  Describes SQL*Net, including

  • the purpose, function and architecture of SQL*Net

  • the purpose and function of the Listener

  • configuration parameters for SQL*Net and the Listener

  Refer to this book for further information about the functions of SQL*Net, the Listener, and the SNMP-retrievable configuration parameters for these products.

• Oracle Names Administrator's Guide

  Describes the Oracle Names product, including

  • the purpose and function of Oracle Names

  • configuration parameters for Oracle Names

  Refer to this book for further information about the functions of Oracle Names and its SNMP-retrievable configuration parameters.

• 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 Enterprise Manager Installation Guide

  Refer to this book for installation and configuration information for

  • Oracle Enterprise Manager

  • the Intelligent Agent

  • Oracle Enterprise Manager SNMP support

How This Manual Is Organized

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

Chapter 1	Provides a general overview of Oracle SNMP Support for Oracle7 and Oracle8 Servers, Listener, Oracle MultiProtocol Interchange, Oracle Names and Oracle Enterprise Manager. It covers the benefits, basic terms and components of the feature.
Chapter 2	Describes the Oracle products providing SNMP support, the MIBs supporting these products, and how to interpret SNMP object identifiers (OIDs).
Chapter 3	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 4	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 Oracle7 and Oracle8 Database MIBs. These variables support monitoring of the Oracle7 and Oracle8 Servers.
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 Names product.
Appendix D	Provides information to help you interpret and present individual variables of the public RDBMS MIB. These variables support monitoring of the Oracle7 and Oracle8 Servers.
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 Server7, Oracle Server8 and Oracle Names products.
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, 1995.

• Managing Internetworks with SNMP, Second edition, Mark A. Miller, M & T Books, 1997.

• Network Management Standards: SNMP, CMIP, TMN, MIBS, and Object Libraries, Second edition, Uyless Black, McGraw Hill Text, 1994.

• SNMP, SNMPv2, and RMON: The Practical Network Management, Second edition, William Stallings, Addison-Wesley, 1996.

• The Simple Book: An Introduction to Networking Management, Second edition with CD, Marshall T. Rose, Prentice Hall, 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:

Convention	Meaning
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.

---