ITPub博客

首页 > 数据库 > 数据库开发技术 > TNSNAMES TAF TEMPLATE , LOCAL_LISTENER RAC FAILOVER

TNSNAMES TAF TEMPLATE , LOCAL_LISTENER RAC FAILOVER

原创 数据库开发技术 作者:itpremier 时间:2011-03-30 17:09:05 0 删除 编辑
SALES_DED_PRE=
  (DESCRIPTION=
     (LOAD_BALANCE=OFF)
     (FAILOVER=ON)
     (ADDRESS_LIST=
        (ADDRESS=(PROTOCOL=TCP)(HOST=144.25.28.74)(PORT=1524))
        (ADDRESS=(PROTOCOL=TCP)(HOST=144.25.28.75)(PORT=1524)))
     (CONNECT_DATA=
        (SERVICE_NAME=SALES.ORACLE.COM)
        (SERVER=DEDICATED)
        (INSTANCE_ROLE=PRIMARY)
        (FAILOVER_MODE=
            (BACKUP=SALES_DED_PRE_SECONDARY)
            (TYPE=SELECT)
            (METHOD=PRECONNECT)
            (RETRIES=180)
            (DELAY=5))))

SALES_DED_PRE_SECONDARY=
  (DESCRIPTION=
     (LOAD_BALANCE=OFF)
     (FAILOVER=ON)
     (ADDRESS_LIST=
          (ADDRESS=(PROTOCOL=TCP)(HOST=144.25.28.75)(PORT=1524))
          (ADDRESS=(PROTOCOL=TCP)(HOST=144.25.28.74)(PORT=1524)))
     (CONNECT_DATA=
          (SERVICE_NAME=SALES.ORACLE.COM)
     (SERVER=DEDICATED)
     (INSTANCE_ROLE=SECONDARY)
     (FAILOVER_MODE=
         (BACKUP=SALES_DED_PRE)
         (TYPE=SELECT)
         (METHOD=PRECONNECT)
         (RETRIES=48)
         (DELAY=900))))
-- LOCAL LISTENER:

The values of the LOCAL_LISTENER parameter can be resolved through the local tnsnames.ora files on Nodes 1 and 2, respectively:

listener_SALES_HOSTA=
    (ADDRESS=(PROTOCOL=TCP)(HOST=144.25.28.74)(PORT=1421))

listener_SALES_HOSTB=
    (ADDRESS=(PROTOCOL=TCP)(HOST=144.25.28.75)(PORT=1421))
ORACLE DOC LINK: 

http://download.oracle.com/docs/cd/B10501_01/rac.920/a96601/5config.htm

[@more@]

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

上一篇: VNC 配置
请登录后发表评论 登录
全部评论

注册时间:2008-11-27

  • 博文量
    253
  • 访问量
    773710