About Fatal NI connect error 12170

Source: Internet
Author: User
The error in sqlnet. log is as follows:

Fatal Ni connect error 12170.

Version Information:
TNS for Linux: Version 10.2.0.1.0-Production
Oracle bequeath nt protocol adapter for Linux: Version 10.2.0.1.0-Production
TCP/IP nt protocol adapter for Linux: Version 10.2.0.1.0-Production
Time: 29-nov-2006 19:13:40
Tracing not turned on.
TNS error struct:
NS main err code: 12535
TNS-12535: TNS: Operation timed out
NS secondary err code: 12560
NT main err code: 505
TNS-00505: Operation timed out.
NT secondary err code: 110
Nt OS err code: 0
Client address: (ADDRESS = (PROTOCOL = tcp) (HOST = 219.239.13.3) (PORT = 19948 ))

# Object Storage Service (oerr) tns 12170
12170,000 00, "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.
// * 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
// Identify the source and restrict access. Note that logged addresses may
// Not be reliable as they can be forged (e.g. in TCP/IP ).

Increase the parameters in sqlnet. ora:
SQLNET. INBOUND_CONNECT_TIMEOUT = 30
SQLNET. RECV_TIMEOUT = 30
SQLNET. SEND_TIMEOUT = 30

Add the following in listener. ora:
INBOUND_CONNECT_TIMEOUT_LISTENER = 30

Restart listener:
Lsnrctl reload

 


Let's see how it works.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.