oracle11g报TNS-12537和ORA-609问题的解决

在CentOS5.5 x86_64上安装了Oracle11g,版本号为:11.2.0.1.0

但是,在其它客户端上使用sqlplus连接的时候需要等待很长时间才能连接上,有时候报超时的错误。

错误信息为:

***********************************************************************

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: 30-NOV-2011 14:28:10
  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 (29666) as a result of ORA-609
Wed Nov 30 14:36:24 2011

Oracle11g服务器数据库名为:lzf,全局名称为:lzf.dbainfo.net

监听listener.ora配置文件内容为:
[oracle@centos5 lzf]$ cat /u01/oracle/product/11.2/network/admin/listener.ora
# listener.ora Network Configuration File: /u01/oracle/product/11.2/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = centos5.5)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /u01/oracle

服务名称配置文件tnsnames.ora 内容为:

[oracle@centos5 lzf]$ cat /u01/oracle/product/11.2/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/oracle/product/11.2/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

LZF =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = centos5.5)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = lzf.dbainfo.net)
    )
  )

解决方法:

将/etc/resolv.conf配置文件中的nameserver注释。

[root@centos5 ~]# cat /etc/resolv.conf
search domain.org
#nameserver 192.168.1.1
#nameserver 8.8.8.8
  • 本文链接地址:http://www.dbainfo.net/oracle11g-tns-12537-and-ora-609-troubleshooting.htm
  • 本文为dbainfo个人原创,请在尊重作者劳动成果的前提下进行转载;
  • 转载务必注明原始出处 : Sybase数据库技术,数据库恢复专家
  • 对《oracle11g报TNS-12537和ORA-609问题的解决》有何疑问或见解,请在本文下方发表;
  • 对网站还有其他问题或建议,请提交在留言板,谢谢!
  • 目前还没有任何评论.
    :wink: :twisted: :roll: :oops: :mrgreen: :lol: :idea: :evil: :cry: :arrow: :?: :-| :-x :-o :-P :-D :-? :) :( :!: 8-O 8)