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
在第一个窗口中，香港服务器，查看用户连接到的实例:
第一个窗口显示
第二个窗口显示
本文出自 “玉麒麟” 博客，网站空间，请务必保留此出处
每个人都需要一台速度更快、更稳定的 PC。随着时间的推移，垃圾文件、旧注册表数据和不必要的后台进程会占用资源并降低性能。幸运的是，许多工具可以让 Windows 保持平稳运行。
广告Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
667
收藏
