gehuiyu1 发表于 2012-5-29 12:44:55

alert.log中出现Fatal NI connect error 12170

数据库版本： 11.2.0.1.0
操作系统：IBM/AIX RISC System/6000

在alert.log中出现以下错误
Fatal NI connect error 12170.

VERSION INFORMATION:
      TNS for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production
      TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production
      Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production
Time: 29-MAY-2012 07:30:05
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.44.9.136)(PORT=53091))
WARNING: inbound connection timed out (ORA-3136)
Tue May 29 07:32:23 2012

同时，在listener.log中出现
29-MAY-2012 12:10:38 * (CONNECT_DATA=(SERVICE_NAME=gdtjjora)(CID=(PROGRAM=C:\Program Files\PLSQL Developer\plsqldev.exe)(HOST=DELL-PC)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.4.103.104)(PORT=53950)) * establish * gdtjjora * 0
29-MAY-2012 12:10:40 * service_update * gdtjjora * 0
Tue May 29 12:10:46 2012
29-MAY-2012 12:10:46 * service_update * gdtjjora * 0


因为监听无响应，所以才在alert.log中出现报错。 这种无响应是经常出现，但不是连续出现。
这个错误如果解决呢？

oraunix 发表于 2012-11-5 15:50:27

可以做一下下面的操作
增大 sqlnet.ora 中的参数：
SQLNET.INBOUND_CONNECT_TIMEOUT = 30
SQLNET.RECV_TIMEOUT = 30
SQLNET.SEND_TIMEOUT = 30

在 listener.ora 增加：
INBOUND_CONNECT_TIMEOUT_LISTENER = 30

重启监听器：
lsnrctl reload

super712 发表于 2014-3-6 16:48:25

oraunix 发表于 2012-11-5 15:50 static/image/common/back.gif
可以做一下下面的操作
增大 sqlnet.ora 中的参数：
SQLNET.INBOUND_CONNECT_TIMEOUT = 30


按照上面配置后还是报错：
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: 06-3月 -2014 15:42:04
Tracing not turned on.
Tns error struct:
    ns main err code: 12535
   
TNS-12535: TNS: 操作超时
    ns secondary err code: 12560
    nt main err code: 505
   
TNS-00505: 操作超时
    nt secondary err code: 60
    nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=29.6.101.100)(PORT=1521))
Thu Mar 06 16:22:23 2014
Errors in file c:\app\oracle\diag\rdbms\orcl\orcl\trace\orcl_reco_7124.trc:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ORA-02063: preceding line from YLCW
页: [1]
查看完整版本: alert.log中出现Fatal NI connect error 12170