ORA-00450, ORA-00443, background process "CJQ0" did not start On : 11.g

ORA-00450, ORA-00443, background process "CJQ0" did not start On : 11.2.0.3 version, RDBMS

When attempting to shutdown the database the following error occurs.

ORA-450: background process 'CJQ0' did not start
ORA-443: background process "CJQ0" did not start


The issue can be reproduced at will by shutdown the instance.

Cause


This problem is as described in
unpublished Bug 6865966 PMON TRYING TO START CJQ0 DURING DATABASE SHUTDOWN-ORA-443 & ORA-450
where development explained that the errors are misleading but are unharmful.


Solution

This is caused by scheduler autostart feature trying to start up the  coordinator at the same time as database is shutting down. So you can safely ignore the errors.

The unpublished Bug 6865966 is still under investigation and you can apply the patch, once the fix is made available.

The Autostart feature will not be available in 12c and hence this issue wont be present in 12c version.


References

@ BUG:6865966 - PMON TRYING TO START CJQ0 DURING DATABASE SHUTDOWN-ORA-443 & ORA-450