OraFAQ Forum: Server Administration » ORA-03113: end-of-file on communication channel

Home » RDBMS Server » Server Administration » ORA-03113: end-of-file on communication channel

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-03113: end-of-file on communication channel [message #159531]

Mon, 20 February 2006 03:04

Brayan
Messages: 315
Registered: June 2002

Senior Member

Hi,

I'm trying to execute a package procedure in Oracle Warehouse Builder. Whenever this package is executed. I'm getting a error
as ORA-03113: end-of-file on communication channel and a core dump is generated. Other packages works fine.

Sorry, I could not upload trace file here.

The trace filedoes not show any cause. I checked using

TKPROF <tracefile> <outputfile>

Is there any expert advice?

Brayan.

Report message to a moderator

Re: ORA-03113: end-of-file on communication channel [message #159663 is a reply to message #159531]

Mon, 20 February 2006 19:04

lazycat
Messages: 57
Registered: November 2005

Member

may be some one or some db kill your session

if you used the remote db or resoure restrict db

Report message to a moderator

Re: ORA-03113: end-of-file on communication channel [message #159677 is a reply to message #159531]

Mon, 20 February 2006 22:19

Brayan
Messages: 315
Registered: June 2002

Senior Member

It is not because someone killed the process. Every time I run this process I get this error and trace is dumped. I can not find anything in the trace.

Brayan.

Report message to a moderator

Re: ORA-03113: end-of-file on communication channel [message #159727 is a reply to message #159531]

Tue, 21 February 2006 01:44

lazycat
Messages: 57
Registered: November 2005

Member

i have remenbered the bug of the three part tool of oracle

some time i excute it in sqlplus

or another condition is your code have a invaild code or charactor

you can change it with the ultredit

good luck

Report message to a moderator

Re: ORA-03113: end-of-file on communication channel [message #159738 is a reply to message #159531]

Tue, 21 February 2006 02:54

Brayan
Messages: 315
Registered: June 2002

Senior Member

I do not have any special characters in the code either. I checked in Ultra Edit.

Brayan

Report message to a moderator

Re: ORA-03113: end-of-file on communication channel [message #159894 is a reply to message #159531]

Wed, 22 February 2006 02:28

amit_nanote
Messages: 56
Registered: July 2005
Location: Indore

Member

HI Dear,
You have written a procedure which is provided with the end a time which was not expected, please do check the code or send it on the forum to view in.
regds
Amit

Report message to a moderator

Previous Topic:	temp space blowing
Next Topic:	no. of rows in all tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 15:29:59 CDT 2024