In this post, you’ll learn more about the Oracle ErrorTNS-12170: TNS:Connect timeout occurred with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
TNS-12170: TNS:Connect timeout occurred
Reason for the Error TNS-12170: TNS:Connect timeout occurred
Cause: The server shut down because connection establishment or communication with a client failed to complete within the allotted time interval. This may be a result of network or system delays; or this may indicate that a malicious client is trying to cause a Denial of Service attack on the server.
How to fix the Error TNS-12170: TNS:Connect timeout occurred ?
You can fix this error in Oracle by following the below steps
Action: If the error occurred because of a slow network or system, reconfigure one or all of the parameters SQLNET.INBOUND_CONNECT_TIMEOUT, SQLNET.SEND_TIMEOUT, SQLNET.RECV_TIMEOUT in sqlnet.ora to larger values. If a malicious client is suspected, use the address in sqlnet.log to identify the source and restrict access. Note that logged addresses may not be reliable as they can be forged (e.g. in TCP/IP).