Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

EXPDP failing with ORA-39125 and ORA-04031 on 10g

Veera90Dec 2 2017 — edited Dec 22 2017

I am trying to export a couple of 10.2.0.4 databases using EXPDP utility by executing the below command ...,

expdp full=Y directory=BACK_DIR dumpfile=Full_%U.dmp logfile=Full.log parallel=2

But they fail with the below errors...

ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB [PROCACT_SCHEMA:"LANSWP"]

ORA-04031: unable to allocate 1207992352 bytes of shared memory ("shared pool","XDbD/PLZ01TcHgNAgAIIegtw==","qmxlu subheap","qmemNextBuf:Large Alloc")

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105

ORA-06512: at "SYS.KUPW$WORKER", line 6313

----- PL/SQL Call Stack -----

object line object

handle number name

70000003f664338 15032 package body SYS.KUPW$WORKER

70000003f664338 6372 package body SYS.KUPW$WORKER

70000003f664338 2396 package body SYS.KUPW$WORKER

70000003f664338 6944 package body SYS.KUPW$WORKER

70000003f664338 1314 package body SYS.KUPW$WORKER

70000003f08e910 2 anonymous block

Job "SYS"."FULLBKP_EXPDP" stopped due to fatal error at 16:04:37

Any help or advise is much appreciated.

Thanks a lot for your time.

---Veera

This post has been answered by Veera90 on Dec 22 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 19 2018

Added on Dec 2 2017

#database-key-features, #export-import-sql-loader-external-tables

4 comments

811 views