The listener supports no services問題解決

甲骨文技術支援發表於2017-03-06
環境是11.2.0.4，檢視監聽狀態是The listener supports no services


  1. [oracle@oracle11gtest admin]$ lsnrctl status

  3. LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 06-MAR-2017 18:54:40

  5. Copyright (c) 1991, 2013, Oracle. All rights reserved.

  7. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle11gtest)(PORT=1521)(IP=FIRST)))
  8. STATUS of the LISTENER
  9. ------------------------
  10. Alias LISTENER
  11. Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
  12. Start Date 06-MAR-2017 18:54:15
  13. Uptime 0 days 0 hr. 0 min. 24 sec
  14. Trace Level off
  15. Security ON: Local OS Authentication
  16. SNMP OFF
  17. Listener Parameter File /alidata1/app/oracle/11.2.0/db_1/network/admin/listener.ora
  18. Listener Log File /alidata1/app/oracle/diag/tnslsnr/oracle11gtest/listener/alert/log.xml
  19. Listening Endpoints Summary...
  20.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.3.171)(PORT=1521)))
  21.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
  22. The listener supports no services
  23. The command completed successfully
解決辦法是，在listener.ora檔案裡新增如下內容，把gps修改為相應的例項名

  1. SID_LIST_LISTENER =
  2. (SID_LIST =
  3.   (SID_DESC =
  4.   (GLOBAL_DBNAME = gps)
  5.   (SID_NAME = gps)
  6.   )
  7. )
重啟監聽後就可以連線了。

附完整listener.ora內容

  1. [oracle@oracle11gtest admin]$ more listener.ora
  2. # listener.ora Network Configuration File: /alidata1/app/oracle/11.2.0/db_1/network/admin/listener.ora
  3. # Generated by Oracle configuration tools.

  5. LISTENER =
  6.   (DESCRIPTION_LIST =
  7.     (DESCRIPTION =
  8.       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
  9.       (ADDRESS = (PROTOCOL = TCP)(HOST = oracle11gtest)(PORT = 1521))
  10.     )
  11. )
  12. SID_LIST_LISTENER =
  13. (SID_LIST =
  14.   (SID_DESC =
  15.   (GLOBAL_DBNAME = gps)
  16.   (SID_NAME = gps)
  17.   )
  18. )

  20. ADR_BASE_LISTENER = /alidata1/app/oracle



來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/20893244/viewspace-2134802/，如需轉載，請註明出處，否則將追究法律責任。

相關文章