ORA-00020: No more process state objects available

十字螺丝钉

1. Wed Jul xx xx:xx:45 20xx
3. Process J000 submission failed with error = 20
5. kkjcre1p: unable to spawn jobq slave process
7. Errors in file /xx/trace/down_cjq0_2346.trc:
11. Process J000 submission failed with error = 20
13. kkjcre1p: unable to spawn jobq slave process
15. Errors in file /xx/trace/down_cjq0_2346.trc:

查看trace详细日志记录

 

1. *** xx-xx-xx xx:xx:xx.104
3. Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
5. ORA-00020: No more process state objects available
9. *** xx-xx-xx xx:xx:xx.683
11. ORA-00020: No more process state objects available
15. *** xx-xx-xx xx:xx:xx.687
17. ORA-00020: No more process state objects available
21. *** xx-xx-xx xx:xx:04.691
23. ORA-00020: No more process state objects available
27. *** xx-xx-xx xx:xx:xx.692
29. ORA-00020: No more process state objects available
31. Setting Resource Manager plan SCHEDULER[0x2C0A]:DEFAULT_MAINTENANCE_PLAN via scheduler window
35. *** xx-xx-xx xx:xx:xx.092
37. Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
39. ORA-00020: No more process state objects available

经过查资料分析，oracle 11g R1默认的process是150个，如果想要建立更多的进程，那么就会报ORA-00020: No more process state objects available.

解决办法:增加process的值，我给改为了300

SQL> alter system set processes=300 scope=spfile;

尔后择机重启orale数据库

经过后来的观察，发现不再报错误，算是处理成功了！