监听程序在 connect data 中未获得 service name ORA-12154: TNS: 无法解析指定的连接标识符

连接字符串有问题：

"Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST={0})(PORT={1})))(CONNECT_DATA=(SERVER={2})(SERVICE_NAME={3})))User Id={4}Password={5}​"

格式如上，替换{0} 这种为你自己的配置

客户端配置好服务名后，用PL/SQL Developer连接数据库时，报错：ORA-12504：TNS：监听程序在CONNECT_DATA中未获得SERVICE_NAME。一般这种情况请检查tnsnames.ora文件中TNS是否配置正确，如下所示，SERVICE_NAME 名字弄错了，结果报如上错误：

GSP =

(DESCRIPTION =

(ADDRESS =(PROTOCOL = TCP)(HOST = 172.20.36.79)(PORT = 1521))

(CONNECT_DATA=

(SERVER = DEDICATED)

(SERVER_NAME = gsp)

)

)

修改为

GSP =

(DESCRIPTION =

(ADDRESS =(PROTOCOL = TCP)(HOST = 172.20.36.79)(PORT = 1521))

(CONNECT_DATA=

(SERVER = DEDICATED)

(SERVICE_NAME = gsp)

)

)

---