I have couple of dblinks. Sometimes due to some other reason, I loose the dblink. The reason could be anything, like database down, listener down, server down, IP change, port closed etc. Since these dblinks are on prodution, users start calling and complaining about the dblink down. Is there a way to know immediately if any db link goes down, so that I can take pro-active measure?
Any suggestion highly appreciated.