Exp-00056 Oracle Error 3113 Encountered
Contents |
Topic Database design Database Admin View All Cloud infrastructure Availability Backup and recovery Export, import and migration Installation, upgrades and patches Oracle performance problems and tuning Oracle security Oracle DBA tools Error messages MySQL database Real Application Clusters exp 00056 oracle error 24324 encountered (RAC) Applications View All Enterprise and business performance management Implementing and exp 00056 oracle error 12154 encountered upgrading Oracle apps E-Business Suite Fusion applications Hyperion JD Edwards (JDE) PeopleSoft Siebel and Oracle CRM Data Mgmt exp 00056 oracle error 1017 encountered View All BI (business intelligence) Data quality Data warehousing Metadata Database Admin View All Cloud infrastructure Availability Backup and recovery Database design Export, import and migration Installation, upgrades and
Exp 00056 Oracle Error 1034 Encountered
patches Oracle performance problems and tuning Oracle security Oracle DBA tools Error messages MySQL database Real Application Clusters (RAC) Development View All BPEL in Oracle Open Source SQL Java / J2EE Stored procedures XML PL/SQL Fusion View All Oracle and BEA Application Server Data and application integration SOA (service-oriented architecture) Infrastructure View All Cloud computing infrastructure Exadata and Exalogic Grid computing Oracle on Linux Operating system Oracle hardware decisions Virtual machine Oracle management View All certification Oracle acquisitions Business process management Market analysis DBA jobs training and certification Small businesses Regulatory compliance Outsourcing Oracle on demand and SaaS Oracle strategy and product roadmap Oracle support services Oracle vs. SAP Oracle Web 2.0 Sun-Oracle infrastructure View All Oracle cloud computing Oracle OS Oracle virtualization Topics Archive View All Oracle DBA jobs Oracle Resources Training and certification Tutorials, tips and FAQs Please select a category Applications Data Mgmt Database Admin Development Fusion Infrastructure Oracle management Sun-Oracle infrastructure Section Problem Solve News Get Started Evaluate Manage Problem Solve Sponsored Communities Q EXP-00056 and ORA-03113 errors Using exp80 for Oracle8 release 8.0.4.0.0 on WinNT, Full=Y. This command did not cause any problem until a few days ago, when I encountered problems whereby not all tables were exported. I got these errors: "EXP-00056: ORACLE error 3113 encountered" and "ORA-03113: end-of-file on communication channel." Sections Share this item with your network: Related Expert Q&A ORA-03113 error on Oracle 7.3.4 &
2011 22:57 mahmud732 Messages: 74Registered: October 2009 Location: Dhaka Member Dear All, When I am trying to get backup the following error occured in a specific table. Error Description: ORA-00056 is means DDL lock on object 'string.string' is already held in an incompatible mode. How can I resolve this. Please help me. Regards Mahmud Report message to a moderator Re: Backup [message #518439 is a reply to message #518437] Wed, 03 August 2011 23:11 Michel Cadot Messages: 63882Registered: March 2007 Location: Nanterre, France, http://... Senior MemberAccount Moderator Copy and paste all what you did and got. Before, http://searchoracle.techtarget.com/answer/EXP-00056-and-ORA-03113-errors Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read. Make sure that lines of code do not exceed 80 characters when you format. Indent the code, use code tags and align the columns in result. Use the "Preview Message" button to verify. Also always post your Oracle version, with 4 decimals. Regards Michel Report message to a moderator http://www.orafaq.com/forum/t/173655/ Re: Backup [message #518440 is a reply to message #518437] Wed, 03 August 2011 23:11 BlackSwan Messages: 24942Registered: January 2009 Location: SoCal Senior Member 00056, 00000, "DDL lock on object '%s.%s' is already held in an incompatible mode" // *Cause: An attempt was made to acquire a DDL lock that is already locked. // *Action: This happens if you attempt to drop a table that has parse locks // on it. It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/ Report message to a moderator Re: Backup [message #518442 is a reply to message #518439] Wed, 03 August 2011 23:26 mahmud732 Messages: 74Registered: October 2009 Location: Dhaka Member Thanks for cooperation. This was the execution report when i run the export command: C:\>EXP USERID=IPL/IPLSERVER@PRAGATI TABLES=(PRBM) FILE=D:\IPL.DMP Export: Release 9.0.1.1.1 - Production on Thu Aug 4 10:21:33 2011 (c) Copyright 2001 Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production With the Partitioning option JServer Release 9.0.1.1.1 - Production Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set About to export specified tables via Conventional Path ... . . exporting table PRBM EXP-00056: ORACLE error 3113
9i export utility to export 10g database.I have the following errors:EXP-00056: ORACLE error 3123 encounteredORA-03123: operation would blockEXP-00056: ORACLE error 3127 encounteredORA-03127: no new operations allowed http://dbaforums.org/oracle/lofiversion/index.php?t7925.html until the active operation endsEXP-00056: ORACLE error 3127 encounteredORA-03127: no new operations allowed until the active operation endsEXP-00056: ORACLE error 3127 encounteredORA-03127: no new operations allowed until the active operation endsEXP-00056: ORACLE error 3127 encounteredORA-03127: no new operations allowed until the active operation endsEXP-00000: Export terminated unsuccessfullyAny one can help? Ben Prusinski Oracle DBA Aug 14 2007, 06:45 PM Hello,So iam using the 9i export utility to oracle error export 10g database.You cannot do that. You need to use the Oracle 10g version of export. dave Aug 15 2007, 02:46 AM QUOTE (Ben Prusinski Oracle DBA @ Aug 15 2007, 12:46 AM) Hello,So iam using the 9i export utility to export 10g database.You cannot do that. You need to use the Oracle 10g version of export.yes you can do that, you can always use the lower version 00056 oracle error in case you want to move data from 10g to 9ithe problem is with the actual DB who is not allowing operations to take place odibat Aug 15 2007, 10:41 AM I tried to perform the exp in the 10g machine, and it works fine.(command : exp username/password ...)meaning, there is no problem in the DB itself. Asad Aug 15 2007, 12:23 PM QUOTE (odibat @ Aug 15 2007, 03:42 PM) I tried to perform the exp in the 10g machine, and it works fine.(command : exp username/password ...)meaning, there is no problem in the DB itself.stop/terminate all exp processes and re-try. odibat Aug 15 2007, 12:35 PM I tried the exp many times..but the same error appear each time.Iaslo tried to export only one table, it works without problem...I am not sure if the reason of the problem is in timeout or in the size of my db, Note: when I used exp in the same machine, which has oracle 10g, with optioncompress=y..the file size was about 9 gb. odibat Aug 15 2007, 12:53 PM error message:EXP-00056: ORACLE error 3113 encounteredORA-03113: end-of-file on communication channelEXP-00056: ORACLE error 24324 encounteredORA-24324: service handle not initializedEXP-00056: ORACLE error 24324 encounteredORA-24324: service handle not initializedEXP-00056: