TNSNAMES TAF TEMPLATE , LOCAL_LISTENER RAC FAILOVER

最新推荐文章于 2025-12-17 14:20:19 发布

转载最新推荐文章于 2025-12-17 14:20:19 发布 · 90 阅读

文章标签：

本文提供了Oracle Real Application Clusters (RAC) 的配置示例，详细展示了如何设置两个节点之间的负载均衡与故障转移机制，包括服务名称、实例角色及监听器地址等关键参数。

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))