Database Networking (MOSC)

MOSC Banner

How is posible disable the LOAD_BALANCE?

edited Oct 15, 2010 10:24AM in Database Networking (MOSC) 14 commentsAnswered
 Hello, I am configuring TAF in our RAC. I have a problem. I want configure FAILOVER but I want not LOAD_BALANCE. I have configured the listener.ora, tnsnames.ora and the parameter remote_listener. The failover is running perfectly but the connections are balancing (first one node, after the other node).  I think that the problem is the configuración of tnsnames.ora. I show you the tnsnames.ora.

TAF_CASTOR.INVXXXXX.COM =
(DESCRIPTION =
    (ADDRESS_LIST =
    (FAILOVER=ON)
    (LOAD_BALANCE = OFF)
      (ADDRESS = (PROTOCOL = TCP)(HOST = cxxxxx-vxx)(PORT = 1527))
      (ADDRESS = (PROTOCOL = TCP)(HOST = exxxx-vxx)(PORT = 1527))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = BBACK)

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