Re: TAF and node failover non RAC oracle 10.2

I thought you mean failover at run time so I suggested FCF.

If you wanna use as active passive free failover it will work but you will have a problem, depending on platforms tcp timeout can be quite long

The other option is use clusterware and set up active passive. I did this configuration 2 months ago using application VIPs and it works very well and stable.

Thanks

--
LSC

On Jan 30, 2008 10:19 AM, hrishy <hrishys_at_yahoo.co.uk> 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

>

>

>


--
http://www.freelists.org/webpage/oracle-l