RE: ORA-00600: [kcbzfb_3], [0x3A3FC0B00], [8], [0x4FCF93668], [0x44CFD5468]

  • From: "Arvind Kumar" <Arvind.Kumar@xxxxxxxxxxxxx>
  • To: "David Barbour" <david.barbour1@xxxxxxxxx>
  • Date: Tue, 27 Jan 2009 22:36:13 +0200

this is not a RAC datbase. None of the background or any oracle process was 
killed on OS level, as this metalink note says it may happen if a process is 
killed on OS level.
 
Thanks
Arvind Kumar

________________________________

From: David Barbour [mailto:david.barbour1@xxxxxxxxx]
Sent: Tue 1/27/2009 10:06 PM
To: Arvind Kumar
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: ORA-00600: [kcbzfb_3], [0x3A3FC0B00], [8], [0x4FCF93668], 
[0x44CFD5468]


From Metalink Note #3704314.8:

Subject:         Bug 3704314 - OERI:kcbzfb_3 / OERI:kjmsm_epc instance crash 
possible   
         Doc ID:         3704314.8       Type:  PATCH   
         Modified Date:         24-SEP-2008      Status:        PUBLISHED       

Bug 3704314  OERI:kcbzfb_3 / OERI:kjmsm_epc instance crash possible

 This note gives a brief overview of bug 3704314. 
 The content was last updated on: 24-JAN-2005
 Click here for details of each of the sections below.


Affects:


Product (Component)      Oracle Server (Rdbms)  
Range of versions believed to be affected        Versions < 10.1.0.2    
Versions confirmed as being affected     
*       9.2.0.5 

Platforms affected       Generic (all / most platforms affected)        


Fixed:


This issue is fixed in   *      9.2.0.6 (Server Patch Set) 
*       10.1.0.2 (Base Release) 


Symptoms:


Related To:


*       Internal Error May Occur (ORA-600) 
*       Instance May Crash 
*       ORA-600 [kcbzfb_3] 
*       ORA-600 [kjmsm_epc] 

*       RAC (Real Application Clusters) / OPS 


Description


        ORA-600 [kcbzfb_3] / ORA-600 [kjmsm_epc] instance crash possible
        in RAC if a process is killed at OS level (eg: using kill -9) 
        at an particular point in the code.

Please note: The above is a summary description only. Actual symptoms can vary. 
Matching to any symptoms here does not confirm that you are encountering this 
problem. Always consult with Oracle Support for advice.   


References


        Bug 3704314 
<https://metalink.oracle.com/metalink/plsql/showdoc?db=Bug&id=3704314>  (This 
link will only work for PUBLISHED bugs)
        Note 245840.1 
<https://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=245840.1&blackframe=1>
  Information on the sections in this article 





On Tue, Jan 27, 2009 at 2:55 PM, Arvind Kumar <Arvind.Kumar@xxxxxxxxxxxxx> 
wrote:


        Hello all,

         

        I got the following error in alert log and instance crashed, Has any 
experienced such ORA-00600 : [kcbzfb_3]  ?

         

        Errors in file 
/u300/app/oracle/admin/SIYPROD/bdump/siyprod_j000_5157.trc:

        ORA-00600: internal error code, arguments: [kcbzfb_3], [0x3A3FC0B00], 
[8], [0x4FCF93668], [0x44CFD5468], [], [], []

         

        And /u300/app/oracle/admin/SIYPROD/bdump/siyprod_j000_5157.trc

         

        Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production

        With the Partitioning, OLAP and Oracle Data Mining options

        JServer Release 9.2.0.4.0 - Production

        ORACLE_HOME = /u300/app/oracle/product/9.2.0

        System name:   SunOS

        Node name:       ora01

        Release:           5.9

        Version:            Generic_122300-26

        Machine:           sun4us

        Instance name: SIYPROD

        Redo thread mounted by this instance: 1

        Oracle process number: 56

        Unix process pid: 5157, image: oracle@ora01 (J000)

         

        *** SESSION ID:(99.21742) 2009-01-27 00:54:04.912

        *** 2009-01-27 00:54:04.912

        ksedmp: internal or fatal error

        ORA-00600: internal error code, arguments: [kcbzfb_3], [0x3A3FC0B00], 
[8], [0x4FCF93668], [0x44CFD5468], [], [], []

        Current SQL statement for this session:

        SELECT  SUM( DECODE(PAYMENTSTATUSID, 3,          
DECODE(NVL(GROSSCREDITDAYS, 0), 0, (nvl(creditDays,0) + 
nvl(UnderCreditDays,0)-nvl(OverCreditDays,0)),     GROSSCREDITDAYS), 0)),       
   SUM(DECODE(PAYMENTSTATUSID, 5, NVL(GROSSCREDITDAYS, 0), 0))  FROM            
 CLA_T_UPaySchedule WHERE   claimno=12090655      AND       paymentstatusid 
IN(3,5)

        ----- PL/SQL Call Stack -----

          object      line  object

          handle    number  name

        6329cba80       102  package body SIYAYAUSER.PK_CLAIMFINALIZED

        65f5052f8         1  anonymous block

        ----- Call Stack Trace -----

         

        Thanks & Regards, 
        Arvind Kumar


        Disclaimer
        This e-mail and any attachments transmitted with it are confidential 
and intended solely for the use of the individual or entity to whom it is 
addressed. If you have received this e-mail in error please notify the sender 
and delete the original message. Any views or opinion expressed in this e-mail 
are those of the author and do not necessarily represent those of the 
Department of Labour. The recipient should check this e-mail and any 
attachments for the presence of viruses and other destructive codes. While all 
possible precautions have been taken, the Department accepts no liability 
whatsoever for loss or damage resulting from the opening of this message or 
attachments, or the use of the information contained in this message or 
attachment.
        


Other related posts: