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

190 pts.
Tags:
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    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) ?
    69,920 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following