ORA-12170: TNS: Connect timeout occurred error message to the sqlnet.log file.
The ORA-609 error is thrown when a client connection of any kind failed to complete or aborted the connection process before the connection/authentication process was complete.
Other error may occurred due to this parameter
ORA-12170: TNS: Connect timeout occurred error message to the sqlnet.log file.
ORA-12547: TNS: lost contact
ORA-12637: Packet receive failed error message.
Solution:
Increase value of INBOUND_CONNECT_TIMEOUT parameter in both SQLNET and LISTENER file.
INBOUND_CONNECT_TIMEOUT parameter is the time in seconds used for client to connect with the database and within time provide authentication to connection.
INBOUND_CONNECT_TIMEOUT = 60
In Listener, Oracle Recommends to set this parameter in combination for protect both the listener and DB Server. Set the Listener parameter to lower value than SQLNET parameter. If client not able to make connection and got above error then increased the above parameter as needed.
You need to mention this parameter with listener name and reload the listener after changes.
INBOUND_CONNECT_TIMEOUT_LISTENER = 60
lsnrctl stop
lsnrctl start
i have set these parameter still it is giving same error
i have set these parameter still it is giving same error
11.2.0.3 with Oracle Linux 6.3
Try with increase the value of these parameters
SQLNET.ORA : SQLNET.INBOUND_CONNECT_TIMEOUT=180
Listener.ora: INBOUND_CONNECT_TIMEOUT_listener_name=120