[转帖]监听故障TNS-12537: TNS:connection closed 解决对策_MySQL, Oracle及数据库讨论区_Weblogic技术|Tuxedo技术|中间件技术|Oracle论坛|JAVA论坛|Linux/Unix技术|hadoop论坛

总帖数

每页帖数

1/1页

返回列表

发起投票

查看: 4954 | 回复: 1

主题： [转帖]监听故障TNS-12537: TNS:connection closed 解决对策

无糖板蓝根

注册用户

等级：新兵
经验：71
发帖：1
精华：0
注册：2016-12-27
状态：离线
发送短消息息给无糖板蓝根

加好友发送短消息息给无糖板蓝根

发消息

发表于：

2019-9-20 10:36:47 | [全部帖] [楼主帖]

楼主

一组的同事找我说，有很多应用不能连接数据库，让我去帮忙看看，一开始以为是process 和session 数不构，去了查了一下，发现远没到设置的数，且主机未发现有性能问题，查看等待事件，全是军空闲类的，这下我就有点朦了，后来查看监听状态，执行lsnrctl status 后出来两行字之后卡在那儿了，没有反应，所以kill掉进程后重启监听，重启后，没有服务注册时正常，过1分种在查看监听状态，还是卡在那儿了，查看监听日志没什么收获，后来查看数据库alter日志，发现如下：

Fatal NI connect error 12537, connecting to:
(LOCAL=NO)
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: 03-NOV-2014 09:44:15
Tracing not turned on.
Tns error struct:
ns main err code: 12537
TNS-12537: TNS:connection closed
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (3657) as a result of ORA-609
Mon Nov 03 09:44:22 2014
***********************************************************************
Fatal NI connect error 12537, connecting to:
(LOCAL=NO)
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: 03-NOV-2014 09:44:22
Tracing not turned on.
Tns error struct:
ns main err code: 12537
TNS-12537: TNS:connection closed
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (3666) as a result of ORA-609
Mon Nov 03 09:44:26 2014
***********************************************************************
Fatal NI connect error 12537, connecting to:
(LOCAL=NO)
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: 03-NOV-2014 09:44:26
Tracing not turned on.
Tns error struct:
ns main err code: 12537
TNS-12537: TNS:connection closed
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (3670) as a result of ORA-609
Mon Nov 03 09:44:27 2014
***********************************************************************
Fatal NI connect error 12537, connecting to:
(LOCAL=NO)
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: 03-NOV-2014 09:44:27
Tracing not turned on.
Tns error struct:
ns main err code: 12537
TNS-12537: TNS:connection closed
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (3695) as a result of ORA-609

上网查了一下，有人说是DNS解析问题，按照解决方法注释DNS 的解析后工作正常，上网查了很多，没有发现具体原因。

解决方法

注释掉 /etc/resolve.conf 配置文件中对 DNS 的解析解决

本版精华
热门帖子

操作引用/回复

联动大白

注册用户

等级：列兵
经验：91
发帖：0
精华：0
注册：2015-5-27
状态：离线
发送短消息息给联动大白

加好友发送短消息息给联动大白

发消息

发表于：

2019-12-8 0:30:00 | [全部帖] [楼主帖]

2 楼

为了方便大家阅读，我对文章中错误号来解释一下吧！

Error Id: TNS-12537

Title: TNS:connection closed

Description:

TNS:connection closed

Action:

None needed; this is an information message.

Cause:

"End of file" condition has been reached; partner has disconnected.

也许你已明白，但对一个人有用也是我存在的理由！^_^ By:持之以恒的大白

-- 来自：

操作引用/回复

总帖数

每页帖数

1/1页

返回列表

用户登录

Weblogic中间件技术论坛

Tuxedo中间件技术论坛

数据库论坛

Java论坛

Linux/unix论坛

网站地图