主页 / dba / 问题 / 72317
Accepted
xenoterracide
Asked: 2014-07-25 12:43:47 +0800 CST

重新启动侦听器不会启动，但重新启动服务后将启动它们

  • 772

当我重新启动 ubuntu 时，侦听器服务出现，但似乎没有任何侦听器

lsnrctl status

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 24-JUL-2014 15:34:43

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dex-ci.escalation-point.com)(PORT=1522)))
 STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date                24-JUL-2014 15:33:58
Uptime                    0 days 0 hr. 0 min. 44 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           XE
Listener Parameter File   /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/ip-10-113-43-249/listener/alert/log.xml
Listening Endpoints Summary...
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1522)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
The listener supports no services
The command completed successfully

之后/etc/init.d/oracle-xe restart

 lsnrctl status | sed -e 's/^/     /'

 LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 24-JUL-2014 15:42:15

 Copyright (c) 1991, 2011, Oracle.  All rights reserved.

 Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dex-ci.escalation-point.com)(PORT=1522)))
 STATUS of the LISTENER
 ------------------------
 Alias                     LISTENER
 Version                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production
 Start Date                24-JUL-2014 15:41:24
 Uptime                    0 days 0 hr. 0 min. 50 sec
 Trace Level               off
 Security                  ON: Local OS Authentication
 SNMP                      OFF
 Default Service           XE
 Listener Parameter File   /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
 Listener Log File         /u01/app/oracle/diag/tnslsnr/dex-ci/listener/alert/log.xml
 Listening Endpoints Summary...
   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1522)))
   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=8888))(Presentation=HTTP)(Session=RAW))
 Services Summary...
 Service "XE" has 1 instance(s).
   Instance "XE", status READY, has 1 handler(s) for this service...
 Service "XEXDB" has 1 instance(s).
   Instance "XE", status READY, has 1 handler(s) for this service...
 The command completed successfully

这告诉我的是我的配置很好，所以它正在启动，也许是一个竞争条件......我查看了日志，但找不到任何有趣的东西。什么样的事情会导致这些服务无法重新启动？

oracle oracle-11g-r2

1 个回答

  1. Best Answer

    这是主机名在启动时未得到一致设置的问题，当时无法正确使用，但后来出现了。

    • 1

相关问题