Re: TAF and node failover non RAC oracle 10.2

Yes, this will work.  But you need to set LOAD_BALANCE=NO in your TNSNAMES
entry below so that your app always connects to node 1 unless it's down.
Also, you probably want to set your RETRIES and DELAY to higher values.

Hemant makes a good point that connect-time failover probably does what
you're looking for.  However one benefit of TAF is that if you have a
query-based application then the database driver can transparently
re-connect without returning any errors to your app.  Some apps don't
automatically reconnect to the DB when the connection drops and don't deal
well with this situation.

-Jeremy


On 1/30/08, hrishy <hrishys@xxxxxxxxxxx> wrote:
>
> Hi
>
> Can TAF be used to detect node failover and redirect
> the connections to a new node using retry and delay so
> all my clients detect that host db1 is down and need
> to start connecting to db2 .
>
> I am not using RAC.Oracle version is 10.2
>
>
>
> GRID =
>   (DESCRIPTION =
>     (ADDRESS = (PROTOCOL = TCP)(HOST =
> my.db1.com)(PORT = 1521))
>     (ADDRESS = (PROTOCOL = TCP)(HOST =
> my.db2.com)(PORT = 1521))
>     (LOAD_BALANCE = yes)
>     (CONNECT_DATA =
>       (SERVICE_NAME = grid)
>       (FAILOVER_MODE =
>         (TYPE = SELECT)
>         (METHOD = BASIC)
>         (RETRIES = 1)
>         (DELAY = 1)       )
>      )
>    )
>
>
>
>       __________________________________________________________
> Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>


-- 
Jeremy Schneider
Chicago, IL
http://www.ardentperf.com/category/technical

Other related posts: