项目场景：

PLSQL Developer连接oracle提示ORA-12514:TNS: 监听程序当前无法识别连接描述符中请求的服务

PS:oracle部署在Linux下

原因： 

启动监听时报：The listener supports no services

解决方案：

提示：在oracle监听文件目录中（/data/oracle/product/11.2.0/dbhome_1/network/admin）listener.ora文件中添加SID_LIST_LISTENER内容:

# listener.ora
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1521))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = orcl)
      (ORACLE_HOME = /data/oracle/product/11.2.0/dbhome_1/)
      (SID_NAME = orcl)
    )
  )

添加完成后重启oracle服务

su oracle //1、切换oracle用户

sqlplus /nolog //2、连接oracle

conn /as sysdba //3、登录管理员

shutdown abort //4、关闭oracle

quit //5、退出oracle

lsnrctl stop //6、停止监听

lsnrctl statr //7、启动监听 

startup //启动oracle  ps:启动oracle前重复1-3步