RHEL5安装Oracle10gRAConVMwareServer1.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

在第一个窗口中，香港服务器，查看用户连接到的实例:

第一个窗口显示

第二个窗口显示

本文出自 “玉麒麟” 博客，网站空间，请务必保留此出处