Oracle message kkjcre1p: unable to spawn jobq slave process, slot 0, error 1089
- Article Type: General
- Product: Aleph
- Product Version: 20
Problem Symptoms:
- Following error messages in Oracle alert log:
Shutting down instance: further logons disabled
Thu Jul 12 02:34:20 2012
kkjcre1p: unable to spawn jobq slave process, slot 0, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 0, error 1089
Cause:
Message is just a warning that the DB is being shut down (during RMAN cold backup when the DB goes 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.
Resolution:
Solution
1. Error can be safely ignored as the job coordinator process tried to spawn a job slave when the shutdown was in progress.
Additional Information
You may want 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.
- Article last edited: 10/8/2013