ORA-03113: end-of-file on communication channel
Home > IT Answers > Oracle > ORA-03113: end-of-file on communication chann...
OracleATE
190 pts.
0
Q:
ORA-03113: end-of-file on communication channel
Oracle error messages, Oracle SQL, SQLPlus, SQL, ORA-03113
I am running a database health report which consists of many SQLs against the data dictionary. Every SQL returns fine except one querying for chained/ migrated rows which takes a little more time, and I get the following:

ERROR at line 1:
ORA-03113: end-of-file on communication channel


I am running this script as part of Unix shell script. But when I run the same SQL from my SQLPLUS client; it works fine.

How do I overcome this error?
ASKED: Feb 3 2009  3:54 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Sktom
60 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
There really is not enough information here to make a good diagnosis.

I would suggest that you insert a "set -x" command on the second line of your Unix shell script. This will show you what is being executed as far as Unix is concerned.

My suspicion - only a suspicion! - is that there are one or more characters that SQLPlus or Unix does not interpret correctly and the script is just giving up.
Last Answered: Feb 10 2009  7:12 PM GMT by Sktom   60 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Carlosdl   29820 pts.  |   Feb 3 2009  6:48PM GMT

That error usually means network problems while trying to communicate to the database or between db-linked databases.
When it runs fine from SQL*Plus, you run it from the same machine that you do when it fails (from the unix script) ?

 
0