1、用戶端hosts檔案配置:
10.19.65.167 sdwgrac1-vip
10.19.65.169 sdwgrac2-vip
註:unix平台是/etc/hosts;windows平台是C:\Windows\System32\drivers\etc\hosts。
2、用戶端tnsnames.ora配置:
EOMS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = sdwgrac1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = sdwgrac2-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DA TA =
(SERVER = DEDICATED)
(SERVICE_NAME = eoms)
)
)
如上配置後,就可以在串連串裡串連了,如:
sqlplus name/passwd@eoms
建議盡量使用eoms這個指定的資料庫服務名來串連資料庫。
我們的應用必須使用這個服務名來串連資料庫,以合理使用資料庫的負載平衡功能。
3、如果通過中介軟體進行串連,則URL應為:
jdbc:Oracle:thin:username/password@hostname:port/service_name
jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = sdwgrac1-vip)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST=sdwgrac2-vip)(PORT = 1521))(LOAD_BALANCE = yes))(CONNECT_DATA=(SERVER = DEDICATED)(SERVICE_NAME = eoms)(FAILOVER_MODE =(TYPE =SELECT )(METHOD = BASIC)(RETRIES = 120)(DELAY = 5))))