当前位置:首页 > TNS-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务

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

点击次数:1394  更新日期:2022-09-14

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

ORA-12514, TNS:listener does not currently know of service requested in conn

可以尝试修改listener.ora

此文件位于“D:\app\Administrator\virtual\product\12.2.0\dbhome_1\network\admin”

增加下图中的红色部分


SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = CLRExtProc)

      (ORACLE_HOME = D:\app\Administrator\virtual\product\12.2.0\dbhome_1)

      (PROGRAM = extproc)

      (ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\virtual\product\12.2.0\dbhome_1\bin\oraclr12.dll")

    )

(SID_DESC =

      (GLOBAL_DBNAME = ORCL)

      (ORACLE_HOME = D:\app\Administrator\virtual\product\12.2.0\dbhome_1)

      (SID_NAME = ORCL)

    )

  )