create database link ZCYTEST
connect to INTERFACE identified by SCOINTERFACE
using 'zcytest';
然后 Select * From ALL_NEED_ADD@zcytest 报以上错误
TNSNAME.ORA文件内容:
zcytest=
(DESCRIPTION=
(ADDRESS_LIST =
(ADDRESS =(PROTOCAL=TCP)(HOST=133.37.8.68)(PORT=1521))
)
(CONNECT_DATA =
(SID=ACCT1)
)
)
我用intferface/scointerface@zcytest登陆数据库都没有问题,为何用DBLINK就不行呢
connect to INTERFACE identified by SCOINTERFACE
using 'zcytest';
然后 Select * From ALL_NEED_ADD@zcytest 报以上错误
TNSNAME.ORA文件内容:
zcytest=
(DESCRIPTION=
(ADDRESS_LIST =
(ADDRESS =(PROTOCAL=TCP)(HOST=133.37.8.68)(PORT=1521))
)
(CONNECT_DATA =
(SID=ACCT1)
)
)
我用intferface/scointerface@zcytest登陆数据库都没有问题,为何用DBLINK就不行呢
看看返回什么结果
(DESCRIPTION=
(ADDRESS_LIST =
(ADDRESS =(PROTOCAL=TCP)(HOST=133.37.8.68)(PORT=1521))
)
(CONNECT_DATA =
(SID=ACCT1)
)
)
改为zcytest=
(DESCRIPTION=
(ADDRESS_LIST =
(ADDRESS =(PROTOCAL=TCP)(HOST=133.37.8.68)(PORT=1521))
)
(CONNECT_DATA =
(SID=zcytest)
)
)
007 15:15:28Copyright (c) 1997 Oracle Corporation. All rights reserved.已使用的参数文件:
D:\oracle\ora81\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 133.37.8.68)(PORT = 1521))) (CONNECT_DATA = (SID = acct1)))
OK(10毫秒)C:\Documents and Settings\bridge.ZHANGCHENYU>
(DESCRIPTION=
(ADDRESS_LIST =
(ADDRESS =(PROTOCAL=TCP)(HOST=133.37.8.68)(PORT=1521))
)
(CONNECT_DATA =
(SID=ACCT1)
)
)然后重建你的db_link,再试试
# Generated by Oracle configuration tools.SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
设置成这样了,还是报原来一样的错误
简单说:
数据库a建立到数据库b的db_link
必须在数据库a的server端的tnsnames.ora里面配置数据库b的连接串。
而不是在你的client端配置了数据库b的连接串db_link就好使了。