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

绝地灬酷狼 2022-08-09 12:44 135阅读 0赞

PL/SQL连接Oracle数据库的时候 报"ORA-12514: TNS:监听程序当前无法识别连接描述符中请求的服务" 错误

本例原因：

安装Oracle时一般默认实例都是orcl，发现有人不按套路出牌，改了名字，如图

![SouthEast][]

解决方法：

在Oracle安装目录 找到listener.ora文件 路径为 D:\\oracle\\product\\11.2.0\\dbhome\_1\\NETWORK\\ADMIN

(根据自己情况查找) 修改：

\# listener.ora Network Configuration File: D:\\oracl\\product\\11.2.0\\dbhome\_1\\network\\admin\\listener.ora  
\# Generated by Oracle configuration tools.

SID\_LIST\_LISTENER =  
  (SID\_LIST =  
    (SID\_DESC =  
      (SID\_NAME = CLRExtProc)  
      (ORACLE\_HOME = D:\\oracle\\product\\11.2.0\\dbhome\_1)  
      (PROGRAM = extproc)  
      (ENVS = "EXTPROC\_DLLS=ONLY:D:\\oracle\\product\\11.2.0\\dbhome\_1\\bin\\oraclr11.dll")  
    )  
    (SID\_DESC =  
      (GLOBAL\_DBNAME = JTW)  
      (ORACLE\_HOME = D:\\oracle\\product\\11.2.0\\dbhome\_1)  
      (SID\_NAME = JTW)  
    )  
  )

LISTENER =  
  (DESCRIPTION\_LIST =  
    (DESCRIPTION =  
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))  
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))  
    )  
  )

红色部分为新添加内容，JTW为监听的实例名

然后修改(添加)instantclient\_11\_2\\network\\admin\\tnsnames.ora

MyOracle =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = jtw)
        )
      )

重启Oracle监听

参考资料：[链接][Link 1]

作者：[itmyhome][]

[SouthEast]: /images/20220731/0880c2f4bf8944c28deaee166faf6330.png
[Link 1]: http://www.blogjava.net/freeman1984/archive/2011/04/15/348350.html
[itmyhome]: http://blog.csdn.net/itmyhome1990