Home > Database > Oracle Client Trace Configuration

Oracle Client Trace Configuration

April 11th, 2017

The purpose of this configuration is to troubleshoot Oracle client issues that might be affecting the connectivity between an application and the Oracle database server.

You can insert the following lines inside the oracle client sqlnet.ora file after fixing the path to the directories

trace_level_client = 16
 trace_file_client = cli
 trace_directory_client = f:\oracle_client
 trace_unique_client = on
 trace_timestamp_client = on
 trace_filelen_client = 100
 trace_fileno_client = 2
 log_file_client = cli
 log_directory_client = f:\oracle_client\log
 tnsping.trace_directory = f:\oracle_client\log
 tnsping.trace_level = admin

Once done with your tests, make sure to remove the lines from the sqlnet.ora file as it will affect the performance of the application as well as consume disk space to store the trace files.

Categories: Database Tags:
Comments are closed.