Oracle启动监听报错：The listener supports no services解决

安装环境:CentOS 6.3 64位

Oracle 11gR2 x86_x64

问题描述：Oracle启动监听报错：The listener supports no services

解决办法:在listener.ora文件中添加

SID_LIST_LISTENER =
(SID_LIST =
　　(SID_DESC =
　　　　(GLOBAL_DBNAME = DB202)
　　　　(SID_NAME = DB202)
　　)
)

注意:DB202是数据库的SID，需要根据自己环境，来修改；

附言：查看数据库Service Name 的方法

$sqlplus / as sysdba

SQL>show parameter service_names

NAME 　　　　　　  　　　　　　　　 TYPE 　　　VALUE
------------------------------------ ----------- ------------------------------
service_names 　　 　　　　　　　　 string 　　 DB202

 

如何区分动态监听、静态监听?

rhels5532-> lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 15-FEB-2014 11:49:12

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                13-FEB-2014 17:59:12
Uptime                    1 days 17 hr. 50 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/rhels5532/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rhels5532.localdomain)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM", status READY, has 1 handler(s) for this service...
The command completed successfully

上面READY表示动态监听