Re: TAF and node failover non RAC oracle 10.2
- From: "LS Cheng" <exriscer@xxxxxxxxx>
- To: hrishys@xxxxxxxxxxx
- Date: Wed, 30 Jan 2008 11:35:19 +0100
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@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
>
>
>
Other related posts: