监听启动报TNS-12537、TNS-12560错误

环境说明：

OS：Centos6.5

DB：Oracle  11.2.0.3

 

问题：数据库启动监听的时候，报如下错误：

[oracle@localhost admin]$ lsnrctl start

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production

Start Date                27-NOV-2015 08:44:40

Uptime                    0 days 0 hr. 0 min. 18 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /ora01/app/oracle/product/11.2.0/db_01/network/admin/listener.ora

Listener Log File         /ora01/app/oracle/diag/tnslsnr/dbtest001/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= )(PORT=1521)))

TNS-12537: TNS:connection closed

TNS-12560: TNS:protocol adapter error

TNS-00507: Connection closed

Linux Error: 29: Illegal seek

 

解决方法：

1、修改计主机名，安装系统的时候默认的主机名为localhost，这个主机名进行解析的时候会出现很多诡异的问题，强烈建议大家记得修改主机名；

2、修改/etc/hosts 的文件

[root@localhost tmp]# cat /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.1.100 dbtest001   

 

经过以上操作后，再次启动监听

 

[oracle@dbtest001 ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 27-NOV-2015 09:21:55

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Starting /ora01/app/oracle/product/11.2.0/db_01/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production

System parameter file is /ora01/app/oracle/product/11.2.0/db_01/network/admin/listener.ora

Log messages written to /ora01/app/oracle/diag/tnslsnr/dbtest001/listener/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.26)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production

Start Date                27-NOV-2015 09:21:55

Uptime                    0 days 0 hr. 0 min. 0 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /ora01/app/oracle/product/11.2.0/db_01/network/admin/listener.ora

Listener Log File         /ora01/app/oracle/diag/tnslsnr/dbtest001/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.100)(PORT=1521)))

The listener supports no services

The command completed successfully

 

显示已完成监听的启动。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12679300/viewspace-1847655/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12679300/viewspace-1847655/