Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SQL*Net Client Side Tracing

937282Aug 22 2012 — edited Sep 27 2012
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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 25 2012
Added on Aug 22 2012
#oracle-provider-for-ole-db, #windows-and-net
1 comment
5,825 views