TAF and node failover non RAC oracle 10.2

From: hrishy <hrishys_at_yahoo.co.uk>
Date: Wed, 30 Jan 2008 09:19:37 +0000 (GMT)
Message-ID: <82686.42735.qm@web27815.mail.ukl.yahoo.com>


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
Received on Wed Jan 30 2008 - 03:19:37 CST

Original text of this message