Database - RAC/Scalability (MOSC)

MOSC Banner

Session Failover TAF tnsnames.ora vs config via srvctl

edited Jun 10, 2015 2:24AM in Database - RAC/Scalability (MOSC) 8 commentsAnswered ✓
Hi,
i have configured the TAF Session failover in tnsnames.ora (used successfully for a long time) and tried recently configuring it centrally on the RAC database server.
Both approaches work and do what they should and are somewhat redundant.

Are there any specific advantages for having a central configuration via srvctl over a decentral approach with tnsnames.ora?

tnames Config Sample:

SAP_TEST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = XXX1-vip)(PORT = 1530))
    (ADDRESS = (PROTOCOL = TCP)(HOST = XXX2-vip)(PORT = 1530))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = sap_test)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 25)
        (DELAY = 5)
      )
    )
  )

Central Config:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center