数据库监听启动失败

发布时间:  2014-05-13 浏览次数:  175 下载次数:  0
问题描述
数据库软件启动正常,远程无法进行连接;登陆到数据库服务器查看发现监听没有启动。
告警信息
手动启动监听 lsnrctl start,报如下错误:
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE))) 
TNS-12541: TNS:no listener 
TNS-12560: TNS:protocol adapter error 
  TNS-00511: No listener 
   Linux Error: 111: Connection refused  
处理过程
在hosts文件中把127.0.0.1这一行加上,然后lsnrctl start,可以确认lsnrct启动正常  ;
Starting /oracle/app/product/11g/db/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.3.0 - Production
System parameter file is /oracle/app/product/11g/db/network/admin/listener.ora
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.159.240.54)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                13-MAY-2014 11:28:02
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/app/product/11g/db/network/admin/listener.ora
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.159.240.54)(PORT=1521)))
Services Summary...
Service "ora11g" has 1 instance(s).
  Instance "ora11g", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
根因
经过百度发现这个问题和IP有关系,之前在测试把/etc/hosts里的这一行:127.0.0.1       localhost.localdomain   localhost  删掉了
建议与总结
数据库服务器上面的相关信息不要随意改动,否则会影响数据库的正确运行

END