(EXPDP) Fails With Errors ORA-39079 ORA-25306 On One Node In RAC Environment
DataPump export on one certain RAC instance fails with errors:
ORA-39006: internal error
ORA-39065: unexpected master process exception in DISPATCH
ORA-39079: unable to enqueue message DG,KUPC$S_2_20090927001645,MCP, ,1,Y
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPC$QUE_INT", line 924
ORA-25306: Cannot connect to buffered queue's owner instance
ORA-39097: Data Pump job encountered unexpected error -39079
ORA-39065: unexpected master process exception in KUPC$QUEUE_INT.PUT_STATUS
ORA-39079: unable to enqueue message DG,KUPC$S_2_20090927001645,MCP, ,1,Y
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPC$QUE_INT", line 924
ORA-25306: Cannot connect to buffered queue's owner instance
The AQ_TM_PROCESSES instance parameter has been set to 0
Advanced Queueing is required by Datapump. As such the AQ_TM_PROCESSES parameter must have a value > 0 for EXPDP to succeed.
ORA-39006: internal error
ORA-39065: unexpected master process exception in DISPATCH
ORA-39079: unable to enqueue message DG,KUPC$S_2_20090927001645,MCP, ,1,Y
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPC$QUE_INT", line 924
ORA-25306: Cannot connect to buffered queue's owner instance
ORA-39097: Data Pump job encountered unexpected error -39079
ORA-39065: unexpected master process exception in KUPC$QUEUE_INT.PUT_STATUS
ORA-39079: unable to enqueue message DG,KUPC$S_2_20090927001645,MCP, ,1,Y
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPC$QUE_INT", line 924
ORA-25306: Cannot connect to buffered queue's owner instance
The AQ_TM_PROCESSES instance parameter has been set to 0
Advanced Queueing is required by Datapump. As such the AQ_TM_PROCESSES parameter must have a value > 0 for EXPDP to succeed.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29135257/viewspace-1876643/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
查看表空间中存放的表名
下一篇：
Oracle手工修改JOB属性
请登录后发表评论
登录
全部评论
