Oracle SNMP Support Reference Guide

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:

Oracle7 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.

Oracle7 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 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.

Oracle7 Server Tuning Guide

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

configuration parameters for the Oracle7 Server

data dictionary tables

dynamic performance tables

Oracle SNMP Support Reference Guide.

Understanding SQL*Net

Describes SQL*Net release 2.2, 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 MultiProtocol Interchange Administrator's Guide

Describes the Oracle MultiProtocol Interchange, including:

the purpose and function of the Oracle MultiProtocol Interchange

configuration parameters for the Oracle MultiProtocol Interchange

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

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 Network Manager Administrator's Guide

Describes the tool that creates the configuration file for Oracle SNMP Support and other Oracle networking products.

Use this book to configure Oracle SNMP Support for Oracle networking products (Oracle Names, Oracle MultiProtocol Interchange, the Listener, and the Oracle7 Server).

How This Manual Is Organized

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

Chapter 1 - Overview of Oracle SNMP Support

This chapter provides a general overview of Oracle SNMP Support for the Oracle7 Server, Listener, Oracle MultiProtocol Interchange and Oracle Names products. It covers the benefits, basic terms and components of the feature.

Chapter 2 - Oracle MIB Overview

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

Chapter 3 - Designing Management Applications Based on Oracle MIBs

This chapter 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 - Reading the MIB Variable Descriptions

This chapter covers the format used to describe MIB variables in the appendices of this manual.

Appendix A - Interpreting Variables of the Oracle Database MIB

This appendix provides information to help you interpret and present individual variables of the private Oracle7 Database MIB. These variables support monitoring of the Oracle7 Server.

Appendix B - Interpreting Variables of the Oracle Network Listener MIB

This appendix 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 - Interpreting Variables of the Oracle MultiProtocol Interchange MIB

This appendix provides information to help you interpret and present individual variables of the private Oracle MultiProtocol Interchange MIB. These variables support monitoring of the Oracle MultiProtocol Interchange.

Appendix D - Interpreting Variables of the Oracle Names MIB

This appendix 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 E - Interpreting Variables of the Public RDBMS MIB

This appendix provides information to help you interpret and present individual variables of the public RDBMS MIB. These variables support monitoring of the Oracle7 Server.

Appendix F - Interpreting Implemented Variables of the Public Network Services MIB

This appendix provides information to help you interpret and present individual variables of the public Network Services MIB. These variables support monitoring of the Oracle7 Server, Oracle MultiProtocol Interchange and Oracle Names products.

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.

Your Comments Are Welcome

We value and appreciate your comments as an Oracle user and reader of the manuals. As we write, revise, and evaluate our documentation, your opinions are the most important input we receive. At the back of our printed manuals is a Reader's Comment Form, which we encourage you to use to tell us what you like and dislike about this manual or other Oracle manuals. If the form is not available, please use the following address or FAX number.