oracle 经常报Fatal NI connect error 12537,connecting to:和TNS-12537:TNS:connecti

tlg 2011-04-06 11:17:29
连接数据数据很慢,alert报大量的这样日志:
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: 05-APR-2011 22:10:00
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 (32106) as a result of ORA-609
Tue Apr 05 22:10:00 2011


***********************************************************************
这是一些系统文件:
[sshuser@database1 etc]$ cat resolv.conf
nameserver 61.139.2.69
search localdomain

[sshuser@database1 etc]$ cat hosts
192.168.10.54 database1.localdomain database1
127.0.0.1 localhost.localdomain localhost

# listener.ora Network Configuration File: /usrapp/oracleapp/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = kszxorcl)
(ORACLE_HOME = /usrapp/oracleapp/product/11.2.0/dbhome_1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = database1.localdomain)(PORT = 1521))
)
)

ADR_BASE_LISTENER = /usrapp/oracleapp


...全文
1765 4 打赏 收藏 转发到动态 举报
写回复
用AI写文章
4 条回复
切换为时间正序
请发表友善的回复…
发表回复
tlg 2011-04-06
  • 打赏
  • 举报
回复
[Quote=引用 3 楼 zftang 的回复:]
TNS-12537: TNS:connection closed
会话过多,造成连接关闭,

增加会话限制。。。
[/Quote]

数据库的连接数足够大(1000)。
不知道与操作系统的环境是否有关(红旗服务器3.0SP3)

[Quote=引用 2 楼 java3344520 的回复:]
好像是BUG,查看解决方法

http://tolywang.itpub.net/post/48/406624[/Quote]

也是个解决方法。但不知道不停报这种日志情况下,有多大的影响。

系统访问速度慢,不知道与它有关
秋雨飘落 2011-04-06
  • 打赏
  • 举报
回复
TNS-12537: TNS:connection closed
会话过多,造成连接关闭,

增加会话限制。。。
iqlife 2011-04-06
  • 打赏
  • 举报
回复
好像是BUG,查看解决方法

http://tolywang.itpub.net/post/48/406624
doer_ljy 2011-04-06
  • 打赏
  • 举报
回复
TNS-12537: TNS:connection closed
Cause: "End of file" condition has been reached; partner has disconnected.
Action: None needed; this is an information message.
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

17,377

社区成员

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

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