监听“The listener supports no services”解决办法?

The listener supports no services
The command completed successfully

这是因为实例没有注册到监听上

查看listener.ora

Started with pid=25113
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=txy)(PORT=1539)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1539)))
Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
WARNING: Subscription for node down event still pending
09-MAR-2023 09:37:22 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=txy)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647552)) * status * 0
09-MAR-2023 09:37:23 * ping * 0
WARNING: Subscription for node down event still pending
09-MAR-2023 09:37:27 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=txy)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647552)) * status * 0
WARNING: Subscription for node down event still pending
09-MAR-2023 09:37:29 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=txy)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647552)) * status * 0
WARNING: Subscription for node down event still pending
09-MAR-2023 09:37:29 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=txy)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647552)) * status * 0
WARNING: Subscription for node down event still pending
09-MAR-2023 09:37:30 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=txy)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647552)) * status * 0
WARNING: Subscription for node down event still pending
.....

解决办法:

SID_LIST_LISTENER =  
(SID_LIST =  
  (SID_DESC =  
  (GLOBAL_DBNAME = orcl)
  (SID_NAME = orcl)
  )
)

posted on 2023-03-09 10:36  yq1DB  阅读(623)  评论(0编辑  收藏  举报

导航