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