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

  • From: David Barbour <david.barbour1@xxxxxxxxx>
  • To: Arvind.Kumar@xxxxxxxxxxxxx
  • Date: Tue, 27 Jan 2009 15:06:11 -0500

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 <javascript:getdoc('NOTE:245840.1')> 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 <javascript:taghelp('AFFECTS_9205')>

 *Platforms affected* Generic (all / most platforms affected)

*Fixed:*

*This issue is fixed in*

   - 9.2.0.6 (Server Patch Set) <javascript:taghelp('FIXED_9206')>
   - 10.1.0.2 (Base Release) <javascript:taghelp('FIXED_A102')>

*Symptoms:**Related To:*

   - Internal Error May Occur (ORA-600) <javascript:taghelp('TAGS_OERI')>
   - Instance May Crash <javascript:taghelp('TAGS_CRASH')>
   - ORA-600 [kcbzfb_3] <javascript:getdoc(':284550.1');>
   - ORA-600 [kjmsm_epc] <javascript:getdoc(':285660.1');>


   - RAC (Real Application Clusters) / OPS <javascript:taghelp('TAGS_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:

  1. Home
  2. oracle-l
  3. Archive
  4. 01-2009