Fix : Unable to spawn jobq slave process, slot 0, error 1089 Posted by MOHAMMED ABDUL HAMEED on 4:38 AM

While shutting down our test database we observe the below mention message in the alert log continuously : 

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

Probably its because of below mention reasons :

1) If we have fired "shut immediate" and presses "^C" to cancel the command.

OR

2) Some memory issue and you unable to down / start the database again.

Workaround :

Analysis the condition if its not due to memory then startup force.

$ sqlplus / as sysdba

SQL> startup force;

This will cause your database will be force fully down and start it again.

Note: Shut abort will not work in this situation.