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) ) )
再次连接,成功。
**********************************************
对于一件事情,往往超过我们的想象,自信、坚持,勇往直前!
参与者:Rainbow Gu
地址:南都
***********************************************posted on 2015-01-19 18:06 RainbowGu 阅读(5550) 评论(0) 编辑 收藏 举报