Oracle Error 3113 Export
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 5 Replies Latest reply on Nov 16, 2009 11:35 AM by onkar.nath ORA-03113: end-of-file on communication channel onkar.nath Nov 9, 2009 4:29 AM All, While running exp command, I am getting below error: . exporting synonyms EXP-00008: ORACLE error 3113 encountered ORA-03113: end-of-file on communication channel EXP-00000: Export terminated unsuccessfully when I checked alert log, I found below entry: Errors in file /u01/app/oracle/admin/DEVOLTP/udump/devoltp_ora_13720.trc: ORA-07445: exception encountered: core dump [jon_get_ncomp_method_fptr()+59] [SIGSEGV] [Address not mapped to object] [0x23] [] [] then I looked into the trace file mentioned there and it says this: ksedmp: internal or fatal error ORA-07445: exception encountered: core dump [jon_get_ncomp_method_fptr()+59] [SIGSEGV] [Address not mapped to object] [0x23] [] [] Current SQL statement for this session: SELECT SYNNAM, DBMS_JAVA.LONGNAME(SYNNAM), DBMS_JAVA.LONGNAME(SYNTAB), TABOWN, TABNODE, PUBLIC$, SYNOWN, SYNOWNID, TABOWNID, SYNOBJNO FROM SYS.EXU9SYNU ORDER BY SYNTIME I tried finding the solution in metalink also but somehow I could not locate any document related to this. Any idea how to take care of this error. Database : Oracle 9i R2 OS : Linux rcdb4 2.6.9-42.0.0.0.1.ELsmp #1 SMP Sun Oct 15 14:02:40 PDT 2006 i686 i686 i386 GNU/Linux Please Advise.. TIA, Onkar 2147Views Tags: none (add) This content has been marked as final. Show 5 replies 1. Re: ORA-03113: end-of-file on communication channel stellios Nov 9, 2009 4:38 AM (in response to onkar.nath) Most likely you have hit a bug - raise a Service Request with Oracle support. Like Show 0 Likes(0) Actions 2. Re: ORA-03113: end-of-file on communication channel Kamran Agayev A. Nov 9, 2009 5:01 AM (in response to onkar.nath) onkar.nath wrote: All, While running exp command, I am getting below error: . exporting synonyms EXP-00008: ORACLE error 3113 encountered ORA-03113: end-of-file on communication channel EXP-00000: Export terminated unsuccessfully when I checked alert log, I found below entry: Errors in file /u0
& 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 errors occur:
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 errors occur on Oracle database installed in Windows machine too. Actually the problem can occurs in any https://community.oracle.com/thread/985975 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 https://techjourney.net/oracle-database-import-error-31133114/ $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 subscrand ORA-03113: end-of-file on communication channel in oracle 10g 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: http://www.dbasupport.com/forums/showthread.php?49566-ORA-07445-and-ORA-03113-end-of-file-on-communication-channel-in-oracle-10g click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Page 1 of 2 12 Last Jump to page: Results 1 to 10 http://www.dbforums.com/showthread.php?925439-Error-while-export-in-oracle-9i of 12 Thread: ORA-07445 and ORA-03113: end-of-file on communication channel in oracle 10g Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to oracle error Threaded Mode 11-16-2005,11:06 PM #1 Asharam View Profile View Forum Posts Junior Member Join Date Nov 2005 Posts 11 ORA-07445 and ORA-03113: end-of-file on communication channel in oracle 10g Hi DBAs, I required you expertise here.... I am facing below problem in oracle 10g on linux. After enabling the JAVA in the database, when I try to export the database, I am getting the below error: ORA-03113: end-of-file on communication channel[FONT=Verdana][SIZE=1] oracle error 3113 This error also comming when I run the utlrp.sql to validate objects. I checked the alert log file and trace files, and I found the below error.... ORA-07445: exception encountered: core dump [joe_well_known_internal()+102] [SIGSEGV] [Address not mapped to object] [0x1FA7C878] [] [] I gone through the various posts and I found some body saying classpath issue or incomplete installation of java. I taken care of both the above issue. I have properly set the classpath in profile file and reinstalled the java two times. But this didn't help me.... Can any body give there valuable openion on this issue...... Your help will be greatly appreciated...... Thanks Asharam Reply With Quote 11-16-2005,11:42 PM #2 engiri View Profile View Forum Posts Senior Member Join Date Apr 2003 Posts 353 Have you applied all os level pathces? What is your os version Reply With Quote 11-17-2005,12:35 AM #3 Asharam View Profile View Forum Posts Junior Member Join Date Nov 2005 Posts 11 Below is "uname -a" output All the patches required by the oracle has been applied already. #uname -a Linux 2.4.21-27.ELsmp #1 SMP Wed Dec 1 21:59:02 EST 2004 i686 i686 i386 GNU/Linux its a RedHat Linux 3 Reply With Quote 11-17-2005,01:00 AM #4 engiri View Profile View Forum Posts Senior Member Join Da
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 4 of 4 Thread: Error while export in oracle 9i Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 09-24-03,23:07 #1 D.Ramesh View Profile View Forum Posts Registered User Join Date Sep 2003 Posts 12 Unanswered: Error while export in oracle 9i Hi , My database is oracle9i in winNT. While exporting the database as sys with full=y my export terminated unsucessfully. . . exporting table DESSTEPS 157500 rows exported . . exporting table GROUPS 11 rows exported . . exporting table HISTORY 127134 rows exported . . exporting table HOSTS 0 rows exported . . exporting table HOST_GROUP 0 rows exported . . exporting table HOST_IN_GROUP 0 rows exported . . exporting table LOCKS 0 rows exported . . exporting table MAILCOND 0 rows exported . . exporting table MODULES 5 rows exported . . exporting table REPORTS 0 rows exported . . exporting table REQ 479 rows exported . . exporting table REQ_COVER 2736 rows exported . . exporting table RUN 15619 rows exported . . exporting table SEQUENCES 21 rows exported . . exporting table STEP EXP-00056: ORACLE error 3113 encountered ORA-03113: end-of-file on communication channel EXP-00056: ORACLE error 24324 encountered ORA-24324: service handle not initialized EXP-00056: ORACLE error 24324 encountered ORA-24324: service handle not initialized EXP-00056: ORACLE error 24324 encountered ORA-24324: service handle not initialized EXP-00056: ORACLE error 24324 encountered ORA-24324: service handle not initialized EXP-00002: error in writing to export file EXP-00000: Export terminated unsuccessfully How to ix this ? Many Thanks, Reply With Quote 09-25-03,02:21 #2 berxh3g View Profile View Forum Posts Visit Homepage Registered User Join Date Jan 2003 Location Vienna, Austria Posts 102 Re: Error while export in oracle 9i the main problem here is the "ORACLE error 3113" (also called ORA-3