IT技術互(hu)動交流平jiao)/h4>

江苏11选5官网

作者(zhe)︰一起走過的日(ri)子(zi)  來(lai)源︰IT165收(shou)集  發布(bu)日(ri)期︰2020-02-20 15:38:55

啟動監(jian)听出現以下錯誤信息,找不到服務.錯誤信息如下:

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


解決方(fang)法(fa)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;    --強(qiang)行(xing)注(zhu)冊監(jian)听

System altered.

SQL> 

[oracle@dg1 admin]$ lsnrctl start    --啟動監(jian)听


解決方(fang)法(fa)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 =          --添加以下行(xing)

(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  
  • 江苏11选5官网

  • 李華(hua)明iOS-Cocos2d游戲開發專(zhuan)題(ti)
  • 本教(jiao)程(cheng)為 李華(hua)明 編(bian)著(zhu)的iOS-Cocos2d游戲開發系列教(jiao)程(cheng)︰教(jiao)程(cheng)涵蓋關于i...... 詳細
  • Windows7系統入門 優化 技巧技術專(zhuan)題(ti)
  • Windows7系統專(zhuan)題(ti) 無論是升級操作系統chang) 柿liao)備份(fen)、加強(qiang)資料(liao)的安全及(ji)管...... 詳細
About IT165 - 廣告服務 - 隱私聲明 - 版權申明 - 免責條款 - 網(wang)站(zhan)地圖 - 網(wang)友投稿 - 聯系方(fang)式
本站(zhan)內容來(lai)自于互(hu)聯網(wang),僅供用(yong)于網(wang)絡(luo)技術學習,學習中請遵循相關法(fa)律法(fa)規
江苏11选5官网 | 下一页