Oracle Error 39078
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
ORA-39078 tips Oracle Database Tips by Burleson Consulting May 4, 2015 Question: I am getting the ORA-39078 error here on an impdp job: ORA-39065: unexpected master process exception in RECEIVEORA-39078: unable to dequeue message for agent MCP from queue "KUPC$C_1_20140507173659" ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95ORA-06512: at "SYS.KUPC$QUE_INT", line 609ORA-25253: listen failed, queue SYS.KUPC$C_1_20140507173659 is not enabled for dequeue Job "RECORD"."SYS_IMPORT_SCHEMA_32" stopped due to fatal error at 16:13:53 How do I fix this ORA-39078 error? Answer: This error can happen when the streams_pool_size is too small: SQL> alter system set STREAMS_POOL_SIZE=100M scope=spfile;SQL> shutdown immediateSQL> startup Also see the related error ORA-25253. The Oracle oerr utility shows this for the ORA-39078 error: ORA-39078: Unable to dequeue message for agent string from queue "string" Cause: The Data Pump"s communication layer was unable to retrieve a message from the control or status queue. Subsequent messages will detail the problem. Action: Fix the problem if possible, or contact Oracle Customer Support. Also see MOSC note 454639.1 and MOSC Note 790775.1. Oracle Training from Don Burleson The best on site "Oracle training classes" are just a phone call away! You can get personalized Oracle training by Donald Burleson, right at your shop! Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals. Feel free to ask questions onLibrary mySQL Code Library PHP Code Library JavaScript Code Library Oracle Terms & Definitions Oracle Error Codes PSOUG Community Blogs Oracle Jobs Board PSOUG Forum Oracle User Group Directory Free Oracle Magazines http://www.dba-oracle.com/t_ora_39078.htm Online Learning Center PSOUG Presentations Advanced Code Search News and Events Sponsors Page Submit Code Contact Us Oracle Error: ORA-39078 Error Description: Unable to dequeue message for agent string from queue http://psoug.org/oraerror/ORA-39078.htm "string" Error Cause: The Data Pump"s communication layer was unable to retrieve a message from the control or status queue. Subsequent messages will detail the problem. Action: Fix the problem if possible, or contact Oracle Customer Support. There haven't been any comments added for this error yet. You may add one if you like. Add a comment Name: Email: URL: Chars left:1000 (1000 max) (No HTML, but newlines will be preserved) Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us 75 users online © 2009 psoug.org PSOUG LOGIN Username: Password: Forgot your password?
agent string from queue string Cause: The Data Pump s communication layer was unable to retrieve a message from the control or status queue. Subsequent messages will detail the problem. Action: Fix the problem if possible, or contact Oracle Customer Support. Posted by Senthil kumar at 06:53 Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: ORA-39078, ORA-39078: unable to dequeue message for agent string from queue string No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Search This Blog Loading... Translate Blog Archive ▼ 2012 (10441) ► January (1747) ► Jan 02 (7) ► Jan 03 (60) ► Jan 04 (60) ► Jan 05 (60) ► Jan 06 (60) ► Jan 07 (60) ► Jan 08 (60) ► Jan 09 (60) ► Jan 10 (60) ► Jan 11 (60) ► Jan 12 (60) ► Jan 13 (60) ► Jan 14 (60) ► Jan 15 (60) ► Jan 16 (60) ► Jan 17 (60) ► Jan 18 (60) ► Jan 19 (60) ► Jan 20 (60) ► Jan 21 (60) ► Jan 22 (60) ► Jan 23 (60) ► Jan 24 (60) ► Jan 25 (60) ► Jan 26 (60) ► Jan 27 (60) ► Jan 28 (60) ► Jan 29 (60) ► Jan 30 (60) ► Jan 31 (60) ► February (1740) ► Feb 01 (60) ► Feb 02 (60) ► Feb 03 (60) ► Feb 04 (60) ► Feb 05 (60) ► Feb 06 (60) ► Feb 07 (60) ► Feb 08 (60) ► Feb 09 (60) ► Feb 10 (60) ► Feb 11 (60) ► Feb 12 (60) ► Feb 13 (60) ► Feb 14 (60) ► Feb 15 (60) ► Feb 16 (60) ► Feb 17 (60) ► Feb 18 (60) ► Feb 19 (60) ► Feb 20 (60) ► Feb 21 (60) ► Feb 22 (60) ► Feb 23 (60) ► Feb 24 (60) ► Feb 25 (60) ► Feb 26 (60) ► Feb 27 (60) ► Feb 28 (60) ► Feb 29 (60) ► March (1860) ► Mar 01 (60) ► Mar 02 (60) ► Mar 03 (60) ► Mar 04 (60) ► Mar 05 (60) ► Mar 06 (60) ► Mar 07 (60) ► Mar 08 (60) ► Mar 09 (60) ► Mar 10 (60) ► Mar 11 (60) ► Mar 12 (60) ► Mar 13 (60) ► Mar 14 (60) ► Mar 15 (60) ► Mar 16 (60) ► Mar 17 (60) ► Mar 18 (60) ► Mar 19 (60) ► Mar 20 (60) ► Mar 21 (60) ► Mar 22 (60) ► Mar 23 (60) ► Mar 24 (60) ► Mar 25 (60) ► Mar 26 (60) &