<div>
running a query with table@dblink should recreate the dblink session<br />
<br />
you could do this after app1 starts
</div>


running a query with table@dblink should recreate the dblink session

you could do this after app1 starts

<div>
any suggestions on automating this?
</div>


<div>
Thanks for the additional info. &nbsp;Is the behavior we receive with the ORA error expected when the remote db is shutdown or restarted? &nbsp;Is this common with db links?
</div>


Thanks for the additional info.  Is the behavior we receive with the ORA error expected when the remote db is shutdown or restarted?  Is this common with db links?

<div>
dblinks are not very stable<br />
<br />
they sometimes just fail and then you have to find the session on the remote db and kill them to fix the problem<br />
the db will automatically make new dblink session after they were killed
</div>


dblinks are not very stable

they sometimes just fail and then you have to find the session on the remote db and kill them to fix the problem
the db will automatically make new dblink session after they were killed

<div>
<div class="content wysiwyg-content">
We have two enterprise apps each with their own Oracle 11g database. &nbsp;App2 has a dblink to App1. &nbsp;When App1 is taken offline for scheduled maintenance, and then restored - our dblink is broken. &nbsp;Users run a report and will receive ORA-03114. &nbsp;The error only occurs once because when the user runs the report again there are no issues.<br />
<br />
We are positive the issue is caused when App1 goes offline during a reboot or network outage. <br />
<br />
Is there a way to restore the dblink once App1 is brought online after maintenance?
</div>
</div>


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?

Broken DBLinks in Oracle after network outage or remote DB shutdown

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.