RAC的負載均衡有2種方式
1:數據庫服務器端 設置remote_listener
2: 客戶端tns配置
一般連接串這麼寫:
ess_hb_i1=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 132.35.104.20)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 132.35.104.22)(PORT = 1521))
(LOAD_BALANCE = off)
(FAILOVER=ON)
(CONNECT_DATA =
(SERVER = DEDICATED)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
)
(SERVICE_NAME = esshb)
)
)