解决监听状态显示 The listener supports no services

今天查看数据库监听发现

lsnrctl status

The listener supports no services

解决方法：添加

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

然后重新注册下 alter system register

OK！

监听正常