ORA-31626 ORA-31650 While Using DataPump Export in RAC Environment [ID 454639.1]

tolywang發表於2010-02-02
WhileExport
ORA-31626 ORA-31650 While Using DataPump Export in RAC Environment [ID 454639.1]  
  修改時間 28-AUG-2007     型別 PROBLEM     狀態 MODERATED  

In this Document
  
  
  

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.0 to 10.2.0.3
This problem can occur on any platform.

Symptoms

ORA-31626: job does not exist
ORA-31650: timeout waiting for master process response

Alert log will show the following messages:

Tue Aug 14 01:32:43 2007
ALTER SYSTEM SET service_names='SYS$SYS.KUPC$C_3_20070814013231.TPBP.WORLD'
SCOPE=MEMORY SID='TPBP3';
Tue Aug 14 01:32:43 2007
ALTER SYSTEM SET service_names='SYS$SYS.KUPC$C_3_20070814013231.TPBP.WORLD',
'SYS$SYS.KUPC$S_3_20070814013231.TPBP.WORLD' SCOPE
=MEMORY SID='TPBP3';
kupprdp: master process DM00 started with pid=462, OS id=11174
to execute - SYS.KUPM$MCP.MAIN('CMENTDBOEXPORT', 'SYS', 'KUPC$
C_3_20070814013231', 'KUPC$S_3_20070814013231', 0);
kwqicowin: Could not determine instance_sid: Queue: SYS.KUPC$C_3_20070814013231
Instance 1 ksim_stat -1 retry_count 0
Tue Aug 14 01:32:47 2007
ALTER SYSTEM SET service_names='SYS$SYS.KUPC$S_3_20070814013231.TPBP.WORLD'
SCOPE=MEMORY SID='TPBP3';
Tue Aug 14 01:32:49 2007


Cause

There is one datapump limitation in 10gR2 :
summarized as:
It is not possible to start or restart Data Pump jobs on one instance of a RAC if there are Data Pump jobs currently running on other instances of the RAC. It is possible to start jobs on the instance where the other jobs are running or on any instance of the RAC if no jobs are currently running.

SQL > select count(*) from gv$datapump_job where inst_id != sys_context('userenv','instance');

With count > 0 indicates that there are jobs running in other instances that may cause a problem if you try to start or restart a job on the "current" instance. However, there is a window between this test and attempting to create the job infrastructure which could result in unexpected behavior. It is best to be prepared for the error in a RAC environment in any case.

If we are sure that there is no expdp job running on the other nodes then we need to check the value of "aq_tm_processes" on the instance where the datapump job is failing.

We will find this value set as 0.

It is due to BUG <5490029> 'EXPDP FAILS ON NODE2 WITH ORA-39065 AND ORA-39078 IN 2NODES RAC'



Solution

  To solve the problem set the aq_tm_processes to at least 1 as:


SQL> alter system set aq_tm_processes=1 scope=both;

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/35489/viewspace-626636/，如需轉載，請註明出處，否則將追究法律責任。

相關文章