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.
 

Un comentariu:

  1. The most effective method to Solve Oracle ORA-01019 Error Message through Remote DBA Services
    The Oracle ORA-01019 blunder message implies unfit to distribute the memory in client side. The fundamental driver for this issue is the client side memory allocator returned mistake. Well! To tackle this issue you need to expand the procedures pile estimate or likewise you need to change to old arrangement of calls. Be that as it may, on the off chance that you need snappy arrangement with respect to this issue at that point rapidly contact to Database Administration for Oracle or Online Oracle DB Support.
    For More Info: https://cognegicsystems.com/
    Contact Number: 1-800-450-8670
    Email Address- info@cognegicsystems.com
    Company’s Address- 507 Copper Square Drive Bethel Connecticut (USA) 06801

    RăspundețiȘtergere