SQL*Net & Oracle Net Services - Tracing and Logging at a Glance
(Doc ID 219968.1)
Last updated on DECEMBER 09, 2022
Oracle Net Services - Version 22.214.171.124 and later Oracle Database - Enterprise Edition - Version 126.96.36.199.0 to 188.8.131.52.0 [Release 18] Information in this document applies to any platform.
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.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!