Probelm Description:
I found this error in database alert log file
Process J000 died, see its trace file
Wed Oct 27 12:56:39 2010
kkjcre1p: unable to spawn jobq slave process
Process J000 died, see its trace file
Wed Oct 27 12:56:39 2010
kkjcre1p: unable to spawn jobq slave process
Process J000 died, see its trace file
Wed Oct 27 12:56:39 2010
kkjcre1p: unable to spawn jobq slave process
the database hangs and no further connection are allowed to the database.
Cause:
The failure to spawn error almost always indicates a hardware resource shortage, often RAM or a lack of process memory.
Solution:
1 - This can be from the "processes" parameter being set too low,increase the valuse for this parameter and restart the database to take effect.
2 - check that job_queue_processes parameter it is not set to 0.
3 - Check your server stats, you may have run out of available server RAM resources.
4 comments:
me also have same message in alertlog on that time my database not connected to application server what i do pls explain step by step.
check the value of processes parameter in your database I think you need to increase it
thank you :)
i too have got this able to connect but there is no issue.
Post a Comment