IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
Hi,
Sometimes You can get “TNS-12608: TNS: Send timeout occurred ” error.
Details of error are as follows.
TNS-12608: TNS: Send timeout occurredCause: The send or write operation did not complete within the allowed time interval.
Action: Check if the peer host is available. Increase the send 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
* 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.
E.g.
SQLNET.SEND_TIMEOUT=60000
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.
https://ittutorial.org/rman-backup-restore-and-recovery-tutorials-for-beginners-in-the-oracle-database/
