Re: Remote database

Hillar Vetik wrote:

> how to check remote datatabase is up or down,

The only way to check is to make a connection and see if it succeeds or not.

> link exist & if remote database is up all work fine,

You can check the data dictionary view USER_DB_LINKS to see if the link exists.

You probably can also turn this into a PL/SQL package that can test the link's existance for you, open a connection and handle & report any exceptions.

> but if remote database is down i have big timeout &
> some meory problems

Ora error message number? Ah.. you mean you get the error message that shared memory does not exist. That is a normal message when you attempt to connect to a database that is down.

All you need to do is implement an exception handler. Catch this error and handle it accordingly.

Oracle tells you there is an error. It is up to your code to decide how it will handle that error. Oracle can not handle it for you.

--
Billy