May 18, 2015

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

-- Found from alert log. Message continusly writing to alert log

Mon May 18 14:15:58 2015
kkjcre1p: unable to spawn jobq slave process, slot 0, error 1089


RCA:

1) If you have fired "shut immediate" and presses "^C" to cancel the command.
OR
2) If you have some memory issue and you unable to down / start the database again.


Solution:

1) start it force fully if you don't have memory issues.

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


3 comments:

Translate >>