1.在本機oracle系統配串
HYORCLNEW =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.128.4.35)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.128.4.36)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = hyorcl)
(FAILOVER_MODE =
(TYPE = select)
(METHOD = basic)
(RETRIES = 20)
(DELAY = 1)
)
)
)
2.
一 、創建dblink
Sql代碼
create database link <DBLink名稱> connect to <被連接庫的用戶名> identified by <被連接庫的密碼> using '<Oracle客戶端工具建立的指向被連接庫服務名>';
例如：
Sql代碼
1.create database link XMDS_KF connect to XMDS identified by XMDS using 'HYORCLNEW ;
但這種方式有個缺點就是必須要在服務器建立一個被連接庫的服務名，如果不建則會報錯：
ORA-12154: TNS: 無法處理服務名
，但如果直接使用地址來建DBLink，就可以省去配置服務名的麻煩了：
Sql代碼
1.create public database link XMDS_KF connect to XMDS identified by XNDS using '(DESCRIPTION =
2. (ADDRESS_LIST =
3. (ADDRESS = (PROTOCOL = TCP)(HOST = 145.24.16.182)(PORT = 1521))
4. )
5. (CONNECT_DATA =
6. (SERVICE_NAME = XMDS)
7. )
8. )';