ORA-600 (KGHALO2)

From: edwin devadanam <edwin_kodamala_at_yahoo.com>
Date: Mon, 18 May 2009 14:56:06 -0700 (PDT)
Message-ID: <576650.49106.qm_at_web52007.mail.re2.yahoo.com>



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_CLASSES FROM
    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 - 16:56:06 CDT

Original text of this message