Get orA-39078 when expdp full database

Get following error when full backup a database using expdp.

SET oracle_sid=test
expdp '/ as sysdba' full=y directory=dmpdir dumpfile=test_fullexpdp_091030.dmp LOGFILE=test_fullexpdp_091030.log

orA-39065: unexpected master process exception in RECEIVE
orA-39078: unable to dequeue message for agent MCP from queue “KUPC$C_1_20091029233621”
orA-06512: at “SYS.DBMS_SYS_ERROR”, line 95
orA-06512: at “SYS.KUPC$QUE_INT”, line 565
orA-25253: listen failed, queue SYS.KUPC$C_1_20091029233621 is not enabled for dequeue
Job “DOW\FGLORJB”.”SYS_EXPORT_FULL_01″ stopped due to fatal error at 00:21:33

After checking in metalink, Here is the solution – increase the STREAMS_POOL_SIZE

SQL> Alter system set STREAMS_POOL_SIZE=48M;

then rerun the expdp, it really works on my database !


0 条评论。


注意 - 你可以用以下 HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>