Oracle ora-00600 librarycachenotemptyonclose, the famed in Oracle 10g

This error is caused by a bug recognized by Oracle that can be easily found in Metalink [ID 4483084.8], the error indicates that you have tried to stop the database without the Library Cache was empty.

The proposed solution is officially migrate to and further indicates that it does not produce any kind of corruption in the datafiles, suggesting that we can get used to seeing on the alert without worrying.

What they do not say is that this error may generate a typical shutdown immediate, may fail and be the BD in nomount state, this has happened to me in HP-UX systems. If it happens during a cold weekend back, the database will not start because it is, but of course in nomunt state.

Continue reading