Oracle Network Products Troubleshooting Guide

Library

Product

Contents

Index

Info

This manual provides information required to understand and use the problem resolution utilities of the following Oracle network products:

SQL*Net version 2.0 and later

Oracle MultiProtocol Interchange

Oracle Protocol Adapters

Oracle Network Manager

Oracle Names

Secure Network Systems

Oracle Native Naming Adapters

In particular, this guide:

provides an overview of messages, error logs, and trace facilities

describes how to use the error logs and trace facilities

describes how to configure the client, server, Interchange, listener, and Names Server components to invoke the trace facility

lists all the Oracle network product error messages and their probable causes and provides the actions recommended to correct them

Audience

The information in this manual is intended primarily for network administrators, but may be useful for all users of Oracle network products.

Documentation Set

The Oracle network products documentation set consists of manuals that help you to set up an integrated, heterogeneous network and to use the applications and services provided. The documentation consists of the following manuals:

The Oracle Network Products Troubleshooting Guide (this manual) describes aspects of errors and diagnosing them, including:

information about coping with errors and using the diagnostic features of Oracle network products

the error messages and informational messages that may occur during use of SQL*Net, the Interchange, and Oracle Protocol Adapters

the error messages and informational messages that may occur during use of the Oracle Network Manager and Oracle Names.

Understanding SQL*Net provides an overview of SQL*Net version 2.3 and specific information about:

the architecture of SQL*Net V2.3

planning and configuring SQL*Net V2.3

using SQL*Net V2.3

Oracle Network Manager Administrator's Guide describes how to use the Oracle Network Manager to create and manage the configuration files needed for your network.

Oracle MultiProtocol Interchange Administrator's Guide describes the MultiProtocol Interchange, including:

the purpose and function of the Interchange

the architecture of the Interchange

considerations for designing an Oracle application network

configuring and using the Interchange in an Oracle application network

Oracle Names Administrator's Guide describes how to use this product to provide structured administration for a distributed database network.

The Oracle SNMP Support Reference Guide describes how to use Oracle SNMP Support, which works with third-party vendor software to monitor services in a SQL*Net network. The guide includes MIBS for the following network objects:

Oracle MultiProtocol Interchange

Network listener

Oracle Names Server

Oracle7 Server

The Secure Network Services Administrator's Guide describes the new encryption, checksum, and authentication features available to add security to network messages, including:

the purpose of the new security features

the effectiveness of the security features

how to enable the security features using Oracle Network Manager

Note: Secure Network Services release 1.1 includes encryption and checksum abilities. Secure Network Services version 2.0 also includes authentication services.

Oracle Protocol Adapters Information

Various Oracle operating system-specific documents provide Oracle Protocol Adapter information for each operating system.

Refer to the Oracle installation documentation for your platform in order to determine where to find information, including:

an overview of the Oracle Protocol Adapters

protocol terms and concepts

protocol-specific keywords used in the connect descriptors

Throughout this book you will see these small book icons to alert you to other pertinent network product or operating system documentation.

In addition, you may wish to refer to other Oracle product documentation.

How This Manual Is Organized

The Oracle Network Products Troubleshooting Guide is organized into ten chapters and one appendix.

Chapter 1--Troubleshooting Techniques

This chapter provides an overview of methods for resolving problems in an Oracle application network. The topics it covers include:

reading log files

using Audit Trail information

reading trace files

locating different types of Oracle networking error messages

understanding error message stacks

using error number ranges

using the Client Status Monitor

using the Trace Route Utility

calling Oracle Customer Support

Chapter 2--Logging

This chapter describes how to control and use the log facility. It explains how to use log information to diagnose and resolve operating problems. It includes information about:

logging parameters

sample log output

the Audit Trail utility

Chapter 3 - Tracing

This chapter describes the trace options that may be used to examine Oracle network applications. It explains how to invoke the trace utility and use the trace information to diagnose and resolve operating problems. It includes information about:

