SQL*NET Tracing

If you run into connection timeout issue, firewall, etc..between client and server, you should enable SQL*NET tracing from both client and server.  

To enable client tracing, you can follow the below steps:

(1) Open the SQLNET.ORA file typically found in the following location:
ORACLE_BASE\ORACLE_HOME\Network\Admin

(2) Add the following parameters at the end of the file:
#CLIENT-SIDE SQL*NET TRACE PARAMETERS
#====================================
TRACE_UNIQUE_CLIENT = ON
TRACE_LEVEL_CLIENT = 16
TRACE_DIRECTORY_CLIENT = C:\temp
TRACE_FILE_CLIENT = SQLNetTrace
TRACE_TIMESTAMP_CLIENT = ON
#TRACE_FILELEN_CLIENT = 2048
#TRACE_FILENO_CLIENT = 2

 
To enable the server side tracing, please follow the below steps:
(1) Open the SQLNET.ORA file typically found in the following location:
     ORACLE_BASE\ORACLE_HOME\Network\Admin
(2) Add the following parameters at the end of the file:

#SERVER-SIDE SQL*NET TRACE PARAMETERS
#====================================
TRACE_LEVEL_SERVER = 16
TRACE_DIRECTORY_SERVER = C:\temp
TRACE_FILE_SERVER = SQLNetTrace
TRACE_TIMESTAMP_SERVER = ON