How to resolve the TNS-12535 operation timed out error?

Asked By groat n 0 points N/A Posted on - 06/08/2020

Hello guys, I’m getting a TNS-12535 error whenever I’m trying to connect to Oracle in SQL*Plus, please help me out in fixing this error. How to fix the TNS-12535 operation timeout error?

• Status:
• Question Views: 130
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Others

Best Answer by

Go To Solution

Answered By fidelgiancarlo 10 points N/A #330357

How to resolve the TNS-12535 operation timed out error?

Hello, TNS-12535 error occurs whenever the requested operation can not be processed with in the period.

Refer to SQLNET.LOG to find a secondary error if not provided explicitly. If you want to gather additional information, turn on tracing.

Follow these steps to get back the connectivity to Oracle:

• Check your client-side SQLNET.LOG files for more details.
• Using tnsping: try to connect directly from your client

tnsping<Servicename>

• Run stack pack look at timed out events. If SQL*Net waits, then you need to pitch your network.
• You have to adjust the timeout threshold. The file entry of SQLNET.ORA file “sql net.recv_timeout” will limit the time specified for the database server to wait for the client data, once the connection created. When the time has been set, then the client must send the data within the specified time.

About fidelgiancarlo

Questions
20

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 06/08/2020
• Question Category: Others