首页 / 数据库 / MySQL / 监听启动报TNS-12537、TNS-12560错误
环境说明:OS:CentOS 6.5DB:Oracle 11.2.0.3问题:数据库启动监听的时候,报如下错误:[oracle@localhost admin]$ lsnrctl startConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionStart Date 27-NOV-2015 08:44:40Uptime 0 days 0 hr. 0 min. 18 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /ora01/app/oracle/product/11.2.0/db_01/network/admin/listener.oraListener Log File /ora01/app/oracle/diag/tnslsnr/dbtest001/listener/alert/log.xmlListening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= )(PORT=1521)))TNS-12537: TNS:connection closedTNS-12560: TNS:protocol adapter errorTNS-00507: Connection closedLinux Error: 29: Illegal seek解决方法:1、修改计主机名,安装系统的时候默认的主机名为localhost,这个主机名进行解析的时候会出现很多诡异的问题,强烈建议大家记得修改主机名;2、修改/etc/hosts 的文件[root@localhost tmp]# cat /etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4::1 localhost localhost.localdomain localhost6 localhost6.localdomain6192.168.1.100 dbtest001 经过以上操作后,再次启动监听[oracle@dbtest001 ~]$ lsnrctl startLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 27-NOV-2015 09:21:55Copyright (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 - ProductionSystem parameter file is /ora01/app/oracle/product/11.2.0/db_01/network/admin/listener.oraLog messages written to /ora01/app/oracle/diag/tnslsnr/dbtest001/listener/alert/log.xmlListening 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 LISTENERVersion TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionStart Date 27-NOV-2015 09:21:55Uptime 0 days 0 hr. 0 min. 0 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /ora01/app/oracle/product/11.2.0/db_01/network/admin/listener.oraListener Log File /ora01/app/oracle/diag/tnslsnr/dbtest001/listener/alert/log.xmlListening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.100)(PORT=1521)))The listener supports no servicesThe command completed successfully显示已完成监听的启动。更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12本文永久更新链接地址