What is the cause and solution for oracle error ORA-12170 TNS: Connect timeout occurred?
Cause:
The failure of the connection with the client to finish within the allotted period causes the server to shut down. Delays in the system or network could be the blame for this. This suggests that a rogue client is attempting to attack the server using a denial of service attack.
Solution:
Change one or all of the parameters SQLNET.INBOUND CONNECT TIMEOUT, SQLNET.SEND TIMEOUT, and SQLNET.RECV TIMEOUT in sqlnet.ora to bigger values if the error is caused by a slow network or system. Use the address in sqlnet.log to find the source and limit access if any malicious clients are suspected during this. But keep in mind that the address that was logged might not be accurate because it is simple to fake addresses.