ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 11R2使用expdp时遭遇ora-31650

11R2使用expdp时遭遇ora-31650

原创 Linux操作系统 作者:myownstars 时间:2013-02-07 12:58:30 0 删除 编辑

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博客 ” ,链接:https://blog.itpub.net/15480802/viewspace-753996/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-03-18

  • 博文量
    375
  • 访问量
    3320732