Tracing Oracle Client 11g

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”.

Advertisements

One thought on “Tracing Oracle Client 11g

  1. Pingback: Index | My confrontations with oracle

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