Database Networking (MOSC)

MOSC Banner

Disable client side SQL Net tracing

edited Mar 11, 2016 4:03AM in Database Networking (MOSC) 1 commentAnswered

I enabled SQL Net tracing on both client and server side to trace timeout issues. I tried "Dynamic Listener Tracing" on server side and was able to disable it after couple of days without any issues. At the same time, i enabled client side tracing in a windows server by adding following sqlnet parameters:

#trace_level_client = 16

#trace_file_client = cli

#trace_directory_client = \app\User\product\11.2.0\client_1\network\trace

#trace_unique_client = on

#trace_timestamp_client = on

#trace_filelen_client = 100

#trace_fileno_client = 2

#log_file_client = cli

#log_directory_client = \app\User\product\11.2.0\client_1\network\log

#tnsping.trace_directory =

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center