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

On 22 May 2005 08:30:03 -0700, qazmlp1209_at_rediffmail.com wrote:

>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?

First come first served.

Please do not crosspost

--
Sybrand Bakker, Senior Oracle DBA