11gR2 RAC使用SCAN故障切换问题的解决方案

11gR2 RAC安装后，默认使用SCAN 的listener，但是客户端直接使用scan的tns连接，连接正常，但是故障切换有问题，以下是解决方案：

两种方式：

1：>远端tnsnames.ora 增加故障切换内容（直接使用vip）：

king1=

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))

      (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))

      (ADDRESS = (PROTOCOL = TCP)(HOST = rac3-vip)(PORT = 1521))

      (ADDRESS = (PROTOCOL = TCP)(HOST = rac4-vip)(PORT = 1521))

    )

    (LOAD_BALANCE=yes)

    (FAILOVER=yes)

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = dbeas)      

      (FAILOVER_MODE =

        (TYPE = SELECT)

        (METHOD = BASIC)

        (RETRIES = 180)

        (DELAY = 5)

      )

    )

  )

2：在tnsnames.ora里面加入scan ip

dbeas=

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = scan)(PORT = 1521))

        )

    (LOAD_BALANCE=yes)

    (FAILOVER=yes)

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = dbeas)      

      (FAILOVER_MODE =

        (TYPE = SELECT)

        (METHOD = BASIC)

        (RETRIES = 180)

        (DELAY = 5)

      )

    )

  )

相当于在scanip的基础上做了个client taf

注：文中rac*-vip、scan请使用实际ip。

参考：http://www.itpub.net/thread-1305371-1-1.html

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/14184018/viewspace-763586/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/14184018/viewspace-763586/