昨天晚上,一个兄弟报告不能通过SQLPLUS连接到服务器,在连接的时候SQLPLUS没有反应。
服务器环境:AIX 5300-09, ora10.2.0.1
查看sqlnet.log
Fatal NI connect error 12547, connecting to:
(LOCAL=NO)
VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production
Time: 13-APR-2009 23:07:27
Tracing not turned on.
Tns error struct:
ns main err code: 12547
TNS-12547: TNS:lost contact
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
nt OS err code: 0
nt OS err code: 0
nt OS err code: 0
nt OS err code: 0
nt OS err code: 0
nt OS err code: 0
nt OS err code: 0
nt OS err code: 0
nt OS err code: 0
查看listener.log
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
IBM/AIX RISC System/6000 Error: 72: Software caused connection abort
在网上查到该问题属于一个Oracle的一个BUG
http://www.itpub.net/506143.html (感谢ZALBB )
解决方法:打补丁4518443 或者在listener.ora 文件里加入:
SUBSCRIBE_FOR_NODE_DOWN_EVENT_
其中,
默认情况下,监听器名为:LISTENER 。则语句就是:
SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF