Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Unexpected Oracle error message

Unexpected Oracle error message

From: Michael R. Shoop <mshoop_at_iname.com>
Date: Thu, 25 Jun 1998 16:27:04 GMT
Message-ID: <359275ff.29031816@news.clark.net>


This is going to be somewhat ambiguous, but I try to explain the situation in as much detail as possible.

I'm using Oracle 7.3.2 on Solaris 2.5.1 in conjunction with oraperl. In testing my application, I have to drop a temporary database user, re-create the temporary database user, and re-create tables for the database user by selecting the tables from yet another database user. I then process the information within the temporary database's tables before inserting the data into a third database user. I'm using oraperl with a combination of sql files and stored packages. The problem is that occasionally, while processing the information, Oracle will generate an error ORA-03113 : end-of-file on communication channel. Once this occurs, I'm disconnected from Oracle and cannot reconnect. I've tried to login using svrmgrl and get kicked back to the command line. I can't shut down Oracle without rebooting the machine or manually killing the Oracle processes.

Can anyone give me a clue as to what may cause this type of problem or what I might check?

Any help would be appreciated.

Thanks in advance,

Mike Received on Thu Jun 25 1998 - 11:27:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US