1.在本機(jī)oracle系統(tǒng)配串
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.
一 、創(chuàng)建dblink
Sql代碼
create database link <DBLink名稱> connect to <被連接庫(kù)的用戶名> identified by <被連接庫(kù)的密碼> using '<Oracle客戶端工具建立的指向被連接庫(kù)服務(wù)名>';
例如：
Sql代碼
1.create database link XMDS_KF connect to XMDS identified by XMDS using 'HYORCLNEW ;
但這種方式有個(gè)缺點(diǎn)就是必須要在服務(wù)器建立一個(gè)被連接庫(kù)的服務(wù)名，如果不建則會(huì)報(bào)錯(cuò)：
ORA-12154: TNS: 無(wú)法處理服務(wù)名
，但如果直接使用地址來(lái)建DBLink，就可以省去配置服務(wù)名的麻煩了：
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. )';