"Process J001 died" And/Or "Process W000 died" And/Or "kkjcre1p: unable to spawn jobq slave process"

пятница, 11 октября 2013 г. Оставить комментарий

I got an error:


Process J001 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Process W000 died, see its trace file

Cause: A resource problem


Action:

1. Increase the parameter JOB_QUEUE_PROCESSES. Using Both DBMS_JOB and Oracle Scheduler

alter system set job_queue_processes=10;

2. Make sure Swap is correctly configured and increase it if necessary.

    4 ~ 8 GBs of RAM, set Swap to at least double RAM size.

    8~16 GBs of RAM, set Swap to double RAM.

    16~32 GBs of RAM or more, set Swap at a rate of 0.75xRAM.

3. Make sure all the Kernel parameters are configured correctly.

4. Check In-Memory File System size. ORA-00845 MEMORY_TARGET not supported on this system

4. Check the ulimits.


0 коммент. »

Оставьте Ваш комментарий