Jump to Navigation

221 - Fatal NI connect error 12170

You found an error 12170 in an alert.log.

1:23:41am -  Fatal NI connect error 12170
..........
ns secondary err code: 12606
ns main err code: 12535

..........

The client failed to establish a connection and complete authentication in the time specified by the SQLNET.INBOUND_CONNECT_TIMEOUT
parameter in the sqlnet.ora file. This error may be a result of network or system delays, or it may indicate that a malicious client is trying
to cause a denial-of-service attack on the database server.

To fix the problem you could increase the value of INBOUND_CONNECT_TIMEOUT on the listener.ora and the sqlnet.ora file located
on the server side. The default value for this parameter is 60 seconds.

1. listener.ora : INBOUND_CONNECT_TIMEOUT_[ listener_name ] =240
2. sqlnet.ora : SQLNET.INBOUND_CONNECT_TIMEOUT=300

 

Oracle:


Main menu 2

Story | by Dr. Radut