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@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 > > -- > //www.freelists.org/webpage/oracle-l > > >