Tuesday, July 30, 2019

kkjcre1p: unable to spawn jobq slave process, slot 2, error 1089


If you have initiated SHUTDOWN command to stop the database, new sessions cannot connect with the database. This means that even oracle scheduled jobs also cannot be initiated internally. After initiation of SHUTDOWN, if any scheduled jobs get initiated (because scheduled time of any job has reached), job would not be started and an error message will be logged in the alert log file. Following is how alert log would look like after that. Since this is just an information message, therefore  no action is needed.

Thu Jun 29 04:37:36 2017
kkjcre1p: unable to spawn jobq slave process, slot 2, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 2, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 2, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 2, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 2, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 2, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 2, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 2, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 2, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 2, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 2, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 2, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 2, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 2, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 2, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 2, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 2, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 2, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 2, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 2, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 2, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 2, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 2, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 2, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 2, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 2, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 2, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 2, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 2, error 1089
kkjcre1p: unable to spawn jobq slave process, slot 2, error 1089

No comments:

Post a Comment

Popular Posts - All Times