I have tried importing five times using Telnet, and I have received the below message every time, even though I have exported succesfully again using the same Telnet login to the database server. Then importing resulted in the same message. The DB server is Oracle Release 184.108.40.206.0. A few days back I had done it successfully but now it's throwing this error. Kindly help.
IMP-00003: ORACLE error 3113 encountered ORA-03113 end-of-file on communication channel IMP-00000: import terminated unsuccessfully
Are the errors listed in your question accompanied by any other errors? Do you see any errors in the alert log of the database that you are attempting to import into? Are you exporting from the same release as you are attempting to import into (i.e., 220.127.116.11)? Intermittent problems like these are difficult to troubleshoot without more information. There are documented problems with these exact errors if importing transportable tablespaces, but since you do not mention this, I assume that this does not apply in your situation.
The ORA-3113 error is usually reported by a client process connected to an Oracle database. The error basically means the client cannot communicate with the Oracle shadow process. This could be related to network issues, or the Oracle process was killed at the operating system level. It could also point to an Oracle Net problem. Check to see if there are any errors in the sqlnet.log file. Also check for trace files in USER_DUMP_DEST. Information in these log files should assist in troubleshooting this problem.
Dig Deeper on Oracle database installation, upgrades and patches
Related Q&A from Maria Anderson
Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ... Continue Reading
I'm getting errors while installing the Database Configuration Assistant. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.