Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

ORA-03113: end-of-file on communication channel

Posted on 2006-10-23
11
Medium Priority
?
1,650 Views
Last Modified: 2008-02-07
Have you seen ORA-03113 before? Why did we get this error? How to fix it?
ORA-00604: error occurred at recursive SQL level 2
ORA-03113: end-of-file on communication channel
0
Comment
Question by:luyan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
11 Comments
 
LVL 35

Accepted Solution

by:
Mark Geerlings earned 340 total points
ID: 17791250
"Have you seen ORA-03113 before?"
Yes

"Why did we get this error?"
I don't know.  It could be a big variety of reasons.

"How to fix it?"
That is not so easy.

The two most-difficult Oracle errors to deal with are:
ORA-03113: end-of-file on communication channel
and
ORA-03114: not connected to ORACLE

The reason these two are the most difficult to deal with, is: the connection to the database server is broken at this point, and you cannot handle these with an "exception" section.

Unfortunately you have to figure out what caused this error, and fix that problem.  There certainly is *NOT* just one cause for this, or one easy fix.

If you need us to help you figure out what caused this, you will have to give us a lot more information, like:
1. your database version
2. your server O/S
3. your client or application server O/S and Oracle version
4. which application do you see this in
5. is this a new procedure or application, or an exisiting one that used to work, but now gets this error
6. do all clients get this, or only some
7. does this happen consistently now, or only randomly
0
 
LVL 18

Assisted Solution

by:Jinesh Kamdar
Jinesh Kamdar earned 332 total points
ID: 17791397
Some of the situations in which i encountered this wierd error are : -

1. Trying to store more chars in a variable than its max. size.
2. Trying to display data much more bigger than the output buffer size.
3. Trying to pass an invalid type of argument in a function call.

Check for these symptoms in ur program by debugging it and try to fix them.

Also, check out a very brief description of this error at http://ora-03113.ora-code.com
0
 
LVL 9

Assisted Solution

by:konektor
konektor earned 332 total points
ID: 17793853
how do you connect to database?
eg. ODBC and JDBC have some parameters saynig, how long can you be connected to DB, how long at maximum can one statement be executed.
but in most cases the error means some network problems or application error hiting some oracle bug
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 48

Assisted Solution

by:schwertner
schwertner earned 332 total points
ID: 17794976
I have met this error on Linux/Unix platform after installing Oracle and changing the Kernel of the OS.
Also can arise after installing additional software on the box.
0
 
LVL 35

Assisted Solution

by:johnsone
johnsone earned 332 total points
ID: 17795486
One other thing not mentioned...

Are there any errors in the alert log that correspond to the time this happened?
0
 
LVL 13

Expert Comment

by:joechina
ID: 17798375
Would you please post your SQL?

As far as I can remember, we had the same error before with a SQL which count(*) from a view.

If you have similar SQL, try to change count(*) to count(1)

There are many other reason might cause this error.

Good Luck
0
 
LVL 48

Expert Comment

by:schwertner
ID: 17801351
Share with us the version of Oracle. Sometimes patches remove bugs.
0
 
LVL 28

Assisted Solution

by:Naveen Kumar
Naveen Kumar earned 332 total points
ID: 17801991
raise a tar ( SR ) with oracle and they will let you know what patch you should apply depending of your db version, platform, etc.

Thanks
0
 
LVL 28

Expert Comment

by:Naveen Kumar
ID: 17802002
we have encountered similar situation in our prod environment and got some patches from oracle support but till now we have not received those errors but i am not sure whether those patches really fixed the problem or not.

Thanks
0
 
LVL 1

Expert Comment

by:Computer101
ID: 20296183
Forced accept.

Computer101
EE Admin
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question