Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Remote database

Re: Remote database

From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Tue, 11 Feb 2003 17:15:47 GMT
Message-ID: <MPG.18b2cf996c911e0f989698@news.la.sbcglobal.net>


hillar_at_medisoft.ee said...
> Hello,
> how to check remote datatabase is up or down,
> link exist & if remote database is up all work fine,
> but if remote database is down i have big timeout &
> some meory problems
> Hill
>

Depends on your client's o/s, which you didn't supply. If your client is unix-like, you can wrap the following in a shell script and grep the return string.

You can issue a "lsnrctl services" and check the return to see if you have a dispatcher or dedicated server with established connections. This should be pretty quick, since you don't have to wait for a database timeout and the listener always knows when the database goes up/down.

You can always issue a "select * from dual_at_remotedb" and get back success/failure. Of course, if the database is down, you'll have to wait for a timeout.

-- 
/Karsten
Received on Tue Feb 11 2003 - 11:15:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US