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 »

  1. It is a little difficult to find trace file now…

    Comment by maclean | November 2, 2010 | Reply


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: