Oracle故障处理之错误代码：kkjcre1p: unable to spawn jobq slave process

数据与人 2020-12-15

5782

问题背景：

客户反映数据库有时候出现连接等待

1> 查看alert日志

以下为日志一部分报错内容

kkjcre1p: unable to spawn jobq slave process, slot 3, error 1089
Sun Oct 27 11:21:35 2019
kkjcre1p: unable to spawn jobq slave process, slot 3, error 1089
Sun Oct 27 11:21:35 2019
kkjcre1p: unable to spawn jobq slave process, slot 3, error 1089
Sun Oct 27 11:21:35 2019
kkjcre1p: unable to spawn jobq slave process, slot 3, error 1089
Sun Oct 27 11:21:35 2019
kkjcre1p: unable to spawn jobq slave process, slot 3, error 1089


ORA-00444: background process "EMN0" failed while starting
ORA-00020: maximum number of processes () exceeded
Sun Oct 27 11:21:35 2019
Process J000 died, see its trace file
Sun Oct 27 11:21:35 2019
kkjcre1p: unable to spawn jobq slave process
Sun Oct 27 11:21:35 2019

根据提示信息可以了解到系统无法生成job相关的进程，同时达到processes最大限制而出错的。

2> 查看系统processes和sessions

SQL> show parameter processes


NAME TYPE VALUE
------------------------------------ -----------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
job_queue_processes integer 10
log_archive_max_processes integer 2
processes integer 150


SQL> show parameter sessions


NAME TYPE VALUE
----------------------------------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
logmnr_max_persistent_sessions integer 1
sessions integer 170
shared_server_sessions integer


查看当前系统的processes


SQL> select count(*) from v$process;
COUNT(*)
----------