Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-03113 end-of-file on communication channel
A copy of this was sent to Vivek Chaudhari <vchaudhari_at_hotmail.com>
(if that email address didn't require changing)
On Thu, 06 Aug 1998 14:11:29 -0400, you wrote:
>Hi All
>
> We are receiving this error message for some time now.
>
>ORA-03113 end-of-file on communication channel
>
>
>Can anyone tell what may be the possible causes for this error.
>
>Thanx in advance.
>Viv
when you get a 3113, a trace file on your database server is generated. In this trace file you will (usually) find the statement that is causing the error. You should take the contents of these trace files and get them to support -- 3113 can be cause by many many things. It means the Oracle backend has 'gone away' in effect.
If you review your alert_$ORACLE_SID.log file, you'll see a message when this occurrs, this message will contain the location of the trace file. You can also find it by finding out what your user_dump_dest init.ora parameter is set to
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Thu Aug 06 1998 - 13:48:56 CDT