This discussion is archived
1 Reply Latest reply: Sep 27, 2012 7:59 AM by Johnsung RSS

SQL*Net Client Side Tracing

937282 Newbie
Currently Being Moderated
Hello,

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
#SQLNET.AUTHENTICATION_SERVICES=(NONE)
SQLNET.AUTHENTICATION_SERVICES=(NTS)

DEFAULT_SDU_SIZE=32767

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.

Thanks
  • 1. Re: SQL*Net Client Side Tracing
    Johnsung Pro
    Currently Being Moderated
    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
    diag_adr_enabled =OFF

    [oops] saw that this is over a month old this post - sorry about that!

    hope that helps
    John

    Edited by: Johnsung on Sep 27, 2012 3:59 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points