Database Administration (MOSC)

MOSC Banner

kkjcre1p: unable to spawn jobq slave process

edited Mar 4, 2015 1:42AM in Database Administration (MOSC) 18 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center