Oracle Error 3113 Encountered 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 trying to import the Oracle export dump into Oracle database, the following
Oracle Error 3114
errors occur:
IMP-00003: ORACLE error 3113 encountered ORA-03113: end-of-file on communication imp 00058 oracle error 3113 encountered channel IMP-00003: ORACLE error 3114 encountered ORA-03114: not connected to ORACLE The errors occur on Oracle database imp-00003 oracle error 3113 encountered installed in Windows machine too. Actually the problem can occurs in any platform of Oracle database. It usually happens when try to import into new database. The problem occursOra-03113: End-of-file On Communication Channel
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 is sorted out. anjesh kamboj Haryana(India) Tech Journey Follow @TechJourneyNet Subscribe to Blog via Email Enter your email address to subscribe to this blog and receive notifications of new posts by email. Join 9,674 other subscribers Email Address Popular Recent Comments Unable to Sign In to Microsoft Money 2007 with Windows Live ID in Vista May 1st, 2007 Microsoft Money 2007 Unable to Connect to Internet to Sign In Online in W
#121231] Fri, 27 May 2005 01:49 8683 Messages: 2Registered: May 2005 Location: india Junior Member while importing dump file. i am getting this error. IMP-00058: ORACLE error 3113 encountered ORA-03113: end-of-file on communication channel IMP-00000: Import terminated unsuccessfully thanks in advance [Updated on: Fri, 27 May 2005 02:10]Report message to a moderator Re: ORACLE error 3113 encountered [message #121245 is a reply to message #121231] Fri, 27 May 2005 02:52 skooman Messages: 912Registered: March 2005 Location: Netherlands Senior Member From the reference: "ORA-03113: end-of-file on communication channel Cause: The connection between Client and Server process was broken. Action: There https://techjourney.net/oracle-database-import-error-31133114/ was a communication error that requires further investigation. First, check for network problems and review the SQL*Net setup. Also, look in the alert.log file for any errors. Finally, test to see whether the server process is dead and whether a trace file was generated at failure time." You didn't state the Oracle version you work with, but it appears on Metalink that there were some problems with 8.1.6. http://www.orafaq.com/forum/t/46556/2 More info on Metalink. Report message to a moderator Re: ORACLE error 3113 encountered [message #121474 is a reply to message #121245] Mon, 30 May 2005 02:15 8683 Messages: 2Registered: May 2005 Location: india Junior Member hi we are using oracle 9.2 i am attaching log file Attachment: TLM.log (Size: 212.45KB, Downloaded 865 times) Report message to a moderator Re: ORACLE error 3113 encountered [message #121488 is a reply to message #121474] Mon, 30 May 2005 04:14 girish.rohini Messages: 744Registered: April 2005 Location: Delhi (India) Senior Member From Reference: ORA-03113: end-of-file on communication channel Cause: An unexpected end-of-file was processed on the communication channel. The problem could not be handled by the Net8 two-task software. This message could occur if the shadow two-task process associated with a Net8 connect has terminated abnormally, or if there is a physical failure of the interprocess communication vehicle, that is, the network or server machine went down. In addition, this message could occur when any of the following statements/commands have been issued: ALTER SYSTEM KILL SESSION ... IMMEDIATE ALTER SYSTEM DISCONNECT SESSION ... IMMEDIATE SHUTDOWN ABORT/IMMEDIATE/TRANSACTIONAL Action: If this message occurs during a connection attempt, check the se
2007 - 8:21 pm UTC Category: Database � Version: 8.1.6 Whilst you are here, check out some content from the AskTom team: Table Functions, Part 2: Returning complex (non-scalar) datasets Latest Followup https://asktom.oracle.com/pls/asktom/f?p=100:11:::::P11_QUESTION_ID:1492331695311 You Asked Tom, I export a table that has the following constraints: Primary key Unique key Check Why does an import back into the same schema with ignore=y show errors for unique and check constraints but does not show them for primary key constraints that exist also? IMP-00017: following statement failed with ORACLE error 2261: "ALTER TABLE "TABLE1" ADD CONSTRAINT "TABLE1_UK" UNIQUE ("COLUMN2") oracle error USING I" "NDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 24576 NEXT 409600 M" "INEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 50 FREELISTS 1 FREELIST GROUP" "S 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS" ENABLE " IMP-00003: ORACLE error 2261 encountered ORA-02261: such unique or primary key already exists in the table IMP-00017: following statement failed with ORACLE error 2264: "ALTER TABLE "TABLE1" ADD CONSTRAINT "TABLE1_CK" CHECK (column2 oracle error 3113 > '') ENABL" "E NOVALIDATE" IMP-00003: ORACLE error 2264 encountered ORA-02264: name already used by an existing constraint About to enable constraints... Import terminated successfully with warnings. Just Curious . Thanks Peter and we said... ignore=y changes the behavior of CREATE statements. If the CREATE statement failed - no data would be imported. Ignore=y says "go ahead, import the data anyway". The failure of the ALTERS affects nothing -- the data is already imported by then, so we just "fail" them (but continue on) Reviews Write a Review ignore=y May 23, 2002 - 11:31 am UTC Reviewer: X Wang from NJ USA I use ignore=y option when I import the data. It only ignore CREATE TABLE command, but failed in CREATE TYPE command. IMP-00015: following statement failed because the object already exists: "CREATE TYPE "MYTYPE_T" TIMESTAMP '2002-02-10:16:24:15' OID 'F4CDB776D6771" "1D3AD090008C7E98428' " How can I ignore create type command? Thank you Followup May 23, 2002 - 3:31 pm UTC it didn't fail, it just keeps on going. ops$tkyte@ORA817DEV.US.ORACLE.COM> drop user a cascade; User dropped. ops$tkyte@ORA817DEV.US.ORACLE.COM> ops$tkyte@ORA817DEV.US.ORACLE.COM> grant dba to a identified by a; Grant succeeded. ops$tkyte@ORA817DEV.US.ORACLE.COM> ops$tkyte@ORA817DEV.US.ORACLE.COM> @connect a/a ops$tkyte@ORA817DEV.US.ORACLE.COM>