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 2008
kkjcre1p: unable to spawn jobq slave process
Process J000 died, see its trace file
Sat Apr 19 19:06:39 2008
kkjcre1p: unable to spawn jobq slave process
Process J000 died, see its trace file
Sat Apr 19 19:06:39 2008
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.
