Home » RDBMS Server » Server Administration » Fatal NI connect error 12170. (ORACLE 11.2.0.3 2 nodes RAC soalris)
Fatal NI connect error 12170. [message #623271] Sun, 07 September 2014 12:28 Go to next message
janakors
Messages: 180
Registered: September 2009
Senior Member
hi
i used to get this error in my alert log some time and it is frequent like every two weeks or sometime after a month
 ***********************************************************************
Thu Sep 04 12:11:23 2014


***********************************************************************

Fatal NI connect error 12170.

  VERSION INFORMATION:
        TNS for Solaris: Version 11.2.0.3.0 - Production
        Oracle Bequeath NT Protocol Adapter for Solaris: Version 11.2.0.3.0 - Production
        TCP/IP NT Protocol Adapter for Solaris: Version 11.2.0.3.0 - Production

Fatal NI connect error 12170.
  Time: 04-SEP-2014 12:11:23
  Tracing not turned on.
  Tns error struct:

  VERSION INFORMATION:
        TNS for Solaris: Version 11.2.0.3.0 - Production
        Oracle Bequeath NT Protocol Adapter for Solaris: Version 11.2.0.3.0 - Production
        TCP/IP NT Protocol Adapter for Solaris: Version 11.2.0.3.0 - Production
    ns main err code: 12535

  Time: 04-SEP-2014 12:11:23
TNS-12535: TNS:operation timed out
  Tracing not turned on.
    ns secondary err code: 12560
    nt main err code: 505
  Tns error struct:

TNS-00505: Operation timed out
    ns main err code: 12535
    nt secondary err code: 145
    nt OS err code: 0

  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.x.xx.16)(PORT=111))
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: 145
    nt OS err code: 0
  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.xx.xx.16)(PORT=112)
Thu Sep 04 12:19:12 2014


***********************************************************************

Fatal NI connect error 12170.

  VERSION INFORMATION:
        TNS for Solaris: Version 11.2.0.3.0 - Production
        Oracle Bequeath NT Protocol Adapter for Solaris: Version 11.2.0.3.0 - Production
        TCP/IP NT Protocol Adapter for Solaris: Version 11.2.0.3.0 - Production
  Time: 04-SEP-2014 12:19:12
  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: 145
    nt OS err code: 0
  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.xx.xx.16)(PORT=113))

Thu Sep 04 12:28:13 2014


***********************************************************************

Fatal NI connect error 12170.

  VERSION INFORMATION:
        TNS for Solaris: Version 11.2.0.3.0 - Production
        Oracle Bequeath NT Protocol Adapter for Solaris: Version 11.2.0.3.0 - Production
        TCP/IP NT Protocol Adapter for Solaris: Version 11.2.0.3.0 - Production
  Time: 04-SEP-2014 12:28:13
  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: 145
    nt OS err code: 0


my listener is up at that time and see no reason may be at websphere side tehere some issue

Any suggestion, please
Re: Fatal NI connect error 12170. [message #623275 is a reply to message #623271] Sun, 07 September 2014 14:18 Go to previous message
BlackSwan
Messages: 26207
Registered: January 2009
Location: SoCal
Senior Member
The most common cause for TIMEOUT is a FireWall on or between client & DB Server
Previous Topic: Changing SGA parameter
Next Topic: ORA-16403: shut down in progress - remote connection is not permitted
Goto Forum:
  


Current Time: Mon Oct 22 21:55:17 CDT 2018