Home » RDBMS Server » Networking and Gateways » Fatal NI connect error 12170. (11g, 11.2.0.1, AIX)
Fatal NI connect error 12170. [message #644247] Mon, 02 November 2015 00:11 Go to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear All,

Production database doesn't have neither DR not Logical database.

Even after that, below error is populating on alert log of Production Database.

Note: -Ip 172.18.5.125 >> belong to local system in which pl/sql developer is connected to production database.

Fatal NI connect error 12170.

  VERSION INFORMATION:
	    TNS for Linux: Version 11.2.0.1.0 - Production
	    Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
	    TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
  Time: 31-OCT-2015 14:33:24
  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=172.18.5.125)(PORT=52382))


Please let us know, why this error is appearing on alert log??

Regards,
Ashish Kumar Mahanta

[Updated on: Mon, 02 November 2015 00:14]

Report message to a moderator

Re: Fatal NI connect error 12170. [message #644256 is a reply to message #644247] Mon, 02 November 2015 01:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68257
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Most often this error comes from a firewall between the client and the server.
Otherwise it means you have a network problem.

Re: Fatal NI connect error 12170. [message #644259 is a reply to message #644256] Mon, 02 November 2015 03:05 Go to previous messageGo to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear Michel,

This production database always shows error in alert log.
With multiple ip's, mostly with the local developers system. Should I ask network team to check this error?


Regards,
Ashish Kumar Mahanta
Re: Fatal NI connect error 12170. [message #644262 is a reply to message #644259] Mon, 02 November 2015 03:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68257
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

First check the first point I mentioned.

Re: Fatal NI connect error 12170. [message #644296 is a reply to message #644262] Mon, 02 November 2015 22:28 Go to previous messageGo to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear Michel,

Network team has to check the firewall issue. I will ask them to check.
If I can check from database server side then please guide me.

Regards,
Ashish
Re: Fatal NI connect error 12170. [message #644303 is a reply to message #644296] Tue, 03 November 2015 00:10 Go to previous message
Michel Cadot
Messages: 68257
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Wait for the answer from the other team their answer will guide you.

Previous Topic: 12.1 to 9.2 database link
Next Topic: Fatal NI connect error 12547
Goto Forum:
  


Current Time: Wed Aug 10 03:10:15 CDT 2022