Q
Problem solve Get help with specific problems with your technologies, process and projects.

EXP-00056 and ORA-03113 errors

Using exp80 for Oracle8 release 8.0.4.0.0 on WinNT, Full=Y. This command did not cause any problem until a few days ago, when I encountered problems whereby not all tables were exported. I got these errors: "EXP-00056: ORACLE error 3113 encountered" and "ORA-03113: end-of-file on communication channel."

Using exp80 for Oracle8 release 8.0.4.0.0 on WinNT, Full=Y. This command did not cause any problem until a few days ago, when I encountered problems whereby not all tables were exported. I got this error:
EXP-00056: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
I'd greatly appreciate it if someone could help me with the above issue. Thank you so much.

The ORA-3113 error is a generic error meaning that your communication with the Oracle database has been severed for some unknown reason. The ORA-3113 error rarely gives enough information to diagnose the problem, which can be very frustrating. It has been my experience that when running into this error on export, a needed Data Dictionary object is invalid. You can try to fix this by signing on as SYS and running the following:

@?/rdbms/admin/catalog
@?/rdbms/admin/catproc
@?/rdbms/admin/catexp
These will rebuild the Data Dictionary objects for you.

If this does not fix your problem, then the only recourse is to create a network trace of your session and send the trace files to Oracle Support for analysis.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close