2011-07-03

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.
 

Niciun comentariu:

Trimiteți un comentariu