11R2使用expdp时遭遇ora-31650

D:\oracle\diag\rdbms \trace>expdp \"/ as sysdba\"  schemas=JUSTIN dumpfile=JUSTIN_120803.dmp directory=datapumpdir

 

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORA-31626: job does not exist

ORA-31650: timeout waiting for master process response

 

MOS常见的原因是

1      RAC不同节点试图同时使用expdp

2      sga不足，调整sga_target至少为1G

      3    aq_tm_processes=0

 

但该数据库是单实例，且sga_target/sga_max_size=8g应该足够了，应该是第3种原因，果然aq_tm_processes设置为0，刚开始该为2，仍然抱错，接着改成10才成功。

 

AQ_TM_PROCESSES controls time monitoring on queue messages and controls processing of messages with delay and expiration properties specified.You do not need to specify a value for this parameter because Oracle Database automatically determines the number of processes and autotunes them, as necessary. Therefore, Oracle highly recommends that you leave the AQ_TM_PROCESSES parameter unspecified and let the system autotune.

The default value for AQ_TM_PROCESSES is used if the client does not explicitly set a value for the parameter in the init.ora file or using the ALTER SYSTEM command.

Note:

If you want to disable the Queue Monitor Coordinator, then you must set AQ_TM_PROCESSES to 0 in your parameter file. Oracle strongly recommends that you do NOT set AQ_TM_PROCESSES to 0. If you are using Oracle Streams, then setting this parameter to zero (which Oracle Database respects no matter what) can cause serious problems.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15480802/viewspace-753996/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15480802/viewspace-753996/