 |
|
ORA-12535: TNS: operation timed out tips
Oracle Error Tips by Stephanie F.
|
Question: I am getting
the ORA-21535 error when attempting to connect to Oracle:
ORA-12535: TNS: operation timed out
How do I fix this ORA-13595 error?
Answer: The oerr utility note this on the
ORA-12535 error:
ORA-12535: TNS: operation timed out
Cause: The requested operation could not be completed within the
time out period.
Action: Look at the documentation
on the secondary errors for possible remedy. See SQLNET.LOG to find
secondary error if not provided explicitly. Turn on tracing to gather more
information.
To diagnose a ORA-12535 error,
follow these steps to ensure connectivity to Oracle:
1 - Check your client-side sqlnet
log files for more details
2 - Try a direct connection from your client using tnsping:
tnsping <servicename>
3 - Run a statspack or AWR report and look at the top-5 timed events. If "SQL*Net"
waits are there, you may need to tune your network (SDU, TDU).
4 - Adjust the timeout threshold. The sqlnet.ora file entry
sqlnet.recv_timeout is used to limit the time, specified in
seconds, for a database server to wait for client data after a connection is
established. When this parameter is set, a client must send some data within
the specified time interval.
