Oracle Error 3113 Import
Contents |
& MappingSocial Networking & CommunicationUtilitiesWeb BrowsersComputer & HardwareGadgetsGaming & LeisureSmartphonesMobile AppsWindows Mobile (Pocket PC / PPC)Networking Oracle Database Import Error 3113/3114 Home»Software»Databases»Oracle Database Import Error 3113/3114 Oracle Database Import Error 3113/3114 When oracle error 3114 trying to import the Oracle export dump into Oracle
Imp 00058 Oracle Error 3113 Encountered
database, the following errors occur:
IMP-00003: ORACLE error 3113 encountered ORA-03113: end-of-file on communication imp-00003 oracle error 3113 encountered channel IMP-00003: ORACLE error 3114 encountered ORA-03114: not connected to ORACLE The errors occur on Oracle database installed in Windows machine too.Ora-03113: End-of-file On Communication Channel
Actually the problem can occurs in any platform of Oracle database. It usually happens when try to import into new database. The problem occurs because imp utiliy encounters error out when trying to execute some commands. The solution to solve the problem is as following: Login as sys in the SQLPLUS and run the following sqls $OH/rdbms/admin/dbmsread.sql $OH/rdbms/admin/prvtread.plb After executing the above sql scripts, retry the import. The error should disappears. You May Also Interested In: Oracle EXP-00091 Error When Export DatabaseIMP-00013 Oracle Import ErrorIMP-00016 Required Character Set Conversion Not Supported…Change Oracle Database User Password By LK| 2014-12-24T11:24:49+00:00 December 15th, 2005|Categories: Databases|Tags: Oracle Database|1 Comment About the Author: LK LK is a technology writer for Tech Journey with background of system and network administrator. Connect with LK through Tech Journey on Facebook, Twitter or Google+. Anjesh Kamboj I have also faced the same problem. I have tried the above solution but the same was still there. I have checked the log file, there are a procedure failure every time while importing. I have skipped the same procedure while importing and problem
IMP-00003: ORACLE error 3114 encountered If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 5 of 5 Thread: Urgent: IMP-00003: ORACLE error 3114 encountered Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode https://techjourney.net/oracle-database-import-error-31133114/ 07-21-2005,12:36 PM #1 Unna View Profile View Forum Posts Member Join Date Nov 2000 Posts 164 Urgent: IMP-00003: ORACLE error 3114 encountered Dear all, I am trying to replicate a production database by using import and export utilities. My production database is in Unix HP and the new database is going to be on Windows XP, and both database servers are in Oracle 9.2.0.6. http://www.dbasupport.com/forums/showthread.php?48232-Urgent-IMP-00003-ORACLE-error-3114-encountered The export was done successfully; however I got the following errors during importing: 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 The import command is: C:\> imp system/pwd file=full.dmp full=y log=full.log buffer=64000 Or C:\> imp / file=full.dmp full=y log=full.log buffer=64000 Prior to the import, I created all the tablespaces; however, none of data from any schema got imported since there was no connection to the database. Also when I tried to login as system, I got invalid password error. I have to alter user in order to login. Can anyone tell me why the system or OS authenticated user password got changed during the import? And how do I prevent from getting the IMP-00003 error? Any help is appreciated. Thanks, Unna Reply With Quote 07-21-2005,12:49 PM #2 hannah00 View Profile View Forum Posts Member Join Date Jan 2005 Posts 221 make sure you have you environment path set: on windows do: export ORACLE_SID=BLUH on linux do: export ORACLE_SID=bluh Reply With Quote 07-21-2005,01:18 PM #3 Unna View Profile View Forum Posts Member Join Date Nov 2000 Posts 164 Thanks
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time https://www.experts-exchange.com/questions/20786191/ORA-03113-end-of-file-on-communication-channel-while-importing.html Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > ORA-03113:end of file on communication channel -- while importing Want to Advertise Here? Solved ORA-03113:end of file on communication channel -- while importing Posted on 2003-11-03 Databases 1 Verified Solution 3 Comments 5,912 Views Last Modified: 2012-08-13 oracle error 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 oracle error 3113 help? kp_prasanth@hotmail.com 0 Question by:kpprasanth Facebook Twitter LinkedIn Google LVL 7 Best Solution byyoren 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 Go to Solution 1 Comment LVL 7 Overall: Level 7 Databases 1 Message Accepted Solution by:yoren2003-11-03 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 Write Comment First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. Comment Submit Your Comment By clicking you are agreeing to Experts Exchange's Terms of Use. Featured Post IT, Stop Being Called Into Every Meeting Promoted by Highfive Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any roo