-- 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.
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.
Thank you for the post, it helped me, when I needed.
ReplyDeleteThankx worked for me...
ReplyDeleteThanks it's work fine
ReplyDelete