Guenadi N Jilevski's Oracle BLOG

Oracle RAC, DG, EBS, DR and HA DBA BLOG

Oracle 11g SQL*Net client trace file in non default location

Oracle 11g SQL*Net client trace file in non default location

In Oracle 11g setting the SQL*Net tracing as conducted in previous releases did not produce the trace file in the location I expected.

 

TRACE_LEVEL_CLIENT= 16
TRACE_DIRECTORY_CLIENT = /tmp
TRACE_FILE_CLIENT= client.trc
TRACE_TIMESTAMP_CLIENT = ON
TRACE_UNIQUE_CLIENT = ON

After a while I found out that due to ADR the client trace files are located in $ORACLE_BASE/diag/clients/user_oracle/host_xxx/trace directory.

Setting DIAG_ADR_ENABLED=off in the sqlnet.ora files enables the pre-11g tracing.

After implementing the parameter change in the client sqlnet.ora the trace files are generated in /tmp directory.
my client sqlnet.ora :the content ofHere is

For further information:

Using and Disabling the Automatic Diagnostic Repository (ADR) with Oracle Net for 11g [ID 454927.1]

SQL*Net & Oracle Net Services – Tracing and Logging at a Glance [ID 219968.1]

 
  

 


April 4, 2010 Posted by | oracle | 1 Comment