请教一个 database link的问题,我的操作错在哪?
在host1上创建link 到host2:
在host1上配置tnsnames.ora:
HQ =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = host2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oracle)
)
)
SQL> create database link dblink connect to user1 identified by user1 using 'HQ';
SQL> connect user1/user1@hq
ERROR:
ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务