Re: TAF and node failover non RAC oracle 10.2

hrishy

you need to use Fast Connection Failover for that purpose which is based on Fast Application Notification mechanism

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