How to check whether a database link is active
312899Feb 26 2007 — edited Mar 2 2007I have two databases which are connected with each other through a db link.
Now under normal circumstances the link is available and fast, but sometimes the second database is, for whatever reason, not available. In such a case i get a ORA-12535 error message. Naturally after some minutes, when the timeout run out.
I would like to know, whether there is a possibility to check from within a pl/sql package whether the db link is up or not, something like tnsping.