Solved

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

Posted on 2006-10-23
11
1,626 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 85 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 83 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 83 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
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 
LVL 48

Assisted Solution

by:schwertner
schwertner earned 83 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 83 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 83 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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Create Index on a Materialized View 5 64
UTL_FILE invalid file operation 5 60
Pass multiple values or string arrays in java as a parameter 3 74
SQL Syntax Question 9 57
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

710 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