我新建一个链路:
create database link nacc connect to nadbd identified by dbd12345 using 'nacc.world';
创建成功后,为什么pl/sql 查询时提示"ora-12154:TNS:could not resolve the connect identified specified",
用户可以登陆成功,tns配置应该没有问题,就是链路不能用,请各位大侠帮忙,谢谢!
create database link nacc connect to nadbd identified by dbd12345 using 'nacc.world';
创建成功后,为什么pl/sql 查询时提示"ora-12154:TNS:could not resolve the connect identified specified",
用户可以登陆成功,tns配置应该没有问题,就是链路不能用,请各位大侠帮忙,谢谢!
或者可将连接串放在using '(decription.............)'
connect to nadbd identified by dbd12345
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.142.202.12)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = nacc)
)
)';个人感觉这种方法比较好,这样不受本地服务的影响。