The listener supports no services错误

启动监听：lsnrctl start;  

停止监听：lsnrctl stop;
查看监听状态:lsnrctl status;

 

在linux启动oracle监听时出现 ：The listener supports no services错误

解决办法 ：

修改    listener.ora添加以下

 

 

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
      (PROGRAM = extproc)
    )
   (SID_DESC =
     (GLOBAL_DBNAME = orcl)
     (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
     (SID_NAME = orcl)
    )
 )

 

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = oraclehost)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

重启  :  lsnrctl start;  即可!