Oracle Network Products Troubleshooting Guide
Preface
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 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
- 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
- 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:
- using Audit Trail information
- 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:
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
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:
Oracle Network Products Documentation Manager
Oracle Corporation
500 Oracle Parkway
Redwood Shores, CA 94065
FAX: 415-506-7200