RE: ORA-600 (KGHALO2)
Date: Tue, 19 May 2009 00:24:48 -0400
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F164410C0_at_AAPQMAILBX02V.proque.st>
Hi Edwin,
Even if you're stuck on 8.1.7, why on earth would you run 8.1.7.0? At least upgrade to 8.1.7.4, see if that fixes the problem.
If that doesn't do it, you can open an SR. Oracle won't provide a new patch, but if it's a known bug with a one-off patch available, you may be able to solve the problem that way.
But, I think those are really your only options.
-Mark
From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] On Behalf Of edwin devadanam [edwin_kodamala_at_yahoo.com] Sent: Monday, May 18, 2009 17:56
To: oracle-l_at_freelists.org
Cc: edwin_kodamala_at_yahoo.com
Subject: ORA-600 (KGHALO2)
Hi,
in database version 8.1.7.0 and 11.0.3 apps (pretty old one after 6 months we are moving all the data to new 12g apps and db 10gR2 database...now upgrade is not solution...)
When i am executing Materlized view...i get below error
CREATE MATERIALIZED VIEW APPS.PPG_RG_BOD_LBL_MVW
TABLESPACE PPGREGD
BUILD IMMEDIATE
REFRESH COMPLETE ON DEMAND
AS
SELECT
A.MFG_ITEM_NO ITEM_CODE,
D.ITEM_DESC ITEM_DESCRIPTION,
DECODE(F.ADR_HAZD_CLASS,'None','0','1') DG_ADR, DECODE(F.ADR_HAZD_CLASS,'None','0','1') DG_IATA, DECODE(F.ADR_HAZD_CLASS,'None','0','1') DG_IMDG, F.ADR_HAZD_CLASS DG_CLASS, F.ADR_PACK_GRP PACKAGE_GROUP, F.ADR_ONU_MAT_CODE UN_NR, F.SUBSIDIARY_CLASSES SUBSIDIARY_CLASSESFROM
PPGREG.PPG_CS_BULK_HDR A, PPGREG.PPG_RG_MSDS_LINK B, PPGREG.PPG_RG_RESULTS_HDR C, PPGREG.PPG_RG_REQUEST_HDR D, PPGREG.PPG_RG_CALC_PARAM E,
APPS.PPG_RG_LABEL_VW F
WHERE
A.BULK_NO = B.ITEM_NO
AND B.OBSOLESCENCE_DATE IS NULL AND B.RESULT_REQUEST_ID = C.RESULT_REQUEST_ID AND C.REG_REQUEST_ID = D.REG_REQUEST_ID AND D.REG_REQUEST_ID = E.REG_REQUEST_ID AND E.TDG_LOC_CODE = '3820' AND B.RESULT_REQUEST_ID = F.RESULT_REQUEST_ID; /
/
PPGREG.PPG_CS_BULK_HDR A,
*
ERROR at line 20:
ORA-00600: internal error code, arguments: [KGHALO2], [0], [], [], [], [], [],
[]
SQL> AND B.RESULT_REQUEST_ID = F.RESULT_REQUEST_ID *
ERROR at line 33:
ORA-02050: transaction 6.81.951996 rolled back, some remote DBs may be in-doubt ORA-03106: fatal two-task communication protocol error ORA-02063: preceding line from TDG
can we fix above issue as 8i is already not supported by oracle..
Thanks,
Edwin.K
--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 18 2009 - 23:24:48 CDT