ORA-12170 error
The database(11.2.0.1.0) user(s) are complaining about intermittent ORA-12170 error
while trying to connect to database using Toad. In order to
trace and find out more information, i made following changes in network configuration files on the server:
LISTENER.ORA:
------------------------
LOG_DIRECTORY_LISTENER = /app/oracle/Ora11g/network/log
LOG_FILE_LISTENER = listener.log
TRACE_DIRECTORY_LISTENER = /app/oracle/Ora11g/network/trace
TRACE_FILE_LISTENER = listener.trc
TRACE_LEVEL_LISTENER = ADMIN
INBOUND_CONNECT_TIMEOUT_<listener_name> = 19
SQLNET.ORA:
-----------------
SQLNET.INBOUND_CONNECT_TIMEOUT = 20
The above changes has resulted in generating ever growing trace file under "/app/oracle/Ora11g/log/diag/tnslsnr/<server_name>/listener/trace" directory unlike the one specified above.
------------------------
LOG_DIRECTORY_LISTENER = /app/oracle/Ora11g/network/log
LOG_FILE_LISTENER = listener.log
TRACE_DIRECTORY_LISTENER = /app/oracle/Ora11g/network/trace
TRACE_FILE_LISTENER = listener.trc
TRACE_LEVEL_LISTENER = ADMIN
INBOUND_CONNECT_TIMEOUT_<listener_name> = 19
SQLNET.ORA:
-----------------
SQLNET.INBOUND_CONNECT_TIMEOUT = 20
The above changes has resulted in generating ever growing trace file under "/app/oracle/Ora11g/log/diag/tnslsnr/<server_name>/listener/trace" directory unlike the one specified above.
0