月度存档: 十月 2009

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 !

VIP小巢装修日记 http://www.vingo.cn

VIP小巢装修日记
http://www.vingo.cn

特此声明,为转贴,不是偷窃