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] |
1 Comment »
Leave a Reply
-
OraNA
-
Archives
- February 2017 (1)
- November 2016 (1)
- October 2016 (1)
- May 2016 (2)
- March 2016 (3)
- December 2014 (2)
- July 2014 (1)
- June 2014 (6)
- May 2014 (5)
- February 2014 (1)
- December 2012 (2)
- November 2012 (8)
-
Categories
-
RSS
Entries RSS
Comments RSS
It is a little difficult to find trace file now…