设为首页 加入收藏

TOP

监听启动报TNS-12537、TNS-12560错误
2015-12-15 22:17:54 来源: 作者: 【 】 浏览:2
Tags:监听 启动 TNS-12537 TNS-12560 错误

环境说明:


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


[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


显示已完成监听的启动。


】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇ASM磁盘空间的查看 下一篇MySQL显示操作控制小技巧

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: