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>
)
Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com
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-lReceived on Wed Jan 30 2008 - 03:19:37 CST