Re: test if dblink is up

From: Andreas Moroder <Andreas.moroder_at_[nospam>
Date: Fri, 13 Oct 2006 07:20:26 +0200
Message-ID: <egnb1h$4e5$1@news.dtag.de>

DA Morgan schrieb:
> Andreas Moroder wrote:
>

>> Hello,
>>
>> we have a DB-Link over a WAN. When the dblink goes down the 
>> application blocks and gets a oracle error only after 30 minutes.
>>
>> Is there a way to test if a dblink is up whit a shorter timeout ( say 
>> 30 seconds ) ?
>>
>> Thanks
>> Andreas

>
>
> SELECT sysdate
> FROM dual@<remote>;
> should return rather quickly.
>
> But the nature of your "application" might be important to know.
> Version, operating system, etc. helpful.
Hello Daniel,

on the "client" side we have
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production running on Linux SLES

The application is ( don't laugh ) clipper and uses mediator ( www.otc.pl ) to access the oracle DB

Bye
Andreas Received on Fri Oct 13 2006 - 00:20:26 CDT