Sometimes You can get “TNS-12609: TNS: Receive timeout occurred ” error.
Details of error are as follows.
TNS-12609: TNS: Receive timeout occurred
Add this parameter to the sqlnet.ora file at BOTH the origin (or client) and at the Database server / instance:
* Where n is a value in seconds. The setting itself, and not the value, should resolve this issue, so a relatively high setting should eliminate this problem but with no impact to normal functions.
To solve this error, add 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
Do you want to learn more details about RMAN, then read the following articles.
1,348 views last month, 1 views today