expdp时遇到ORA-39097&ORA-39065&ORA-39079&ORA-06512&ORA-24033
来源:互联网 发布:程序员需要会什么 编辑:程序博客网 时间:2024/04/29 20:31
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的值,问题解决。
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的值,问题解决。
1 0
- expdp时遇到ORA-39097&ORA-39065&ORA-39079&ORA-06512&ORA-24033
- ORA-39006,ORA-39213,ORA-06512,ORA-01114,ORA-39065,ORA-39097,ORA-01403 EXPDP报错问题处理
- expdp时遇到ORA-31693&ORA-00922
- expdp时遇到ORA-31693&ORA-02354&ORA-01466
- expdp 导出报错 ORA-39006: ORA-39065: ORA-04063: ORA-06508: ORA-39097: ORA-01403: ORA-39097:
- oracle 10.2.0.5 expdp ORA-39097、ORA-39065、ORA-06502
- ORA
- ora
- 使用expdp时遇到ORA-39002、ORA-39070错误
- expdp遭遇ORA-39006、ORA-39065、ORA-01403、ORA-39097错误
- Orace expdp ORA ORA-39167
- expdp ora-31640 ora-19505
- ORA-39097 ORA-39065 ORA-01427
- ORA-00936 ORA-06512
- ora-29280,ora-06512
- ORA-39002 ORA-39070 ORA-29283 ORA-06512 ORA-29283
- EXPDP遇到的ORA-39005和ORA-39095错误
- ORACLE11G RAC expdp报错ORA-39002 ORA-39070 ORA-29283 ORA-06512
- poj 3537Crosses and Crosses 博弈论之grundy值
- ios 使用UIImagePickerController 打开图片库和相机选择图片修改头像
- Android基础之简单mune菜单详解
- expdp时遇到ORA-31693&ORA-00922
- raspberry 树莓派 360/百度(RT2870 MT7601) WIFI驱动
- expdp时遇到ORA-39097&ORA-39065&ORA-39079&ORA-06512&ORA-24033
- nodeJS的express框架的搭建
- 3D游戏编程入门(十五)索引缓存
- impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037
- 3D游戏编程入门(十六)索引缓存绘制立方体
- 学习笔记-基础知识15-常用类
- 学习笔记-基础知识6-异常
- iOS的Mantle实战
- Android 自定义 HorizontalScrollView 图片控件