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."
EXP-00056: ORACLE error 3113 encountered ORA-03113: end-of-file on communication channelI'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/catexpThese 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.