标题: 数据库出现Process XXXX died, see its trace file报错 [打印本页] 作者: 刘泽宇 时间: 2021-10-31 13:50 标题: 数据库出现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;