oracle 创建dblink后无法使用

xtky_limi

创建语句:  
create database link mcc59_to_167 connect to "LINGTU" identified by "lingtu" using 'lingtu';

tnsnames.ora文件配置如下:


167 =
  (DESCRIPTION =
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.12.167)(PORT = 1521))
  )
  (CONNECT_DATA =
  (SERVICE_NAME = lingtu)
  )
  )

172.17.12.59 =
  (DESCRIPTION =
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.12.59)(PORT = 1521))
  )
  (CONNECT_DATA =
  (SERVICE_NAME = orcl)
  )
  )


创建dblink提示创建成功，但是 查询时提示
SQL> select count(*) from mcc_track@mcc59_to_167;
select count(*) from mcc_track@mcc59_to_167
  *
ERROR at line 1:
ORA-12154: TNS:could not resolve the connect identifier specified


global_names设置为false了已经
alter system set global_names=false;

高手们帮忙看下什么问题啊?谢谢

xing2999

你要连哪个服务器?172.17.12.167?还是172.17.12.59?

连172.17.12.167的话就应该如下创建DBLINK：
create database link mcc59_to_167 connect to "LINGTU" identified by "lingtu" using '167';

连172.17.12.59的话就应该如下创建DBLINK：
create database link mcc59_to_167 connect to "LINGTU" identified by "lingtu" using '172.17.12.59';