IT技术互动交流平台

The listener supports no services The command completed successfully

作者:一起走过的日子??来源:IT165收集??发布日期:2016-11-24 21:07:55

启动监听出现以下错误信息,找不到服务.错误信息如下:

[oracle@dg1 admin]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-NOV-2016 11:17:54

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

STATUS of the LISTENER

------------------------

Alias ? ? ? ? ? ? ? ? ? ? LISTENER

Version ? ? ? ? ? ? ? ? ? TNSLSNR for Linux: Version 11.2.0.1.0 - Production

Start Date ? ? ? ? ? ? ? ?18-NOV-2016 11:15:22

Uptime ? ? ? ? ? ? ? ? ? ?0 days 0 hr. 2 min. 31 sec

Trace Level ? ? ? ? ? ? ? off

Security ? ? ? ? ? ? ? ? ?ON: Local OS Authentication

SNMP ? ? ? ? ? ? ? ? ? ? ?OFF

Listener Parameter File ? /u01/product/11.2.0.1/db_1/network/admin/listener.ora

Listener Log File ? ? ? ? /u01/diag/tnslsnr/dg1/listener/alert/log.xml

Listening Endpoints Summary...

? (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

? (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dg1)(PORT=1521)))

The listener supports no services

The command completed successfully

[oracle@dg1 admin]$?


解决方法1:

[oracle@dg1 admin]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Nov 18 11:19:06 2016

Copyright (c) 1982, 2009, Oracle. ?All rights reserved.

Connected to an idle instance.

SQL> startup


Total System Global Area ?830930944 bytes

Fixed Size ? ? ? ? ? ? ? ? ?2217912 bytes

Variable Size ? ? ? ? ? ? 545261640 bytes

Database Buffers ? ? ? ? ?281018368 bytes

Redo Buffers ? ? ? ? ? ? ? ?2433024 bytes

Database mounted.

Database opened.

SQL> show parameter service_names

NAME ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? TYPE ? ? ? ?VALUE

------------------------------------ ----------- ------------------------------

service_names ? ? ? ? ? ? ? ? ? ? ? ?string ? ? ?tong

SQL> alter system register; ? ?--强行注册监听

System altered.

SQL>?

[oracle@dg1 admin]$?lsnrctl start ? ?--启动监听


解决方法2:

[oracle@dg2 ~]$ vim /u01/product/11.2.0.1/db_1/network/admin/listener.ora

LISTENER =

? (DESCRIPTION_LIST =

? ? (DESCRIPTION =

? ? ? (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

? ? ? (ADDRESS = (PROTOCOL = TCP)(HOST = dg2)(PORT = 1521))

? ? )

? )

SID_LIST_LISTENER = ? ? ? ? ?--添加以下行

(SID_LIST =

? (SID_DESC =

? (GLOBAL_DBNAME = orcl)

? (SID_NAME = orcl)

? )

)

ADR_BASE_LISTENER = /u01

[oracle@dg2 ~]$ lsnrctl start


Tag标签: The?? listener?? supports?? no?? services?? ?? The?? c??
  • 专题推荐

About IT165 - 广告服务 - 隐私声明 - 版权申明 - 免责条款 - 网站地图 - 网友投稿 - 联系方式
本站内容来自于互联网,仅供用于网络技术学习,学习中请遵循相关法律法规