We help IT Professionals succeed at work.

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

luyan
luyan asked
on
Medium Priority
1,729 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
Comment
Watch Question

Database Administrator
CERTIFIED EXPERT
Commented:
"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

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
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
Commented:
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
CERTIFIED EXPERT
Top Expert 2008
Commented:
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.
johnsoneSenior Oracle DBA
CERTIFIED EXPERT
Commented:
One other thing not mentioned...

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

Commented:
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
CERTIFIED EXPERT
Top Expert 2008

Commented:
Share with us the version of Oracle. Sometimes patches remove bugs.
Naveen KumarProduction Manager / Application Support Manager
CERTIFIED EXPERT
Commented:
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
Naveen KumarProduction Manager / Application Support Manager
CERTIFIED EXPERT

Commented:
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
Forced accept.

Computer101
EE Admin
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.