Home > IT Answers > Oracle > ORA-03113: end-of-file on communication channel
OracleATE
190 pts.
 ORA-03113: end-of-file on communication channel
ORA-03113, Oracle error messages, Oracle SQL, SQL, SQLPlus
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?

Software/Hardware used:
ASKED: February 3, 2009  3:54 PM
UPDATED: February 10, 2009  7:12 PM
RELATED QUESTIONS
Answer Wiki:
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 Wiki Answer Submitted:  February 10, 2009  7:12 pm  by  Sktom   60 pts.
All Answer Wiki Contributors:  Sktom   60 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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) ?

carlosdl
 63,535 pts.