wonder 发表于 2012-6-14 10:28:32

Fatal NI connect error 12170

告警日志里面经常报这样的错误:

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: 12-JUN-2012 12:28:09
  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=113.106.164.14)(PORT=49750))
Tue Jun 12 12:29:26 2012


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

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: 12-JUN-2012 12:29:26
  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=113.106.164.14)(PORT=49646))
Tue Jun 12 12:32:38 2012


***********************************************************************
                                   
尝试的解决方法:
在listener.ora里增加
INBOUND_CONNECT_TIMEOUT_EAGAODB=0
在里sqlnet.ora增加
SQLNET.INBOUND_CONNECT_TIMEOUT = 0

重启监听器:
lsnrctl reload

但依然报此错误,请问有什么解决办法吗?谢谢!

wzhihua 发表于 2014-12-22 18:18:47

遇到了同样的问题,设置了同样的参数,仍然不起作用。不知道各位老大有没有好的方法??
页: [1]
查看完整版本: Fatal NI connect error 12170