RE: ORA-600 (KGHALO2)

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
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_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 - 23:24:48 CDT