Skip to main content
ExLibris

  • Subscribe by RSS
    • Aleph
    Ex Libris Knowledge Center

    Oracle message kkjcre1p: unable to spawn jobq slave process, slot 0, error 1089

    1. Last updated
    2. Save as PDF
    • 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