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

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