Re: TAF and node failover non RAC oracle 10.2

From: LS Cheng <exriscer_at_gmail.com>
Date: Wed, 30 Jan 2008 13:03:48 +0100
Message-ID: <6e9345580801300403n73e7bc35lde50eede4797c817@mail.gmail.com>


Hi

Not sure what do you mean by non-rac, if its single node how do you Failover connections?

Thanks

--
LSC



On Jan 30, 2008 12:09 PM, hrishy <hrishys_at_yahoo.co.uk> wrote:


> Hi Cheng
>
> Many thanks again for your response.
>
> Is FCF part of RAC or i can use it in non RAC
> instance.
>
> regards
> Hrishy
> --- LS Cheng <exriscer_at_gmail.com> wrote:
>
> > 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
> > >
> > >
> > >
> >
>
>
>
> __________________________________________________________
> Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com
>
-- http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 30 2008 - 06:03:48 CST

Original text of this message