环境说明:
OS:CentOS 6.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
显示已完成监听的启动。
: