Fatal NI connect error 12170


Fatal NI connect error 12170.
 
  VERSION INFORMATION:
    TNS for Linux: Version 11.1.0.7.0 - Production
    Unix Domain Socket IPC NT Protocol Adaptor for Linux: Version 11.1.0.7.0 - Production
    Oracle Bequeath NT Protocol Adapter for Linux: Version 11.1.0.7.0 - Production
    TCP/IP NT Protocol Adapter for Linux: Version 11.1.0.7.0 - Production
  Time: 08-NOV-2011 13:57:10
  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=10.100.107.62)(PORT=52357))

查看mos,有幸发现关于该错误的相关文章
Fatal NI connect error 12170′, ‘TNS-12535: TNS:operation timed out’ Reported in 11g Alert Log [ID 1286376.1]
做了一些摘要,算是给自己做个记录,也给不能访问mos的朋友一个参考
1、适用范围
Oracle Net Services - Version: 11.1.0.6 to 11.2.0.2 - Release: 11.1 to 11.2
Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.2.0.2   [Release: 11.1 to 11.2]
Information in this document applies to any platform.
2、问题原因
These time out related messages are mostly informational in nature.  The messages indicate the specified client connection (identified by the 'Client address:' details) has experienced a time out.  The 'nt secondary err code' identifies the underlying network transport, such as (TCP/IP) timeout limits after a client has abnormally terminated the database connection.
 
The 'nt secondary err code' translates to underlying network transport timeouts for the following Operating Systems:
 
For the Solaris system: nt secondary err code: 145:
 
#define ETIMEDOUT 145 /* Connection timed out */
 
For the Linux operating system: nt secondary err code: 110
 
ETIMEDOUT 110 Connection timed out
 
For the HP-UX system: nt secondary err code: 238:
 
ETIMEDOUT 238 /* Connection timed out */
 
For Windows based platforms: nt secondary err code: 60 (which translates to Winsock Error: 10060)
 
Description:  A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
 
The reason the messages are written to the alert log is related to the use of the new 11g Automatic Diagnostic Repository (ADR) feature being enabled by default.

3、解决问题
To revert to Oracle Net Server tracing/logging, set following parameter in the server's sqlnet.ora :
 
DIAG_ADR_ENABLED = OFF
 
Also, to back out the ADR diag for the Listener component, set following parameter in the server's listener.ora:
 
DIAG_ADR_ENABLED_<listenername> = OFF
 
   - Where the <listenername> would be replaced with the actual name of the configured listener(s) in the listener.ora configuration file.  For example, if the listener name is 'LISTENER', the parameter would read:
 
DIAG_ADR_ENABLED_LISTENER = OFF
 
-Reload or restart the TNS Listener for the parameter change to take effect.

说明:这个问题是由于Automatic Diagnostic Repository中的 Oracle Net diagnostic在默认的情况下是开启的,当数据库和客户端的连接超过特定时间,就会把这样的信息写入到alert日志中,所以这不是一个致命的问题,如果偶尔出现,可以忽略有点类此ora-3136的错误


转自:http://blog.csdn.net/liqfyiyi/article/details/7176022 

Oracle日志中alert_orcl.log出现Fatal NI connect error 12170,如何破?

08-08

Fatal NI connect error 12170.rnrn VERSION INFORMATION:rn TNS for 64-bit Windows: Version 11.2.0.1.0 - Productionrn Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Productionrn Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Productionrn Time: 08-8月 -2017 08:36:50rn Tracing not turned on.rn Tns error struct:rn ns main err code: 12535rn rnTNS-12535: TNS: 操作超时rn ns secondary err code: 12560rn nt main err code: 505rn rnTNS-00505: 操作超时rn nt secondary err code: 60rn nt OS err code: 0rn Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=124.236.237.17)(PORT=49358))rnTue Aug 08 08:37:21 2017rnThread 1 cannot allocate new log, sequence 340646rnPrivate strand flush not completern Current log# 4 seq# 340645 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO04.LOGrnThread 1 advanced to log sequence 340646 (LGWR switch)rn Current log# 5 seq# 340646 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO05.LOGrnTue Aug 08 08:42:40 2017rnThread 1 cannot allocate new log, sequence 340647rnPrivate strand flush not completern Current log# 5 seq# 340646 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO05.LOGrnThread 1 advanced to log sequence 340647 (LGWR switch)rn Current log# 6 seq# 340647 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO06.LOGrnTue Aug 08 08:45:22 2017rnThread 1 cannot allocate new log, sequence 340648rnPrivate strand flush not completern Current log# 6 seq# 340647 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO06.LOGrnThread 1 advanced to log sequence 340648 (LGWR switch)rn Current log# 1 seq# 340648 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOGrnTue Aug 08 08:45:52 2017rnThread 1 advanced to log sequence 340649 (LGWR switch)rn Current log# 2 seq# 340649 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOGrnTue Aug 08 08:46:25 2017rnThread 1 cannot allocate new log, sequence 340650rnPrivate strand flush not completern Current log# 2 seq# 340649 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOGrnThread 1 advanced to log sequence 340650 (LGWR switch)rn Current log# 3 seq# 340650 mem# 0: E:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO03.LOGrn

