用户是SYSTEM,还要权限吗? 服务器 SID: webA 服务名:同SID 用户:system 口令:123 SID: webB 服务名:同SID 用户:system 口令: 123我在服务器webA上建DBLINK:CREATE DATABASE LINK "WEBB" CONNECT TO "SYSTEM" IDENTIFIED BY "123" USING 'WEBA' 结果出现: ERROR at line 1: ORA-12154: TNS:could not resolve service name
用户是SYSTEM,还要权限吗? 服务器 SID: webA 服务名:同SID 用户:system 口令:123 SID: webB 服务名:同SID 用户:system 口令: 123我在服务器webA上建DBLINK:CREATE DATABASE LINK "WEBB" CONNECT TO "SYSTEM" IDENTIFIED BY "123" USING 'WEBA' select * from spxxb@webB; 结果出现: ERROR at line 1: ORA-02019: connection description for remote database not found
服务器
SID: webA
服务名:同SID
用户:system
口令:123
SID: webB
服务名:同SID
用户:system
口令: 123我在服务器webA上建DBLINK:CREATE DATABASE LINK "WEBB" CONNECT TO "SYSTEM" IDENTIFIED BY
"123" USING 'WEBA' 结果出现:
ERROR at line 1:
ORA-12154: TNS:could not resolve service name
服务器
SID: webA
服务名:同SID
用户:system
口令:123
SID: webB
服务名:同SID
用户:system
口令: 123我在服务器webA上建DBLINK:CREATE DATABASE LINK "WEBB" CONNECT TO "SYSTEM" IDENTIFIED BY
"123" USING 'WEBA' select * from spxxb@webB;
结果出现:
ERROR at line 1:
ORA-02019: connection description for remote database not found