OraFAQ Forum: Networking and Gateways » Fatal NI connect error 12170.

Home » RDBMS Server » Networking and Gateways » Fatal NI connect error 12170. (11g, 11.2.0.1, AIX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Fatal NI connect error 12170. [message #644247]

Mon, 02 November 2015 00:11

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: Fatal NI connect error 12170. [message #644259 is a reply to message #644256]

Mon, 02 November 2015 03:05

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

Report message to a moderator

Re: Fatal NI connect error 12170. [message #644262 is a reply to message #644259]

Mon, 02 November 2015 03:13

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

First check the first point I mentioned.

Report message to a moderator

Re: Fatal NI connect error 12170. [message #644296 is a reply to message #644262]

Mon, 02 November 2015 22:28

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

Report message to a moderator

Re: Fatal NI connect error 12170. [message #644303 is a reply to message #644296]

Tue, 03 November 2015 00:10

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 21:18:56 CST 2024