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

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

第一个窗口显示

第二个窗口显示

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