oracle监听经常报错,Oracle启动监听报错：The listener supports no services解决

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

LISTENERVersion

TNSLSNR for Linux: Version

11.2.0.1.0 - ProductionStart

Date

13-FEB-2014

17:59:12Uptime

1 days 17 hr. 50 min.

0 secTrace

Level

offSecurity

ON: Local OS

AuthenticationSNMP

OFFListener Parameter File

/u01/app/11.2.0/grid/network/admin/listener.oraListener

Log

File

/u01/app/grid/diag/tnslsnr/rhels5532/listener/alert/log.xmlListening

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表示动态监听

分类: Oracle DBA

标签: ORACLE DBA

来自

<http://www.cnblogs.com/arcer/archive/2013/03/09/2951484.html

>