Database Networking (MOSC)

MOSC Banner

RAC tnsnames Load Balance parameter

edited Nov 8, 2009 10:02PM in Database Networking (MOSC) 4 commentsAnswered
HI.

I have a RAC version 10.2.0.4 with the next tnsnames entry, and my question is, what's the difference in the parameter "LOAD_BALANCE" between "YES" and "ON"..?

-

FONATOP =
  (DESCRIPTION =
    (ENABLE = BROKEN)
    (ADDRESS_LIST =
      (LOAD_BALANCE = yes)
      (FAILOVER = yes)
      (ADDRESS = (PROTOCOL = TCP)(HOST = p480db1-vip)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = p480db2-vip)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = fonatop)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 120)
        (DELAY = 5)
      )
    )
  )
-

Regards.

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