Re: TAF and node failover non RAC oracle 10.2
- From: hrishy <hrishys@xxxxxxxxxxx>
- To: LS Cheng <exriscer@xxxxxxxxx>
- Date: Wed, 30 Jan 2008 16:59:54 +0000 (GMT)
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@xxxxxxxxx> 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@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
> >
> >
> >
>
___________________________________________________________
Yahoo! Answers - Got a question? Someone out there knows the answer. Try it
now.
http://uk.answers.yahoo.com/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