数据库连接不稳定,出错Fatal NI connect error 12203

11-12

数据库服务器采用Oracle 10g,Windows 2003系统.rn应用程序运行在另外一台Oralce 8i 的数据库服务器上.应用程序通过insp连接字符串访问oracle 10g数据库服务器.rn应用程序用Pro*C写的程序以用户clengzha/clengzha@insp访问Oracle 10g数据库.但是程序启动并且运行OK,但是有时应用程序就莫名奇妙的退出.rn程序日志没有发现异常的地方.应用程序所在目录下有sqlnet.log如下:rn***********************************************************************rnFatal NI connect error 12203, connecting to:rn(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=S:\Common\BIN\test_alm.exe)(HOST=ONLINE)(USER=Administrator))))rnrnVERSION INFORMATION:rnTNS for 32-bit Windows: Version 8.0.5.0.0 - ProductionrnOracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.5.0.0 - ProductionrnTime: 12-NOV-07 11:07:51rnTracing not turned on.rnTns error struct:rnnr err code: 12203rnTNS-12203: TNS:unable to connect to destinationrnns main err code: 12560rnTNS-12560: TNSrotocol adapter errorrnns secondary err code: 0rnnt main err code: 530rnTNS-00530: Protocol adapter errorrnnt secondary err code: 0rnnt OS err code: 0rnrnrn***********************************************************************rnFatal NI connect error 12203, connecting to:rn(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=S:\Common\BIN\test_alm.exe)(HOST=ONLINE)(USER=Administrator))))rnrnVERSION INFORMATION:rnTNS for 32-bit Windows: Version 8.0.5.0.0 - ProductionrnOracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.5.0.0 - ProductionrnTime: 12-NOV-07 11:07:52rnTracing not turned on.rnTns error struct:rnnr err code: 12203rnTNS-12203: TNS:unable to connect to destinationrnns main err code: 12560rnTNS-12560: TNSrotocol adapter errorrnns secondary err code: 0rnnt main err code: 530rnTNS-00530: Protocol adapter errorrnnt secondary err code: 0rnnt OS err code: 0rnrnrn***********************************************************************rnFatal NI connect error 12203, connecting to:rn(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=S:\Common\BIN\tmr010.exe)(HOST=ONLINE)(USER=Administrator))))rnrnVERSION INFORMATION:rnTNS for 32-bit Windows: Version 8.0.5.0.0 - ProductionrnOracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.5.0.0 - ProductionrnTime: 12-NOV-07 11:07:54rnTracing not turned on.rnTns error struct:rnnr err code: 12203rnTNS-12203: TNS:unable to connect to destinationrnns main err code: 12560rnTNS-12560: TNSrotocol adapter errorrnns secondary err code: 0rnnt main err code: 530rnTNS-00530: Protocol adapter errorrnnt secondary err code: 0rnnt OS err code: 0rnrnrn***********************************************************************rnFatal NI connect error 12203, connecting to:rn(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=S:\Common\BIN\tmr010.exe)(HOST=ONLINE)(USER=Administrator))))rnrnVERSION INFORMATION:rnTNS for 32-bit Windows: Version 8.0.5.0.0 - ProductionrnOracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.5.0.0 - ProductionrnTime: 12-NOV-07 11:07:54rnTracing not turned on.rnTns error struct:rnnr err code: 12203rnTNS-12203: TNS:unable to connect to destinationrnns main err code: 12560rnTNS-12560: TNSrotocol adapter errorrnns secondary err code: 0rnnt main err code: 530rnTNS-00530: Protocol adapter errorrnnt secondary err code: 0rnnt OS err code: 0rnrnrn***********************************************************************rnFatal NI connect error 12203, connecting to:rn(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=S:\Common\BIN\tmr010.exe)(HOST=ONLINE)(USER=Administrator))))rnrnVERSION INFORMATION:rnTNS for 32-bit Windows: Version 8.0.5.0.0 - ProductionrnOracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.5.0.0 - ProductionrnTime: 12-NOV-07 11:07:54rnTracing not turned on.rnTns error struct:rnnr err code: 12203rnTNS-12203: TNS:unable to connect to destinationrnns main err code: 12560rnTNS-12560: TNSrotocol adapter errorrnns secondary err code: 0rnnt main err code: 530rnTNS-00530: Protocol adapter errorrnnt secondary err code: 0rnnt OS err code: 0rnrnrn******************************************************************************************************************************************************************************rntnsname.ora配置如下:rn# D:\ORANT\NET80\ADMIN\TNSNAMES.ORA Configuration File:\orant\net80\admin\tnsnames.orarn# Generated by Oracle Net8 AssistantrnrnINSP3.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=168.60.1.169)(PORT=1521))(CONNECT_DATA=(SID=insp)))rnrnCMEXAMPLE.WORLD=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=CM_SERVER)(PORT=1610))(ADDRESS=(PROTOCOL=TCP)(HOST=LSNR_SERVER)(PORT=1521)))(CONNECT_DATA=(SID=ORCL))(SOURCE_ROUTE=YES))rnrnTCPEXAMPLE.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Production1)(PORT=1521))(CONNECT_DATA=(SID=ORCL)))rnrnINSPT.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=online)(PORT=1521))(CONNECT_DATA=(SID=INSP)))rnrnNMPEXAMPLE.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(CONNECT_DATA=(SID=INSP)))rnrnEXTPROC_CONNECTION_DATA.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(Key=EXTPROC0))(CONNECT_DATA=(SID=extproc)))rnrnBEQ-LOCAL.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))'))(CONNECT_DATA=(SID=ORCL)))rnrnINSP.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.1.1.4)(PORT=1521))(CONNECT_DATA=(SID=JHY)))rnrnSPXEXAMPLE.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=SPX)(Service=Server_lsnr))(CONNECT_DATA=(SID=ORCL)))rnrnTCP-LOOPBACK.WORLD=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(CONNECT_DATA=(SID=ORCL)))rnrnrn请各位大侠帮帮忙.rnrn

