1 Reply Latest reply: Sep 27, 2012 9:59 AM by Johnsung-Oracle RSS

    SQL*Net Client Side Tracing

    937282
      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-Oracle
          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