Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

ORA-03113:end of file on communication channel -- while importing

Posted on 2003-11-03
3
Medium Priority
?
6,108 Views
Last Modified: 2012-08-13
i tried to import a dmp file into oracle 9i (9.2.0.4.0), in WIN 2000 Server, which was exported from a 9i db in Solaris .
I got the following error :
IMP-00003 - ORACLE ERROR 3113 ENCOUNTERED.
ORA-03113 :END OF FILE ON COMMUNICATION CHANNEL.
IMP-00003 :ORACLE ERROR 3114 ENCOUNTERED.
ORA-03114:NOT CONNECTED TO ORACLE.

I created another dump and tried the import and its working fine.
Could anyone help?

kp_prasanth@hotmail.com
0
Comment
Question by:kpprasanth
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 7

Accepted Solution

by:
yoren earned 500 total points
ID: 9671608
ORA 3113 just means you got disconnected from the database. That could be because of a corrupt dump file or because of a server problem. Look in the Oracle server's alert log for the details. It will point you to a trace file (something.trc) which will have detailed info on what happened.
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question