数据库出现Process XXXX died, see its trace file报错

刘泽宇

查看数据库告警日志，发现出现了这样的报错：

Process J000 died, see its trace file
Fri Oct 29 10:12:26  2021
kkjcre1p: unable to spawn jobq slave process
Fri Oct 29 10:12:34  2021
Errors in file D:\oracle\admin\orcl\bdump\orcl_cjq0_4600.trc:

查阅资料：
JOB_QUEUE_PROCESSES  determine the maximum number of concurrently running jobs. In Oracle HTML DB release 2.0, transactional support and SQL scripts require jobs. If  JOB_QUEUE_PROCESSES  is not enabled and working properly, you cannot successfully execute a script.

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).

SQL> show parameter job;

NAME                                 TYPE        VALUE
------------------------------------ ----------- --------
job_queue_processes                  integer     10

默认的值太小，才10，把 JOB_QUEUE_PROCESSES增大到200.

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