ORA-00020: No more process state objects available

Wed Jul xx xx:xx:45 20xx

Process J000 submission failed with error = 20

kkjcre1p: unable to spawn jobq slave process

Errors in file /xx/trace/down_cjq0_2346.trc:



Process J000 submission failed with error = 20

kkjcre1p: unable to spawn jobq slave process

Errors in file /xx/trace/down_cjq0_2346.trc:

查看trace详细日志记录

 

*** xx-xx-xx xx:xx:xx.104

Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter

ORA-00020: No more process state objects available



*** xx-xx-xx xx:xx:xx.683

ORA-00020: No more process state objects available



*** xx-xx-xx xx:xx:xx.687

ORA-00020: No more process state objects available



*** xx-xx-xx xx:xx:04.691

ORA-00020: No more process state objects available



*** xx-xx-xx xx:xx:xx.692

ORA-00020: No more process state objects available

Setting Resource Manager plan SCHEDULER[0x2C0A]:DEFAULT_MAINTENANCE_PLAN via scheduler window



*** xx-xx-xx xx:xx:xx.092

Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter

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数据库

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