Re: Client failover with 10g DG

From: Martin Klier <usn_at_usn-it.de>
Date: Tue, 18 Jan 2011 12:07:27 +0100
Message-ID: <4D35746F.7060804_at_usn-it.de>



Hi,

I am doing it this way
 http://www.usn-it.de/index.php/2007/06/28/how-to-fail-over-a-client-transparently-in-a-dataguard-switchoverfailover-scenario/

for years now, it works like a charm.

Regards
Martin Klier

Ram Raman schrieb:
> Listers,
>
> I am doing some research on setting up v10.2 DG for couple of our
> databases. They both will be single instance DBs. We are looking into
> the new client connections automatically going to the standby in case of
> failover and the configuration of client tns. I am looking into creating
> services based on this
> <http://prutser.files.wordpress.com/2008/12/client_connectivity.pdf>
> paper. It seems to
>
> What do other listers do to automate client failover in case of primary
> instance failure. Is using triggers with services a reliable way of
> failing over to standby (the new primary) ? Any surprises there?
>
> Thanks.
>

-- 
Usn's IT Blog for Linux, Oracle, Asterisk
http://www.usn-it.de

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 18 2011 - 05:07:27 CST

Original text of this message