oracle 11gR2 ORA-31626: job does not exist 和ORA-31687: error creating worker process with worker id 1 解决方法

 

 

Oracle 11gR2 imdp 报错如下：

 

 

Import: Release 11.2.0.1.0 - Production on Mon May 3 16:25:17 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-31687: error creating worker process with worker id 1
ORA-31687: error creating worker process with worker id 1
ORA-31688: Worker process failed during startup.

 

 

 

这个错误与参数AQ_TM_PROCESSES有关。 当该参数这是为0的时候，就会报这个错误。

 

所以解决这个问题的方法就是在pfile里移除这个参数的设置。然后重启DB就可以了。

 

 

11gR2 在线文档对该参数的说明如下：

AQ_TM_PROCESSES

Property

Description

Parameter type

Integer

Default value

None

Modifiable

ALTER SYSTEM

Range of values

0 to 40

Basic

No

 

       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.

 

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.

 

 

在Oracle 10g中，该参数默认值是0.

AQ_TM_PROCESSES

Property

Description

Parameter type

Integer

Default value

0

Modifiable

ALTER SYSTEM

Range of values

0 to 10

Basic

No

 

       AQ_TM_PROCESSES enables time monitoring of queue messages. The times can be used in messages that specify delay and expiration properties. Values from 1 to 10 specify the number of queue monitor processes created to monitor the messages. If AQ_TM_PROCESSES is not specified or is set to 0, then the queue monitor is not created.

 

 

 

---------------------------------------------------------------------------------------------------

Blog： http://blog.csdn.net/tianlesoftware

网上资源： http://tianlesoftware.download.csdn.net

相关视频：http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx

DBA1 群：62697716(满); DBA2 群：62697977(满) DBA3 群：62697850(满)  

DBA 超级群：63306533(满); DBA4 群： 83829929 DBA5群： 142216823

聊天 群：40132017

--加群需要在备注说明Oracle表空间和数据文件的关系，否则拒绝申请