(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部落格 ” ,連結:http://blog.itpub.net/29135257/viewspace-1876643/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- RAC轉換至RAC One Node
- 11.2.0.2管理Oracle RAC One Node DatabaseOracleDatabase
- Canvas errors & CORS All In OneCanvasErrorCORS
- React 18 errors All In OneReactError
- nvm command errors All In OneError
- EXPDP Fails With ORA-04031 ("streams pool", ...)AI
- Oracle 11g RAC One node 安裝與配置Oracle
- Django admin static files errors All In OneDjangoError
- Change the Archiving Mode in a RAC Environment
- rac one node、Single Instance HA(SIHA)、Oracle Restart的概念OracleREST
- RAC One Node資料庫的轉換與線上遷移資料庫
- What is a deadlock and how does one fix deadlock errors?Error
- Reinstall ASM or DB HOME on One RAC Node From the Install Media_864614.1ASM
- DataPump Export (EXPDP) Fails With Error LPX-216 Invalid CharacterExportAIError
- Top 5 Database and/or Instance Performance Issues in RAC EnvironmentDatabaseORM
- Agent Install Fails with Error 'OUI-25031' Due to Environment Settings_380507.1AIErrorUI
- 【MOS】EXPDP Fails ORA-39165: Schema SYS Was Not Found (文件 ID 553402.1)AI
- ASM Di Show PROVISIONED On One RAC,UNKNOWN Other Node,Cannot Add To DG_1468642.1ASM
- DataPump Import Of Object Types Fails With Errors ORA-39083 ORA-2304(筆錄)ImportObjectAIError
- ORA-1652: unable to extend temp segment errors In RACError
- Database and/or Instance Performance Issues in RAC Environment_1373500.1DatabaseORM
- 2015.05.15 網路公開課 《Oracle 11G RAC深入探索之RAC和RAC One Node之間的切換》Oracle
- Oracle RAC Cache Fusion 系列十四:Oracle RAC CR Server Part OneOracleServer
- Oracle 12c 2 Nodes sandbox RAC environment on your laptop!OracleAPT
- 'enq: TX - index contention' Waits in a RAC Environment. [ID 873243.1]ENQIndexAI
- root.sh Fails on the First Node for 11gR2 GI InstallationAI
- Top 11 Things to do NOW to Stabilize your RAC Cluster Environment_1344678.1
- expdp 報錯 ORA-04063: package body "SYS.DBMS_METADATA_UTIL" has errorsPackageError
- MySQL Binlogging Fails With Writing One Row To The Row-based Binary Log FailedMySqlAI
- Database Startup Fails with ORA-01113, ORA-01110 errors (Doc ID 146039.1)DatabaseAIError
- Using Oracle Database 11g Release 2 Result Cache in an Oracle RAC EnvironmentOracleDatabase
- 單例項資料庫expdp遷移到RAC庫單例資料庫
- Oracle 11G RAC One Node's Instance Arise ORA-01105 ORA-01606Oracle
- How to find Master Node in Oracle RAC(zt)ASTOracle
- Rac One Node在計劃內切換和非計劃內CRASH時例項名的變化區別
- Oracle 11g rac add nodeOracle
- Problem: 10.2 Agent Install On Rac Fails With 'Exceptionmessage=Prkc-1002'AIException
- Oracle environment variableOracle