oracle Fatal NI connect error 12170 最近服务投然链接不上,过上一分钟就好了

09-12

Fatal NI connect error 12170.rnrn VERSION INFORMATION:rn TNS for 64-bit Windows: Version 11.2.0.4.0 - Productionrn Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Productionrn Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Productionrn Time: 12-9月 -2017 18:43:35rn Tracing not turned on.rn Tns error struct:rn ns main err code: 12535rn rnTNS-12535: TNS: 操作超时rn ns secondary err code: 12606rn nt main err code: 0rn nt secondary err code: 0rn nt OS err code: 0rn Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.77.76.20)(PORT=56160))rnrnFatal NI connect error 12170.rnrn VERSION INFORMATION:rn TNS for 64-bit Windows: Version 11.2.0.4.0 - Productionrn Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Productionrn Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Productionrn Time: 12-9月 -2017 18:43:36rn Tracing not turned on.rn Tns error struct:rn ns main err code: 12535rn rnTNS-12535: TNS: 操作超时rn ns secondary err code: 12606rn nt main err code: 0rn nt secondary err code: 0rn nt OS err code: 0rn Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.77.76.20)(PORT=56153))rnrnFatal NI connect error 12170.rnrn VERSION INFORMATION:rn TNS for 64-bit Windows: Version 11.2.0.4.0 - Productionrn Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Productionrn Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Productionrn Time: 12-9月 -2017 18:43:36rn Tracing not turned on.rn Tns error struct:rn ns main err code: 12535rn rnTNS-12535: TNS: 操作超时rn ns secondary err code: 12606rn nt main err code: 0rn nt secondary err code: 0rn nt OS err code: 0rn Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.77.76.20)(PORT=56152))

没有更多推荐了,返回首页

私密
私密原因:
请选择设置私密原因
  • 广告
  • 抄袭
  • 版权
  • 政治
  • 色情
  • 无意义
  • 其他
其他原因:
120
出错啦
系统繁忙,请稍后再试