Sometimes You can get “ORA-12609: TNS: Receive timeout occurred ” error.
Details of error are as follows.
ORA-12609: TNS: Receive timeout occurred
Cause: The receive or read operation did not complete within the allowed time interval.
Action: Check if the peer host is available. Increase the receive timeout value if necessary.
Add this parameter to the sqlnet.ora file at BOTH the origin (or client) and at the Database server / instance:
SQLNET.SEND_TIMEOUT=n
E.g.
SQLNET.SEND_TIMEOUT=300
In my case to solve this error, added the following parameters to the sqlnet.ora file under $ORACLE_HOME/network/admin/
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) SQLNET.INBOUND_CONNECT_TIMEOUT=360 SQLNET.RECV_TIMEOUT=10 SQLNET.SEND_TIMEOUT=10
Recent Posts
