Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Unexpected Oracle error message
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