Vs: ORA-00600: [kcbzfb_3], [0x3A3FC0B00], [8], [0x4FCF93668], [0x44CFD5468]
Date: Tue, 27 Jan 2009 22:07:07 +0200
Message-Id: <s97f85a5.028_at_gw00.edita.fi>
Hi!
Did you check metalink for answears?
Maybe hitting bug:
Bug 3704314 OERI:kcbzfb_3 / OERI:kjmsm_epc instance crash possible
-Teijo L.
Teijo Lallukka, Oracle DBA (Tietokantaylläpitäjä) Edita Prima Oy, Hakuninmaa
PL 200 , 00043 EDITA
GSM: +358 (0)40 860 2674
teijo.lallukka_at_edita.fi http://www.edita.fi
www.edilex.fi | www.finlex.fi | www.credita.fi
>>> "Arvind Kumar" <Arvind.Kumar_at_labour.gov.za> 27.01.09 21:55 PM >>>
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_at_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.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 27 2009 - 14:07:07 CST