Home > Database > Mysql Tutorial > body text

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

WBOY
Release: 2016-06-07 15:53:27
Original
3044 people have browsed it

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的问题及解决 

本文永久更新链接地址

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template