首页 > 代码库 > ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
Centos5.5 安装Oracle11g客户端，配置了本地的net服务后，用sqlplus连接报错：
tnsnames.ora配置如下
orcl =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.39.199)(PORT = 1521))(CONNECT_DATA =(SERVICE = DEDICATED)(SERVICE_NAME = orcl)))
解决方案：修改tnsname.ora文件内容如下：
172.16.39.199 =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.39.199)(PORT = 1521))(CONNECT_DATA =(SERVICE = DEDICATED)(SERVICE_NAME = orcl)))
再次连接，成功。
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉： 投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。