Sql Net client tracing

So simple to do, so helpful for network connection issues

In the ORACLE_HOME or TNS_ADMIN directory, edit the sqlnet.ora file
adding the following lines:

#Create an individual client trace file for each process TRACE_UNIQUE_CLIENT = ON #Specify the level of detail for client trace, choose one TRACE_LEVEL_CLIENT = OFF|USER|ADMIN|SUPPORT #Stops trace file going to the ADR dir, useful if you don't have rights on the ADR dir. DIAG_ADR_ENABLED=OFF #Specify the directory for the client trace file TRACE_DIRECTORY_CLIENT = /tmp #Specify the name of the client trace file TRACE_FILE_CLIENT = sqlnetclienttrace #Includes a timestamp (to microseconds) for each event in the client trace TRACE_TIMESTAMP_CLIENT = ON

******************************************
keywords: sql net client trace
******************************************
rdbms version: 11g
******************************************