I am trying to set up a client side trace but its not working. Here is the SQLNET.ora for the client.
AUTOMATIC_IPC = OFF
SQLNET.EXPIRE_TIME = 0
SQLNET.INBOUND_CONNECT_TIMEOUT = 0
#trace_level_client = off
#trace_file_client = sqlnet
#log_file_client = sqlnet
trace_level_client = 16
trace_file_client = cli
trace_directory_client = c:\trace
trace_unique_client = on
trace_timestamp_client = on
trace_filelen_client = 100
trace_fileno_client = 2
log_file_client = cli
log_directory_client = c:\trace\log
tnsping.trace_directory = c:\trace\trace
tnsping.trace_level = admin
This is on 11G.
By default in 11g traces will go to the ADR which is a new feature.
To disable that feature add the following line to your sqlnet.ora
[oops] saw that this is over a month old this post - sorry about that!
hope that helps
Edited by: Johnsung on Sep 27, 2012 3:59 PM