Oracle Net Services-Tracing and Logging at a Glance

Oracle Net trace is used to track or debug oracle connection failures, abnormal disconnection, connection timeout, and other situations. It generates detailed tracking information to analyze and diagnose Oracle Net-related faults. Network debugging is implemented by adding relevant parameters to the relevant network configuration file. The ID 219968.1 on MetaLink has a detailed description.

1. Oracle trace Parameters

TRACE_LEVEL _ [CLIENT | SERVER | LISTENER] = [0-16 | USER | ADMIN | SUPPORT | OFF]
TRACE_FILE _ [CLIENT | SERVER | LISTENER] = <file name>
TRACE_DIRECTORY _ [CLIENT | SERVER | LISTENER] = <DIRECTORY>
TRACE_UNIQUE _ [CLIENT | SERVER | LISTENER] = [ON | TRUE | OFF | FALSE]
TRACE_TIMESTAMP _ [CLIENT | SERVER | LISTENER] = [ON | TRUE | OFF | FALSE] # Oracle8i +
TRACE_FILELEN _ [CLIENT | SERVER | LISTENER] = <SIZE in KB> # Oracle8i +
TRACE_FILENO _ [CLIENT | SERVER | LISTENER] = <NUMBER> # Oracle8i +
 
LOG_FILE _ [CLIENT | SERVER | LISTENER] = <file name>
LOG_DIRECTORY _ [CLIENT | SERVER | LISTENER] = <directory name>
LOGGING_LISTENER = [ON | OFF]
 
TNSPING. TRACE_LEVEL = [0-16 | USER | ADMIN | SUPPORT | OFF]
TNSPING. TRACE_DIRECTORY = <DIRECTORY>
 
NAMES. TRACE_LEVEL = [0-16 | USER | ADMIN | SUPPORT | OFF]
NAMES. TRACE_FILE = <file name>
NAMES. TRACE_DIRECTORY = <DIRECTORY>
NAMES. TRACE_UNIQUE = [ON | OFF]
NAMES. LOG_FILE = <file name>
NAMES. LOG_DIRECTORY = <DIRECTORY>
NAMES. LOG_UNIQUE = [ON | OFF]
 
NAMESCTL. TRACE_LEVEL = [0-16 | USER | ADMIN | SUPPORT | OFF]
NAMESCTL. TRACE_FILE = <file name>
NAMESCTL. TRACE_DIRECTORY = <DIRECTORY>
NAMESCTL. TRACE_UNIQUE = [ON | OFF] notes on tracing 11g and newer client/SERVER/LISTENER/CMAN

For Oracle 11g, the following parameters must be added when using traditional Oracle net tracing.
 
Sqlnet. ora file on either client or server:
 
DIAG_ADR_ENABLED = OFF
 
Listener. ora file:
 
DIAG_ADR_ENABLED _ <listener_name> = OFF
 
CMAN. ORA:
 
DIAG_ADR_ENABLED = OFF
ADR_BASE = c: \ your_directory

1 2 3 4 Next Page