The listener supports no services解决

来源：互联网发布：张晓晗七年之痒知乎编辑：程序博客网时间：2024/04/28 23:49

今天在PC上想测试一下DG同步，所以配置了两个监听，但在启动过程中总是提示：The listener supports no services

打开 listener.ora查看发现配置的监听名字叫：LISTENER_PRIMARY 而SID_LIST_LISTENER未改名。

后增加 SID_LIST_LISTENER_PRIMARY重新启动监听，问题解决。

# listener.ora Network Configuration File: D:\oracle\product\10.2.0\db_2\network\admin\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (SID_NAME = PLSExtProc)      (ORACLE_HOME = D:\oracle\product\10.2.0\db_2)      (PROGRAM = extproc)    )     )LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))      (ADDRESS = (PROTOCOL = TCP)(HOST = AYXNTL2P8LN04AV)(PORT = 1521))    )  )SID_LIST_LISTENER_PRIMARY =  (SID_LIST =    (SID_DESC =      (GLOBAL_DBNAME = orcl)      (ORACLE_HOME = D:\oracle\product\10.2.0\db_2)      (SID_NAME = orcl)    )      )  LISTENER_PRIMARY =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.1)(PORT = 1522))    )  )

总结 SID_LIST后面的名称要和配置的监听名字匹配。