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

From: <durstd_at_advisory.com>
Date: Sun, 09 Jan 2000 20:05:36 GMT
Message-ID: <85apm8$o8k$1@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 - 14:05:36 CST