ITPub博客

首页 > 数据库 > Oracle > 监听启动报TNS-12537、TNS-12560错误

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

原创 Oracle 作者:wzq609 时间:2015-11-27 09:46:27 0 删除 编辑

环境说明:

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博客 ” ,链接:https://blog.itpub.net/12679300/viewspace-1847655/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2013-06-16

  • 博文量
    173
  • 访问量
    3083836