Applies to:

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


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


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.


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.

Niciun comentariu:

Trimiteți un comentariu