Fixing the "kkjcre1p: unable to spawn jobq slave process" error Oracle Database Tips by Donald BurlesonMay 11, 2015

 
Question: I'm getting this error in my alert log "kkjcre1p: unable to spawn jobq slave process".  How do I fix this kkjcre1p error?

Process J000 died, see its trace file
Sat Apr 19 19:06:39 2015
kkjcre1p: unable to spawn jobq slave process
Process J000 died, see its trace file
Sat Apr 19 19:06:39 2015
kkjcre1p: unable to spawn jobq slave process
Process J000 died, see its trace file
Sat Apr 19 19:06:39 2015
kkjcre1p: unable to spawn jobq slave process

When I get this kkjcre1p error, my database hangs and no further connection are allowed to the database.

Answer:  A "failure to spawn" almost always indicates a resource shortage, often RAM or a lack of process memory. 

1 - This can be from the "processes" parameter being set too low. What is your current value? You have to bounce the database to change this static initialization parameter.

2 - check your job_queue_processes parameter and make sure it is not = 0.

3 - Check your server stats, you may have run out of available server RAM resources.

Also, make sure to look at the trace files and log an SR with MOSC.  There are also known bugs on this error, check MOSC for patches.