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

From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
To: <Arvind.Kumar@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 27 Jan 2009 15:06:53 -0500

         Bug 3704314 - OERI:kcbzfb_3 / OERI:kjmsm_epc instance crash
possible
 
Fixed in 9.2.0.6 and 10.1.0.2
 

Dick Goulet 
Senior Oracle DBA 
PAREXEL International 
978.313.3426 
 information transmitted in this communication is intended only for the
person or entity to which it is addressed and may contain confidential
and/or privileged material. Any review, retransmission, dissemination or
other use of, or taking of any action in reliance upon, this information
by persons or entities other than the intended recipient is prohibited.
If you received this in error, please destroy any copies, contact the
sender and delete the material from any computer.


 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Arvind Kumar
Sent: Tuesday, January 27, 2009 2:55 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: ORA-00600: [kcbzfb_3], [0x3A3FC0B00], [8], [0x4FCF93668],
[0x44CFD5468]



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.

References:
- ORA-00600: [kcbzfb_3], [0x3A3FC0B00], [8], [0x4FCF93668], [0x44CFD5468]
  - From: Arvind Kumar

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

Other related posts: