Fatal Ni Connect Error 12170 Sqlnet.ora
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
fatal ni connect error 12170 Oracle Database Tips by Burleson Consulting November 5, 2015 Question: Below error getting in alert log file every day, but database is working fineWhat are the reason for this Fatal ni connect error 12170? Fatal NI connect error 12170. VERSION INFORMATION: TNS for 64-bit Windows: Version 11.2.0.1.0 - Production Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production Time: 28-MAY-2012 19:20:02 Tracing not turned on. Tns error struct: ns main err code: 12535 TNS-12535: TNS:operation timed out ns secondary err code: 12560 Answer: The fatal ni connect error 12170 is related to the ORA-12170 error: ORA-12170: TNS:Connect timeout occurredCause: 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. 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.STNS for Linux: Version 10.2.0.4.0 - Production Oracle Bequeath NT Protocol Adapter for Linux: Version 10.2.0.4.0 - Production TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.4.0 - Production Time: 06-MAY-2009 18:54:41 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=*.*.*.*)(PORT=3448))The same error message was repeating during whole day almost for every application server.I've finally http://www.dba-oracle.com/t_fatal_ni_connect_error_12170.htm found what was causing the problem. Our database is behind a firewall. Firewall has an "idle session timeout" value. If a connection remains idle for more than the "idle session timeout" value it drops the connections.Application developers usually configure their connection pools to remain alive for a long time, which is more than the "idle session timeout" value of the firewall. Not all the connections in the pool are used. http://hemora.blogspot.com/2013/05/how-to-resolve-tns-12535-or-tns-00505.html Some stays idle. After sometime the firewall drops them and I get those operation timed out problems.Solution:Add the following line to the sqlnet.ora file on the server.SQLNET.EXPIRE_TIME=10In this configuration database will probe the application servers every 10 minutes to see if they are up. In fact this is a mechanism to determine stale connections by database. Because it sends packets to application servers every ten minutes, the connections are detected as active by firewalls and they are not broken. Posted by hemora at 11:47 Labels: LISTENER, Network, TNS 3 comments: Alum77 said... A great post.I had the same problem with an Oracle 12.1.0.10 and I have solved adding SQLNET.EXPIRE_TIME = 10 in the last line of file SQLNET.ORAThanks! 19 June 2015 at 07:59 Anonymous said... how to check firewall idle session timeout bcos I have same issue 15 July 2015 at 08:47 Kiquenet said... About odp.net ora-03113https://community.oracle.com/thread/3870860?start=0&tstart=0 17 December 2015 at 07:43 Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Your Cube Blogumulus by Roy Tanck and Amanda Fazani Total Pageviews Live Ping!! Visitors Tag 10g (3) 11.2 (3) 11g (10) 11i (1) 12c (1) 12g (1) 64bit (1) ADDM (4) adrci (1) AIX (1) AMM (1) Apex (2) Applications (1) Apps (
Fatal NI connect error 12547 [message #619535] Wed, 23 July 2014 04:30 Subbu19 Messages: 15Registered: July 2014 Location: Chennai Junior Member Hi, Following message occurs on alert.log file Fatal NI connect http://www.orafaq.com/forum/t/193730/ error 12547, connecting to: (LOCAL=NO) VERSION INFORMATION: TNS for 64-bit Windows: Version 11.2.0.3.0 https://jvortega.wordpress.com/2012/11/24/solving-elusive-problems-oracle-timeout/ - Production Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.3.0 - Production Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.3.0 - Production Time: 23-JUL-2014 04:18:15 Tracing not turned on. Tns error struct: ns main err code: 12547 TNS-12547: TNS:lost contact ns secondary err code: 12560 nt main fatal ni err code: 0 nt secondary err code: 0 nt OS err code: 0 opiodr aborting process unknown ospid (12900) as a result of ORA-609 Report message to a moderator Re: Fatal NI connect error 12547 [message #619544 is a reply to message #619535] Wed, 23 July 2014 05:11 Michel Cadot Messages: 63883Registered: March 2007 Location: Nanterre, France, http://... Senior MemberAccount Moderator fatal ni connect ORA-12547: TNS:lost contact *Cause: Partner has unexpectedly gone away, usually during process startup. *Action: Investigate partner application for abnormal termination. On an Interchange, this can happen if the machine is overloaded. Report message to a moderator Re: Fatal NI connect error 12547 [message #619548 is a reply to message #619544] Wed, 23 July 2014 05:53 Subbu19 Messages: 15Registered: July 2014 Location: Chennai Junior Member Hi Michel, Now i am getting a different error code from alert.log file Fatal NI connect error 12170. VERSION INFORMATION: TNS for 64-bit Windows: Version 11.2.0.3.0 - Production Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.3.0 - Production Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.3.0 - Production Time: 23-JUL-2014 05:24:17 Tracing not turned on. Tns error struct: ns main err code: 12535 TNS-12535: TNS:operation timed out ns secondary err code: 12606 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.122.161.90)(PORT=50611)) WARNING: inbound connection timed out (ORA-3136) Report message to a moderator Re: Fatal NI connect error 12547 [message #619556 is a reply to message #619548] Wed, 2
guide on how to approach hard to solve problems. The error causes the client application to timeout. There is no apparent pattern or specific time of day when its most likely to occur. The error: Fatal NI connect error 12170. VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.1.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production Time: 09-JUL-2012 22:12:23 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: 60 nt OS err code: 0 Client address: