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

私念醉美 2017-09-12 07:28:39
Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Production
Time: 12-9月 -2017 18:43:35
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS: 操作超时
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.77.76.20)(PORT=56160))

Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Production
Time: 12-9月 -2017 18:43:36
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS: 操作超时
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.77.76.20)(PORT=56153))

Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Production
Time: 12-9月 -2017 18:43:36
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS: 操作超时
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.77.76.20)(PORT=56152))
...全文
486 5 打赏 收藏 转发到动态 举报
写回复
用AI写文章
5 条回复
切换为时间正序
请发表友善的回复…
发表回复
qq_33507131 2017-09-14
  • 打赏
  • 举报
 回复 1
这个链接不错，针对你现在这个问题，讲解的非常清楚，并且提供了两种解决措施 http://www.linuxidc.com/Linux/2015-05/118004.htm
私念醉美 2017-09-14
  • 打赏
  • 举报
 回复
引用 1 楼 minsic78 的回复:
这问题可能会很复杂，如果不是单纯的网络原因，而是数据库的问题的话，建议在突然连接到不服务的时候，登录到数据库服务器，查下当时的等待事件概况，也许还能从等待事件中瞧出点端倪。简单点的，比如： select event,count(*) from gv$session group by event order by 2 desc;
心累，服务部署在IIS上win server 2008r2 使用了一个多月没有任何问题。突然就感觉间歇性链接不上数据库。造成iis程序池假死。回收就好了。
私念醉美 2017-09-14
  • 打赏
  • 举报
 回复
引用 4 楼 qq_33507131 的回复:
这个链接不错，针对你现在这个问题，讲解的非常清楚，并且提供了两种解决措施 http://www.linuxidc.com/Linux/2015-05/118004.htm
这个帖子看了，添加只是关闭了alter日志记录没有解决实际问题 ，数据库用的是连接池的形式链接的。
minsic78 2017-09-13
  • 打赏
  • 举报
 回复
这问题可能会很复杂，如果不是单纯的网络原因，而是数据库的问题的话，建议在突然连接到不服务的时候，登录到数据库服务器，查下当时的等待事件概况，也许还能从等待事件中瞧出点端倪。简单点的，比如： select event,count(*) from gv$session group by event order by 2 desc;
ora10g客户端
ora10g客户端 *********************************************************************** Fatal NI connect error 12560, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=D:\oracle\ora10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.5.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Time: 17-SEP-2011 12:24:11 Tracing not turned on. Tns error struct: ns main err code: 12560 TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS ns secondary err code: 0 nt main err code: 530 TNS-00530: Message 530 not found; No message file for product=NETWORK, facility=TNS nt secondary err code: 126 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12560, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=D:\oracle\ora10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.5.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Time: 17-SEP-2011 12:24:12 Tracing not turned on. Tns error struct: ns main err code: 12560 TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS ns secondary err code: 0 nt main err code: 530 TNS-00530: Message 530 not found; No message file for product=NETWORK, facility=TNS nt secondary err code: 126 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12560, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=D:\oracle\ora10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.5.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Time: 18-SEP-2011 10:22:30 Tracing not turned on. Tns error struct: ns main err code: 12560 TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS ns secondary err code: 0 nt main err code: 530 TNS-00530: Message 530 not found; No message file for product=NETWORK, facility=TNS nt secondary err code: 126 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12560, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=D:\oracle\ora10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.5.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Time: 19-SEP-2011 10:20:57 Tracing not turned on. Tns error struct: ns main err code: 12560 TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS ns secondary err code: 0 nt main err code: 530 TNS-00530: Message 530 not found; No message file for product=NETWORK, facility=TNS nt secondary err code: 126 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12560, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=D:\oracle\ora10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.5.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Time: 20-SEP-2011 10:27:04 Tracing not turned on. Tns error struct: ns main err code: 12560 TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS ns secondary err code: 0 nt main err code: 530 TNS-00530: Message 530 not found; No message file for product=NETWORK, facility=TNS nt secondary err code: 126 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12560, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=D:\oracle\ora10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.5.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Time: 20-SEP-2011 11:50:33 Tracing not turned on. Tns error struct: ns main err code: 12560 TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS ns secondary err code: 0 nt main err code: 530 TNS-00530: Message 530 not found; No message file for product=NETWORK, facility=TNS nt secondary err code: 126 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12505, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.200)(PORT=1521))(CONNECT_DATA=(SID=dba)(CID=(PROGRAM=D:\oracle\ora10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.5.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Time: 27-OCT-2011 22:03:49 Tracing not turned on. Tns error struct: ns main err code: 12564 TNS-12564: Message 12564 not found; No message file for product=NETWORK, facility=TNS ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12505, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.200)(PORT=1521))(CONNECT_DATA=(SID=dba)(CID=(PROGRAM=D:\oracle\ora10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.5.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Time: 27-OCT-2011 22:04:07 Tracing not turned on. Tns error struct: ns main err code: 12564 TNS-12564: Message 12564 not found; No message file for product=NETWORK, facility=TNS ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12505, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.200)(PORT=1521))(CONNECT_DATA=(SID=dba)(CID=(PROGRAM=D:\oracle\ora10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.5.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Time: 29-OCT-2011 11:57:00 Tracing not turned on. Tns error struct: ns main err code: 12564 TNS-12564: Message 12564 not found; No message file for product=NETWORK, facility=TNS ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12560, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=D:\oracle\ora10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.5.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Time: 29-OCT-2011 11:57:30 Tracing not turned on. Tns error struct: ns main err code: 12560 TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS ns secondary err code: 0 nt main err code: 530 TNS-00530: Message 530 not found; No message file for product=NETWORK, facility=TNS nt secondary err code: 126 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12560, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=D:\oracle\ora10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.5.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Time: 29-OCT-2011 11:59:39 Tracing not turned on. Tns error struct: ns main err code: 12560 TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS ns secondary err code: 0 nt main err code: 530 TNS-00530: Message 530 not found; No message file for product=NETWORK, facility=TNS nt secondary err code: 126 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12560, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=D:\oracle\ora10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.5.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Time: 29-OCT-2011 11:59:43 Tracing not turned on. Tns error struct: ns main err code: 12560 TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS ns secondary err code: 0 nt main err code: 530 TNS-00530: Message 530 not found; No message file for product=NETWORK, facility=TNS nt secondary err code: 126 nt OS err code: 0
TNS-12541: TNS: 无监听程序 TNS-12560
TNS-12541: TNS: 无监听程序 TNS-12560: TNS: 协议适配器错误 TNS-00511: 无监听程序 文章转自：http://www.luocs.com/archives/464.html 此文版权归作者 – yaogang所有，转载请注明yaogang©www.luocs.com。 Luocs说：这是我一个朋友的一个监听器问题解决案例，这是昨天发生的事情，我一直跟朋友一起Troubleshooting，折腾了半天最后是BUG所致。再次汗颜，Windows平台惹不起啊！好，那么下面开始分享我朋友的案例！ 环境描述： OS : Windows Server 2008 64Bit (做了HA) DB : 11.1.0.7.0 排错过程： 前天应用不能访问数据库了 (后台应用能访问数据库)，故障发生。 马上登录到服务器里查看监听状态,发现有TNS-12541 ，TNS-12560等错误 Luocs补充：我跟朋友要了错误代码，但他没有保存，就直接贴图。 从计算器的管理 –> 服务选项 –> 检查oracle 监听服务程序，发现该服务已经停止。 手动把监听服务启动，这时候服务状态上显示为已启动，但在CMD窗口执行lsnrctl status的时候依然返回错误信息： C:\>lsnrctl status LSNRCTL for 64-bit Windows: Version 11.1.0.7.0 - Production on 12-11月-2012 18:1 8:32 Copyright (c) 1991, 2008, Oracle. All rights reserved. 正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.203.218)(PORT=1521))) TNS-12541: TNS: 无监听程序 TNS-12560: TNS: 协议适配器错误 TNS-00511: 无监听程序 64-bit Windows Error: 61: Unknown error 正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) 过段时间回显非常慢。 然后我检查了下告警日志，大量的ora错误 Fatal NI connect error 12170. VERSION INFORMATION: TNS for 64-bit Windows: Version 11.1.0.7.0 - Production Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.1.0.7.0 - Production Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.1.0.7.0 - Production Time: 12-11月-2012 15:23:33 Tracing not turned on. Tns error struct: ns main err code: 12535 TNS-12535: TNS: 操作超时 ns secondary err code: 12560 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 Client address: ORA-609 : opiodr aborting process unknown ospid (4116_6104) 这时候朋友怀疑是不是监听器配置问题，就把原先的监听器删除重建了下，问题依然。 网上有个解决TNS-12535错误的案例，平台和版本都很类似，如下： 1、在 sqlnet.ora文件中 增加如下行: DIAG_ADR_ENABLED = OFF 2、在listener.ora文件中增加如下行: DIAG_ADR_ENABLED_ = OFF 如何监听是listener时,则前面的名称为:DIAG_ADR_ENABLED_LISTENER = OFF 3、重新启动windows服务管理中的监听程序.先停止,然后再重新启动. 4、检查结果.发现可以了,返回的值在10毫秒.有时为0毫秒.成功!! 但这并不是问题发生原因，在继续排查过程中偶然发现监听日志大小居然为4G。然后把这现象告诉了Luocs。 过了一会儿，Luocs回应是
重庆思庄oracle技术分享-Fatal NI connect error 12170的解决方案
重庆思庄oracle技术分享-Fatal NI connect error 12170的解决方案
Fatal NI connect error 12170的解决方案
导读 作者：杨漆 16年关系型数据库管理，从oracle 9i 、10g、11g、12c到Mysql5.5、5.6、5.7、8.0 到TiDB获得3个OCP、2个OCM；运维路上不平坦，跌过不少坑、熬过许多夜。把工作笔记整理出来分享给大伙儿，希望帮到大家少走弯路、少熬夜。 Fatal NI connect error 12170. VERSION INFORMATION: TNS for Linux: Version 12.2.0.1.0 - Production Oracle Bequeath NT
Fatal NI connect error 12170错误解决办法
近日，在查看数据库告警日志时都发现有连续报以下错误信息： Fatal NI connect error 12170. VERSION INFORMATION: TNS for Linux: Version 11.2.0.4.0 - Production Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production TCP/IP NT Protocol Adapter for Linux: Version 1
基础和管理

17,377

社区成员

95,128

社区内容

发帖
与我相关
我的任务
社区描述
Oracle 基础和管理
社区管理员
  • 基础和管理社区
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章