RHEL5安装Oracle10gRAC on VMware Server1.0之十
Failover测试OracleRAC是一个集群数据库,可以实现负载均衡和故障无缝切换。这些技术实现的基础就是failover(故障转移)。Oracle10gRAC的failover可以细分成3种,
Failover测试
Client-Side Connect time Failover;
TAF;
Service-Side TAF.
首先,虚拟主机,先建立两个用户,并授予相关权限
JH =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.6.1.116)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.6.1.117)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = rac)
)
)
YS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.6.1.116)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.6.1.117)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = rac)
(FAILOVER_MODE=
(TYPE = session)
(METHOD = basic)
(RETRIES = 180)
(DELAY = 5)
)
)
)
Sqlplus ac/ac.green@jh
Sqlplus green/ac.green@ys
在第一个窗口中,香港服务器,查看用户连接到的实例:
第一个窗口显示
第二个窗口显示
本文出自 “玉麒麟” 博客,网站空间,请务必保留此出处