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)
)
)