Database Error Messages

The connection request cannot be completed within the allotted time interval. This may be a result of network or system delays, a firewall not allowing the connection, no network connectivity between client and server, or it may indicate a denial of service attack on the database server.

The message indicates whether there is a transmission control protocol (TCP) connect timeout, an Outbound connect timeout, or a Receive timeout.

• Ensure that there is network connectivity between client and server, and that the destination is reachable.

• Ensure that there is no firewall in place between client and server. If there is, disable the firewall or configure it to allow the network traffic.

• If the error occurred in your application, then:

• Set CONNECT_TIMEOUT or TRANSPORT_CONNECT_TIMEOUT to a larger value if they are used in an Easy Connect or tnsnames.ora connection string. Or, set one or all of the parameters SQLNET.OUTBOUND_CONNECT_TIMEOUT, SQLNET.RECV_TIMEOUT, or TCP.CONNECT_TIMEOUT in the client sqlnet.ora file to a larger value. The connection string parameters have higher precedence than the corresponding sqlnet.ora parameters.

• In languages that support programmatic driver settings, adjust the settings equivalent to the previously mentioned timeouts. For example, with JDBC, adjust oracle.net.OUTBOUND_CONNECT_TIMEOUT, oracle.net.CONNECT_TIMEOUT, or use setLoginTimeout(). With Python python-oracledb, adjust the TcpConnectTimeout parameter when calling connect() or create_pool().

• If the error occurred in the database alert log file, then set one or both of the parameters, SQLNET.INBOUND_CONNECT_TIMEOUT or SQLNET.RECV_TIMEOUT, in the database sqlnet.ora file to a larger value.

• If a malicious client is suspected, then use the database alert log to identify the source address and then restrict access.

• Use the CONNECTION_ID value to track this connection attempt in trace files for further diagnosis.

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.

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).

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.

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).