本地实例:heyu
tnsname.ora:
inf=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = node2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = R2)
)
)
dblink :
create public database link nnf
connect to qn identified by qn using 'nnf';
远端实例:nnf
在本地heyu上操作如下:
insert into test@nnf
select * from test
报如下错:
Oracle ORA-02069: 此操作的 global_names 参数必须设置为 TRUE
在heyu上修改:
alter system set global_names = true ;
在本地再运行 insert into test@nnf
select * from test
报如下错:
ORA-04054:数据库链接HEYU不存在
ORA-02063:紧接着line(起自inf)
在远端nnf上建dblink 与 tnsname.ora
dblink:
create public database link heyu
connect to qn identified by qn using 'heyu';
tnsname.ora
heyu=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = heyu)
)
)
在本地再运行 insert into test@nnf
select * from test
再次运行,没错了。
很奇怪的现象!我也费解!希望有人能帮我解答,谢谢!