DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, April 18, 2016

Kkjcre1p: Unable To Spawn Jobq Slave Process, Error 1089

                     
                               Kkjcre1p: Unable To Spawn Jobq Slave Process, Error 1089



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:

ORA01089 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.

Ref:Doc ID 344275.1

No comments: