RE: ORA-600 (KGHALO2)

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@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] On Behalf 
Of edwin devadanam [edwin_kodamala@xxxxxxxxx]
Sent: Monday, May 18, 2009 17:56
To: oracle-l@xxxxxxxxxxxxx
Cc: edwin_kodamala@xxxxxxxxx
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


Other related posts: