ORACLE启动监听出现The listener supports no services

解决方案有以下几种:

第一种.

通过重启服务器,来修复监听器.

登陆数据库,

sqlplus / as sysdba;

SQL>shudown

SQL>startup

#startup  启动

#shutdown 关闭

#lsnrctl stop 关闭服务后,执行关闭监听器

#lsnrctl start 然后再启动监听器.

退出命令行,查看监听器状态

lsnrctl stat

LSNRCTL for Linux: Version 10.2.0.1.0 – Production on 17-7月 -2010 18:51:36

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

STATUS of the LISTENER

————————

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 10.2.0.1.0 – Production

Start Date                17-7月 -2010 10:51:00

Uptime                    0 days 8 hr. 0 min. 36 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Log File         /oracle/product/10.2.0/network/log/listener.log

Listening Endpoints Summary…

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))

Services Summary…

Service “oracle” has 1 instance(s).

Instance “oracle”, status READY, has 1 handler(s) for this service…

Service “oracleXDB” has 1 instance(s).

Instance “oracle”, status READY, has 1 handler(s) for this service…

Service “oracle_XPT” has 1 instance(s).

Instance “oracle”, status READY, has 1 handler(s) for this service…

The command completed successfully

第二种.

修改LISTENER.ORA与TNSNAME.ORA 文件.

# listener.ora Network Configuration File: oracle/oracle/network/admin/listener.ora

# tnsnames.ora Network Configuration File: /oracle/oraclenetwork/admin/tnsnames.ora

LISTENER.ORA:

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = oracle)

(ORACLE_HOME = oracle/oracle)

(PROGRAM = extproc)

)

)

TNSNAME.ORA:

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))

)

)

BOBJECMS =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = oracle)

)

)

oracle =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = oracle)

)

)

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

)

(CONNECT_DATA =

(SID = oracle)

(PRESENTATION = RO)

)

)

解决方案有以下几种:
第一种.通过重启服务器,来修复监听器.
登陆数据库,sqlplus / as sysdba;SQL>shudownSQL>startup
#startup  启动#shutdown 关闭#lsnrctl stop 关闭服务后,执行关闭监听器#lsnrctl start 然后再启动监听器.
退出命令行,查看监听器状态lsnrctl stat
LSNRCTL for Linux: Version 10.2.0.1.0 – Production on 17-7月 -2010 18:51:36
Copyright (c) 1991, 2005, Oracle.  All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))STATUS of the LISTENER————————Alias                     LISTENERVersion                   TNSLSNR for Linux: Version 10.2.0.1.0 – ProductionStart Date                17-7月 -2010 10:51:00Uptime                    0 days 8 hr. 0 min. 36 secTrace Level               offSecurity                  ON: Local OS AuthenticationSNMP                      OFFListener Log File         /oracle/product/10.2.0/network/log/listener.logListening Endpoints Summary…  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))Services Summary…Service “oracle” has 1 instance(s).  Instance “oracle”, status READY, has 1 handler(s) for this service…Service “oracleXDB” has 1 instance(s).  Instance “oracle”, status READY, has 1 handler(s) for this service…Service “oracle_XPT” has 1 instance(s).  Instance “oracle”, status READY, has 1 handler(s) for this service…The command completed successfully

第二种.修改LISTENER.ORA与TNSNAME.ORA 文件.
# listener.ora Network Configuration File: oracle/oracle/network/admin/listener.ora# tnsnames.ora Network Configuration File: /oracle/oraclenetwork/admin/tnsnames.ora
LISTENER.ORA:
SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (SID_NAME = oracle)      (ORACLE_HOME = oracle/oracle)      (PROGRAM = extproc)    )  )

TNSNAME.ORA:
LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))    )  )

BOBJECMS =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = oracle)    )  )
oracle =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = oracle)    )  )
EXTPROC_CONNECTION_DATA =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))    )    (CONNECT_DATA =      (SID = oracle)      (PRESENTATION = RO)    )  )