Kkjcre1p:

Kkjcre1p: Unable To Spawn Jobq Slave Process, Error 1089 [ID 344275.1]

---

Applies to:

Oracle Server - Enterprise Edition - Version 10.1.0.4 and later
Information in this document applies to any platform.

Symptoms

During RMAN cold backup when the database goes down we may see the error in alert log
     
        
  kkjcre1p: unable to spawn jobq slave process, error 1089
 
  Alert log shows
  -----------------
  Thu Dec  1 02:16:17 2005
  Shutting down instance: further logons disabled
  Thu Dec  1 02:16:18 2005
     
  kkjcre1p: unable to spawn jobq slave process, error 1089
  Thu Dec  1 02:16:21 2005
  Stopping background process CJQ0
  :::::::::::::
  Thu Dec  1 02:16:24 2005
  Job queue slave processes stopped

Cause

ORA-01089 is just a warning that the DB is being shut down.
If a job is about to be spawned when shutdown of database is in progress, you will see these errors in the alert log file and this is perfectly valid.
   

Solution

There is no harm at all because of  this warning being logged to the alert.log  The Error can be safely ignored as the job coordinator process tried to spawn a job slave when the Shutdown was in progress.

One workaround that we can suggest is to set an underscore parameter
_JOB_QUEUE_INTERVAL=120 or greater value
The default value is 60 but when we change to 120 there are less chances of getting the above warnings in the alert log file.