Tag Archives: DIAG_ADR_ENABLED

Tracing Oracle Client 11g

Posted on by

The other day i spent hours trying to trace my 11g client connection with the sqlnet.ora parmeters that i used in 10g.
TRACE_LEVEL_CLIENT= 16
TRACE_DIRECTORY_CLIENT = /u00/app/oracle/product/11.2.0/client_1/network/trace
TRACE_FILE_CLIENT= client.trc
TRACE_TIMESTAMP_CLIENT = ON
TRACE_UNIQUE_CLIENT = ON

I was aware of the ADR stuff of the server installations, but my client installation seemed to not have those directories in place

CLIENT-> adrci

ADRCI: Release 11.2.0.1.0 – Production on Fri Jun 18 11:49:08 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

No ADR base is set
adrci> show homes
No ADR homes are set
adrci> exit
CLIENT->

I googled again and again until i hit with this blog, where he says that we need to mention

DIAG_ADR_ENABLED=off

in the sqlnet.ora to have the traces files written to “TRACE_DIRECTORY_CLIENT”.