ORA-00600: [kmgss_activate_granule_1] Database Instance Crash

Today one of our database crashed due to ORA-00600: internal error code, arguments: [kmgss_activate_granule_1].

I have checked the logs and identified that the database was crashed due to dynamic change of the parameter DB_KEEP_CACHE_SIZE.

After execution of the statement

ALTER SYSTEM SET db_keep_cache_size='100M' SCOPE=BOTH;

Internal Errors started appearing on the alert log ORA-00600: internal error code, arguments: [kmgss_activate_granule_1], [], [], [], [], [], [], []

and followed by

MMAN: terminating instance due to error 822

ORA-00822: MMAN process terminated with error.

The above crash can also happen in the database due to bug on Oracle Server Enterprise Edition Version: 10.2.0.1 to 10.2.0.4.

The problem can occur due to dynamic changes of the parameters
DB_KEEP_CACHE_SIZE
DB_RECYCLE_CACHE_SIZE
DB_nK_CACHE_SIZE

The solution suggested by Oracle is to upgrade to 11g or higher releases or to apply 10.2.0.5 patchset.