title: How to check if an oracle remote database is online?
body: <p>I have a db link from DB1 to DB2. I have a job that runs a procedure that uses the contents on DB2, however, I would like the procedure to first check if DB2 is online and the dblink is working, if not then stop exit the procedure. Is there a function or command that checks if the remote database is online? </p>