It would appear that the client is lossing connection with the oracle
process.
This could be due to the application fault, however I would be checking the
dblink between the dev svr and the prod svr. The 3113 error is stating that
the prod svr has closed the connection to dev svr.
If running MTS check init.ora parameter, or even attempt disabling it.
<durstd_at_advisory.com> wrote in message news:85apm8$o8k$1_at_nnrp1.deja.com...
> Having a frustrating recurring error.
>
> Daily Scenario:
> 1) VB5 app running on development server runs many (about 16) queries
> on Development Oracle 8.0 system.
> 2) After some simple inserts and updates on the dev DB, it starts
> running update and delete queries on production DB via a database link
> (the DBs reside on different machines). But it's still in the same
> session (app using the same connection to dev DB).
> 3) Update queries complete, delete query does not. Error it spits out:
> "ORA-02055: distributed update operation failed; rollback required ORA-
> 02068: following severe error from WEBPRO ORA-03113: end-of-file on
> communication channel"
>
> The 03113 is clearly the root of this, but there is no trace file and
> the connection used has been established.
>
> Complexities:
> 1) This run completes when the delete statement has no rows to delete.
> 2) This problem has not always happened, system ran smoothly for 6
> months. Problem surfaced, progressed to sometimes, now daily.
>
> Any ideas on either the true nature of the error or how to approach
> solving it? Stress level getting very high...
>
> durstd_at_advisory.com
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Jan 09 2000 - 20:29:59 CST
