Q

Import failing

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 9.2.0.1.0. A few days back I had done it successfully but now it's throwing this error.

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 9.2.0.1.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., 9.2.0.1)? 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.

This was first published in June 2006

Dig deeper on Oracle database installation, upgrades and patches

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

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

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close