监听“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)
)
)