For the oracle errors like “ORA-12170: TNS:Connect timeout occurred”, “ORA-12535: TNS:operation timed out”, “ORA-12560: TNS:protocol adapter error”, “TNS-00505: Operation timed out” and like others related to oracle listener it is useful of tracing the listener activities to dig down further.
- Connect to the listener control utility from the command line or shell.
- Run the below command to enable the tracing for ADMIN mode.
set trc_level ADMIN
- Check the listener tracing file location and name.