kkjcre1p: unable to spawn jobq slave process
Hi All,
I'm getting the below error in my alert log file:
Process J000 submission failed with error = 20
kkjcre1p: unable to spawn jobq slave process
Errors in file /u01/app/oracle/diag/rdbms/dipsipsora01/dipsipsora01/trace/dipsipsora01_cjq0_20349.trc:
And, sqlplus connections are failing with the below error:
[dipsipsora01@JBLDCVSPORA01 trace]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon Feb 2 09:33:00 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-00020: maximum number of processes (200) exceeded
Below are some of the additional details:
[dipsipsora01@JBLDCVSPORA01 trace]$ free -m
total used free shared buffers cached
Mem: 15954 15859 94 0 18 5135
-/+ buffers/cache: 10706 5248
Swap: 16383 1699 14684
[dipsipsora01@JBLDCVSPORA01 trace]$ ps -ef|grep -i LOCAL=NO|wc -l