Re: Oracle error 03113 (end-of-file on comm channel)

Hi.

 I got something like that.
 Bypassed it by calling stored proc via dblink. The stored proc issued  DELETE locally.

 HTH. Michael.

In article <85apm8$o8k$1_at_nnrp1.deja.com>,   durstd_at_advisory.com wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Jan 09 2000 - 14:28:08 CST