ORA-00600: internal error code, arguments: [2037] ORA-07445: exception encountered: core dump [kcbs_dump_adv_state]

During Startup (Open Database) Alert Log Shows ORA-600[2037] and ORA-7445[kcbs_dump_adv_state] (Doc ID 551993.1)

Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.3 - Release: 10.2 to 10.2 Information in this document applies to any platform. Symptoms The database may crash and fail to open due to undo/redo corruption if you are using distributed transactions. The following error may be seen in the alert log:      ORA-00600: internal error code, arguments: [2037] The call stack can look like this:      kcoexam kcbtema kcrpap kcrpdv kxfprdp ... In addition, the following error may also be seen in the alert log:      ORA-07445: exception encountered: core dump [kcbs_dump_adv_state] Cause The problem is caused by Bug 4899479  Undo/redo corruption if distributed transactions used. Details:                  Redo/undo corruption and associated dumps and/or ORA-600 errors/memory corruption can       occur from a transaction which uses "in memory undo" pool memory if the transaction also       includes distributed operations.  e.g.: Insert using buffered inserts, distributed operation,       subsequent insert can lead to this problem if the first insert uses in-memory undo. Solution To resolve the corruption, you will need to do a point in time recovery from a good backup. To prevent the bug from occurring, you may choose either of these options:      1. Apply the 10.2.0.4 patchset which was not available at the time of this writing (Feb 2008).      2. Check MetaLink for backport Patch 4899479 for your operating system and database release.