Process J000 died, see its trace file,kkjcre1p: unable to spawn jobq slave process

今天一早檢查alert.log,發現以下錯誤:

Process J000 died, see its trace file
Mon Sep 7 16:26:07 2009
kkjcre1p: unable to spawn jobq slave process
Mon Sep 7 16:26:07 2009
Errors in file /d01/proddb/10.2.0/admin/PROD_melcoproddb/bdump/prod_cjq0_27156.trc:

Process J000 died, see its trace file
Mon Sep 7 16:26:13 2009
kkjcre1p: unable to spawn jobq slave process
Mon Sep 7 16:26:13 2009
Errors in file /d01/proddb/10.2.0/admin/PROD_melcoproddb/bdump/prod_cjq0_27156.trc:

Mon Sep 7 16:26:44 2009
Process J000 died, see its trace file
Mon Sep 7 16:26:44 2009
kkjcre1p: unable to spawn jobq slave process
Mon Sep 7 16:26:44 2009
Errors in file /d01/proddb/10.2.0/admin/PROD_melcoproddb/bdump/prod_cjq0_27156.trc:

查資料，原因及處理方法如下:

Cause
JOB_QUEUE_PROCESSES parameter was set to 10 which is a small value.

JOB_QUEUE_PROCESSES specifies the maximum number of processes that can be created for the
execution of jobs. It specifies the number of job queue processes per instance (J000, ... J999).

That is why a lot of jobs died as in the alert log file when the parameter is set to such a small
value.

.
Solution
Make sure you are using SPFILE and then issue the following :

SQL>alter system set JOB_QUEUE_PROCESSES=500 scope=both;

Make sure that the value of the parameter has changed and then check if the error is still
generated in the alert log.

[@more@]