The listener supports no services The command completed suc

摘要: 起动监视出現下列不正确信息内容,找不着服务.不正确信息内容以下:[]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-NOV-2016 11:17:54Copyright (c) 1991, 2009, Oracle. All rights reserved.Con...

起动监视出現下列不正确信息内容,找不着服务.不正确信息内容以下:

[]$ 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.work/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

[]$ 


处理方式1:

[]$ 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   bytes

Fixed Size                  2217912 bytes

Variable Size             bytes

Database Buffers           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  

[]$ lsnrctl start    --起动监视


处理方式2:

[ ~]$ vim /u01/product/11.2.0.work/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

[ ~]$ lsnrctl start




联系我们

全国服务热线:4000-399-000 公司邮箱:343111187@qq.com

  工作日 9:00-18:00

关注我们

官网公众号

官网公众号

Copyright?2020 广州凡科互联网科技股份有限公司 版权所有 粤ICP备10235580号 客服热线 18720358503

技术支持:h5制作网站