Re: TAF and node failover non RAC oracle 10.2

From: hrishy <hrishys_at_yahoo.co.uk>
Date: Wed, 30 Jan 2008 16:59:54 +0000 (GMT)
Message-ID: <807159.66687.qm@web27808.mail.ukl.yahoo.com>

Hi Cheng

Thanks again .

I was looking into the active passive failover .

What TCP settings need to be changed for windows server so that the failover happens in say about 5-8 secs.

regards
Hrishy
--- LS Cheng <exriscer_at_gmail.com> wrote:

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

---

Yahoo! Answers - Got a question? Someone out there knows the answer. Try it now.
http://uk.answers.yahoo.com/

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

Received on Wed Jan 30 2008 - 10:59:54 CST