ORA-12514 TNS 监听程序当前无法识别连接描述符中请求服务

 

重新配置 监听，修改为IP地址或者电脑名称

 

listener.ora文件 添加如下配置

 

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = G:\app\admin\product\12.1.0\dbhome_1)
      (PROGRAM = extproc)
    )
   (SID_DESC =
      (GLOBAL_DBNAME = ORCL)
      (ORACLE_HOME = G:\app\admin\product\12.1.0\dbhome_1)  
      (SID_NAME = ORCL)
    )
  )