Re: Remote database

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