Oracle建立远程链接问题,请大家帮忙!
我已经在tnsnames.ora这个文件中进行了如下配置:
HNSB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.123.166.133)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = HNSB)
)
)
用户名和密码都是HNSB,并且在PL/SQL中连接正常,在tnsnames.ora这个文件中还有如下配置:
QYD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.123.166.186)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = cx)
)
)
在PL/SQL中成功登陆到QYD后,建立了如下连接:
create database link HNSB.US.ORACLE.COM
connect to HNSB identified by HNSB
using 'HNSB';
现在在QYD中远程查询时出错:ORA-12154 无法处理服务名!
select * from AA@HNSB.US.ORACLE.COM
请高手们帮帮忙,谢谢!