Re: test if dblink is up

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 13 Oct 2006 08:00:52 -0700
Message-ID: <1160751648.566570@bubbleator.drizzle.com>

Andreas Moroder wrote:
> 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

Not laughing. But I expect a half-dozen consultants are trying to get to your management right now to put that dinosaur to rest.

Reduce the time-out parameter as someone else suggested yesterday.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Fri Oct 13 2006 - 10:00:52 CDT