Broken DBLinks in Oracle after network outage or remote DB shutdown
Posted on 2014-09-29
We have two enterprise apps each with their own Oracle 11g database. App2 has a dblink to App1. When App1 is taken offline for scheduled maintenance, and then restored - our dblink is broken. Users run a report and will receive ORA-03114. The error only occurs once because when the user runs the report again there are no issues.
We are positive the issue is caused when App1 goes offline during a reboot or network outage.
Is there a way to restore the dblink once App1 is brought online after maintenance?