***********Oracle dblink的问题?特急,在线等待!!!***********
我在数据库A上建立dblink连接数据库B,dblink建好后,查询数据库B上aaa表的数据出现以下错误:请各位大虾不吝赐教,谢谢!!!
SQL> select * from aaa@dbstage_link;
select * from aaa@dbstage_link
*
ERROR at line 1:
ORA-12154: TNS:could not resolve service name
以下是建立dblink的脚本:
create public database link dbstage_link
connect to stage identified by stage
using 'DBSTAGE';
以下是我在\network\ADMIN\tnsnames.ora文件中添加的。
DBSTAGE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.3)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dbstage)
)
)