Home » SQL & PL/SQL » SQL & PL/SQL » ORA-03113: End of file on communication channel
ORA-03113: End of file on communication channel [message #202679] Fri, 10 November 2006 22:48 Go to next message
umesh19
Messages: 2
Registered: May 2005
Junior Member
Hello World!!!!!

I am using Oracle 10g R2 on Red Hat linux
I am getting the following error when I am trying to execute the pl/sql procedure

ORA-03113: End of file on communication channel

Looking at the trace file in
$ORACLE_HOME/admin/orcl/udump I find following error details.

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
Exception signal: 8 (SIGFPE), code: 1 (Integer divide by zero)
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*

Can anybody suggest some good solution, its very urgent.

UMESH
Re: ORA-03113: End of file on communication channel [message #202688 is a reply to message #202679] Sat, 11 November 2006 00:25 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

About ora - 03113 error happen bcoz of many reason.
so better to look in alert.log file. see there any cue for above error. if yes then start troubleshooting for this error..
and also check any trace file created during ur operation.



Exception signal: 8 (SIGFPE), code: 1 (Integer divide by zero)
I am not sure but try to use "zero_divide" err exception in ur code.


hope this helps.
Mohammad Taj.

Re: ORA-03113: End of file on communication channel [message #202871 is a reply to message #202688] Mon, 13 November 2006 02:26 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
If you look on Metalink for SIGFPE, you'll find quite a few hits for problems that return this error.

I'm guessing that this is a 'Raise a TAR' problem.
Re: ORA-03113: End of file on communication channel [message #202875 is a reply to message #202871] Mon, 13 November 2006 02:34 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi
In most of cases ora-03113 Means "Call Oracle Support".

regards
Taj.
Previous Topic: Web PL: Move up/Move down functionality
Next Topic: Kindly rewrite this code
Goto Forum:
  


Current Time: Sat Dec 10 05:06:23 CST 2016

Total time taken to generate the page: 0.18519 seconds