The listener supports no service

数据库重启后，lsnrctl status提示如下：

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

STATUS of the LISTENER

------------------------

Alias                    LISTENER

Version                  TNSLSNR for Linux: Version 11.2.0.3.0 - Production

Start Date                16-NOV-2017 14:42:49

Uptime                    0 days 0 hr. 0 min. 0 sec

Trace Level              off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File  /oracle/ora11g/product/network/admin/listener.ora

Listener Log File        /oracle/ora11g/diag/tnslsnr/linux-lina/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux-lina)(PORT=1521)))

The listener supports no services

The command completed successfully

解决方法：

修改listener.ora

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /oracle/ora11g/product)

(PROGRAM = extproc)

)

(SID_DESC =

(GLOBAL_DBNAME = ora11g)

(ORACLE_HOME = /oracle/ora11g/product)

(SID_NAME = ora11g)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = linux-lina)(PORT = 1521))

)

)

ADR_BASE_LISTENER = /oracle/ora11g

黑色粗体部分为我新增的内容，重启监听后数据库正常。