TNSNAMES TAF TEMPLATE , LOCAL_LISTENER RAC FAILOVER

itpremier發表於2011-03-30
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: 

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/350519/viewspace-1047968/,如需轉載,請註明出處,否則將追究法律責任。

相關文章