You've got to have a dream. When you lose your dreams, you die.
Oracle Server - Enterprise Edition - Version 10.1.0.4 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.