Re: TNSPING from PL/SQL?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 21 Dec 2005 21:34:33 +0100
Message-ID: <e0fjq1p5d0mofa4fgtk4kl0qug1eknr3ti@4ax.com>

On 21 Dec 2005 11:57:00 -0800, "J.A. Cooper" <julius.cooper_at_gmail.com> wrote:

>This is a replicated environment, so the "site is down" issue should be
>handle by the application (switching to the other db, etc.), and does
>not require intervention from myself or other DBAs.

This facility is known as transparent application failover and can be handled quite nicely by sql*netl when set up appropiately. There is no need to re-invent the wheel.

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed Dec 21 2005 - 14:34:33 CST