我有两台数据库服务器,例如一台是A另一台是B,现我想在A台服务器上访问B台服务器上的内容
CREATE PUBLIC DATABASE LINK BDLINK_LX CONNECT TO urp_yjs_app_xm IDENTIFIED BY wiscom USING '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=202.116.193.20)(PORT=1521)))(CONNECT_DATA=(SID=URPDB)(SERVER=DEDICATED)))',但总提示"ora-02019 connection description for remote database not found"
CREATE PUBLIC DATABASE LINK BDLINK_LX CONNECT TO urp_yjs_app_xm IDENTIFIED BY wiscom USING '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=202.116.193.20)(PORT=1521)))(CONNECT_DATA=(SID=URPDB)(SERVER=DEDICATED)))',但总提示"ora-02019 connection description for remote database not found"
CREATE DATABASE LINK B CONNECT TO urp_yjs_app_xm identified by wiscom using 'B';就可以了,然后用
select * from global_name@b
测试。
1,用dblink2,在tnsnames.ora里面添加B的连接。