win10下使用plsql developer连接linux虚拟机Oracle 11g 报错 ora-12154

最新推荐文章于 2023-03-13 14:14:37 发布

MyOLsun

最新推荐文章于 2023-03-13 14:14:37 发布

阅读量1.3k

点赞数

本文链接：https://blog.csdn.net/MyOLsun/article/details/88926222

版权

在win10环境下使用PLSQL Developer尝试连接Linux虚拟机上的Oracle 11g数据库时，遇到ORA-12154错误。问题出在tnsnames.ora配置不正确，缺少SERVICE_NAME。错误描述和正确配置方法已给出，调整后连接恢复正常。

摘要由CSDN通过智能技术生成

前提：

1、虚拟机中已成功安装Oracle数据库

2、配置了监听器

3、下载安装PLSQL

4、安装并配置好instantclient

问题：使用PL/SQL developer 连接Oracle11g，提示错误ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
以下是我报错的配置：
linux虚拟机服务器端
listener.ora

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.159.129)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.159.129)(PORT = 1522))
   )
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=orcl)
(ORACLE_HOME=/u01/app/oracle/product/11.2.0)
(SID_NAME=orcl))
)

tnsnames.ora

orcl=
    (*DESCRIPTION =
     (DESCRIPTION_LIST* =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.159.129)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.159.129)(PORT = 1522