您好,欢迎访问一九零五行业门户网

expdp时遇到ORA-39097ORA-39065ORA-39079ORA-06512ORA-24033

expdp时遇到ora-39097ora-39065ora-39079ora-06512ora-24033
expdp时遇到ora-39097&ora-39065&ora-39079&ora-06512&ora-24033
expdp时各种报错,,我也是醉了,版本为11.2.0.1,expdp命令为:
nohup expdp hq_x1/hq_x1 dumpfile=hq_x1%u.dmp directory=dir1 parallel=8  flashback_scn=10838324803 &
ora-39097: data pump job encountered unexpected error -39079
ora-39065: unexpected master process exception in dispatch
ora-39079: unable to enqueue message rp,kupc$c_1_20150623215653,mcp,kupc$a_1_20150623224430,1,y
ora-06512: at sys.dbms_sys_error, line 86
ora-06512: at sys.kupc$que_int, line 965
ora-24033: no recipients for message
ora-39065: unexpected master process exception in send
ora-39079: unable to enqueue message rp,kupc$c_1_20150623215653,mcp,kupc$a_1_20150623224430,1,y
ora-06512: at sys.dbms_sys_error, line 86
ora-06512: at sys.kupc$que_int, line 965
ora-24033: no recipients for message
报这个错往往跟aq_tm_processes=0有关,查看了aq_tm_processes参数,发现果然设置为0,
于是将其set为aq_tm_processes>1的值,问题解决。
oracle导入导出expdp impdp详解
oracle 10g expdp导出报错ora-4031的解决方法
oracle 10gr2 rac expdp 报错ude-00008 ora-31626
oracle中利用expdp/impdp备份数据库的使用说明
oracle备份还原(expdp/impdp)
impdp ora-39002,ora-39166,ora-39164的问题及解决
本文永久更新链接地址:
其它类似信息

推荐信息