Which DB instance(among 2 running instances) is preferred with Oracle TAF feature?

From: <qazmlp1209_at_rediffmail.com>
Date: 22 May 2005 08:30:03 -0700
Message-ID: <1116775803.598001.53540@g44g2000cwa.googlegroups.com>

Following is excerpt from the tnsnames.ora file: SUMSKYDB =
 (DESCRIPTION =
(ADDRESS_LIST =

   (LOAD_BALANCE=ON)

   (FAILOVER=ON)
    (ADDRESS=(PROTOCOL=TCP)(HOST=host1-oracle-vip)(PORT=1521))
    (ADDRESS=(PROTOCOL=TCP)(HOST=host2-oracle-vip)(PORT=1521))

   )
(CONNECT_DATA =

     (SERVICE_NAME  = SUMSKYDB.SUMMERSKYUS.COM)
     (FAILOVER_MODE = (TYPE=SELECT)(METHOD=BASIC)
      )

   )
)

It is understood that, when one Oracle instance fails, it will transparently connect to the other instance. I would like to know about, to what instance the preference will be given to when both the instances are up and running. Is this according to the order that is given in tnsnames.ora file? In the above example, it will always be to 'host1-oracle-vip' first and then to 'host2-oracle-vip' in case if 'host1-oracle-vip' is not running. Or, some other factor decides it?

Could anybody clarify? Received on Sun May 22 2005 - 10:30:03 CDT