how to set tracing parameters

how to invoke the trace facility

sample trace output

examples of tracing

Chapter 4 - Client Status Monitor

This chapter describes the Client Status Monitor and the SQL*Net Editor. As an aid to problem diagnosis, the Client Status Monitor provides detailed information about an individual client. The SQL*Net Editor is a tool used to edit many of the optional parameters in a client's SQLNET.ORA file.

Chapter 5 - Trace Route Utility

This chapter describes the new Trace Route Utility. This utility sends a packet to a server and returns information about the nodes it encounters on its way. If it encounters an error, it returns an error stack.

Chapter 6--Networking Error Messages

This chapter lists error messages you may see when using SQL*Net and the Oracle MultiProtocol Interchange. For each error, the probable cause and corrective action are given.

Chapter 7--Network Manager Error Messages

This chapter lists the messages you may see when using Oracle Network Manager. For each error, the probable cause and corrective action are given.

Chapter 8--Oracle Names Error Messages

This chapter lists the messages you may see when using Oracle Names. For each error, the probable cause and corrective action are given.

Chapter 9--Oracle SNMP Support Error Messages

This chapter lists the messages you may see when using Oracle SNMP Support. For each error, the probable cause and corrective action are given.

Chapter 10--Oracle Native Naming Adapter Error Messages

This chapter lists the messages you may see when using Oracle Native Naming Adapters. For each error, the probable cause and corrective action are given.

Appendix A--Trace and Log Parameter Reference

This appendix provides a detailed reference for the log and trace facilities parameters and how they are used.

Note: This guide contains examples and figures that refer to specific machine types, network protocols, and operating systems. These references are examples of one type of configuration and are not representative of all configurations. For operating system-specific issues, such as installation, configuration file locations, and protocol support, see your Oracle operating system-specific manual.

Suggestions for Using this Manual

For a general overview of the terms and concepts associated with error messages, read Chapter 1, "Troubleshooting Techniques".

To understand how to use log facilities in Oracle network products, read Chapter 2, "Logging".

To understand how to use trace facilities in Oracle network products, read Chapter 3, "Tracing".

To understand how to use the Client Status Monitor and the SQLNET.ORA Editor, read Chapter 4, "Client Status Monitor".

To find the cause of a specific error message and learn the recommended course of action, refer to the following:

Chapter 6, ``Networking Error Messages"

Chapter 7, "Network Manager Error Messages"

Chapter 8, "Oracle Names Error Messages"

Chapter 9, "Oracle SNMP Support Error Messages"

Chapter 10, "Oracle Native Naming Adapter Error Messages"

For a detailed reference on the parameters of the log and trace facilities, read Appendix A, ``Trace and Log Parameter Reference".

Notational Conventions

The following syntax conventions are used in this guide:

Monospace normal

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

Italics (italics)

Italics, whether in monospace or in regular text font, represent a variable. Substitute an appropriate value. Italics in text is also used to draw attention to a technical term used for the first time, for emphasis, and to denote book titles.

[ ]

Brackets enclose optional items. Do not enter the brackets.

A vertical bar represents a choice of two or more options. You must enter one of the options. Do not enter the vertical bar.

Punctuation

Punctuation other than brackets and vertical bars must be entered as shown.

UPPERCASE

Uppercase characters within the text represent command names, filenames, directory names, and parameter names.

Note: Some operating systems are case sensitive. Although our convention is to present command names, filenames, directory names, and parameters in uppercase, that does not necessarily mean that they should be in uppercase on your platforms.

Your Comments Are Welcome

We value and appreciate your comments as an Oracle products user. As we write, revise, and evaluate our work, your opinions are the most important input we receive. At the back of this guide is a Reader's Comment Form; we encourage you to use this form to tell us what you like and dislike about this (or other) Oracle manuals. If the form is gone, or you would like to contact us, please use the following address:

Prev Next

Library

Product

Contents

Index