Site icon IT Tutorial

TNS-00505: Operation timed out

Hi,

Sometimes You can get “TNS-00505: Operation timed out ” error.

 

Details of error are as follows.

TNS-00505: Operation timed out
Cause: The requested operation could not be completed within the timeout period.
Action: For further details, turn on tracing and reexecute the operation.

To solve this error, set the following parameters in the sqlnet.ora under $ORACLE_HOME/network/admin.

 

SQLNET.INBOUND_CONNECT_TIMEOUT=900

SQLNET.EXPIRE_TIME= 15

 

and set the following parameters in the listener.ora under $ORACLE_HOME/network/admin.

 

INBOUND_CONNECT_TIMEOUT_<listener_name>=400

 

 

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/

 

Exit mobile version