My Oracle Support Banner

SQL*Net & Oracle Net Services - Tracing and Logging at a Glance (Doc ID 219968.1)

Last updated on MARCH 07, 2018

Applies to:

Oracle Net Services - Version 8.1.7.4 to 12.1.0.2 [Release 8.1.7 to 12.1]
Information in this document applies to any platform.

Purpose

The purpose of Oracle Net tracing and logging is to provide detailed information to track and diagnose Oracle Net problems such as connectivity issues, abnormal disconnection and connection delay. Tracing provides varying degrees of information that describe connection-specific internal operations during Oracle Net usage. Logging reports summary, status and error messages.

 For consistency, the term Oracle Net is used throughout this article and refers to all Oracle Net product versions.

Scope

The aim of this document is to overview Oracle Net Services tracing and logging facilities. The intended audience includes novice Oracle users and DBAs alike. Although only basic information on how to enable and disable tracing and logging features is described, the document also serves as a quick reference.

The document provides the reader with the minimum information necessary to generate trace and log files with a view to forwarding them to Oracle Support Services (OSS) for further diagnosis. The article does not intend to describe trace/log file contents or explain how to interpret them.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 LOG & TRACE PARAMETER OVERVIEW
 NOTES ON TRACING 11g AND NEWER CLIENT/SERVER/LISTENER/CMAN
  
 CONFIGURATION FILES
 CONSIDERATIONS WHEN USING NET LOGGING/TRACING
 LOG AND TRACE PARAMETERS
 ORACLE NET TRACE/LOG EXAMPLES
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.