Re: TAF and node failover non RAC oracle 10.2
From: LS Cheng <exriscer_at_gmail.com>
Date: Wed, 30 Jan 2008 13:51:53 +0100
Message-ID: <6e9345580801300451i3cb47a0bxb319d8ce9fe2db23@mail.gmail.com>
Date: Wed, 30 Jan 2008 13:51:53 +0100
Message-ID: <6e9345580801300451i3cb47a0bxb319d8ce9fe2db23@mail.gmail.com>
I dont think that would work if your code does not handle the fan events
thanks
-- LSC On Jan 30, 2008 1:39 PM, hrishy <hrishys_at_yahoo.co.uk> wrote:Received on Wed Jan 30 2008 - 06:51:53 CST
> Hi
>
> Lets assume for a while.
>
> That i have NodeA and NodeB which are in sync using a
> third party replication software.
>
>
>
> regards
> Hrishy
>
>
> --- LS Cheng <exriscer_at_gmail.com> wrote:
>
> > 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
> > >
> >
>
>
>
> __________________________________________________________
> Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com
>
-- http://www.freelists.org/webpage/oracle-l