1 Reply Latest reply: Aug 1, 2012 2:39 PM by 929328 RSS

    INTERESTING:  ORA-00600: internal error code,

    NirmalSArri
      Here is the scenario:

      DB1 = 11.2.0.1.0 Linux 5
      DB2 = 11.2.0.1.0 Linux 5

      Init.ora on DB1 and DB2 are exactly the same.

      On DB1, I run this and get ORA-600:

      select distinct i.short_desc,c.short_desc, c.long_desc
      from pace_masterdbo.codes c, pace_masterdbo.code_values cv, pace_masterdbo.interfaces i
      where C.INSTANCE=CV.CODE_INST
      and CV.INTFC_INST=I.INSTANCE 2 3 4
      5 /
      from pace_masterdbo.codes c, pace_masterdbo.code_values cv, pace_masterdbo.interfaces i
      *
      ERROR at line 2:
      ORA-00600: internal error code, arguments: [qkaffsindex5], [], [], [], [], [], [], [], [], [], [], []

      -----------------------------------------------------------------------------------------------------------------------------------

      On DB2, with the same configuration and exact init.ora parameters it works without issue.

      -----------------------------------------------------------------------------------------------------------------------------------

      Now on DB1 if I change the following, it works fine, wondering what's going on.

      alter session set "_optimizer_cost_based_transformation" =off;

      Session altered.

      select distinct i.short_desc,c.short_desc, c.long_desc
      from pace_masterdbo.codes c, pace_masterdbo.code_values cv, pace_masterdbo.interfaces i
      where C.INSTANCE=CV.CODE_INST
      and CV.INTFC_INST=I.INSTANCE 2 3 4
      5 /


      NOW WORKS FINE.. ANY IDEA???


      Thanks in Advance..

      Nirmal
        • 1. Re: INTERESTING:  ORA-00600: internal error code,
          929328
          Ok I've already got this problem...

          After the upgrade from 11.5.9 / 9.2.0.8 to 11.5.10.2/10.2.0.3 we are getting errors in DB alert logs:

          ORA-00600: internal error code, arguments: [kcbz_check_objd_typ_3], [0], [0], [1], [], [], [], []

          A search through ORA-600 lookup tool turns up this note:


          Subject:     ORA-600 [kcbz_check_objd_typ_3]
          Doc ID:     Note:406787.1     Type:     REFERENCE
          Last Revision Date:     10-JUL-2008     Status:     PUBLISHED

          Note: For additional ORA-600 related information please read Note 146580.1

          PURPOSE:
          This article represents a partially published OERI note.

          It has been published because the ORA-600 error has been
          reported in at least one confirmed bug.

          Therefore, the SUGGESTIONS section of this article may help
          in terms of identifying the cause of the error.

          This specific ORA-600 error may be considered for full publication
          at a later date. If/when fully published, additional information
          will be available here on the nature of this error.

          SUGGESTIONS:

          If the Known Issues section below does not help in terms of identifying
          a solution, please submit the trace files and alert.log to Oracle
          Support Services for further analysis.

          Known Issues:
          Bug# 6405339 See Note 6405339.8
          Corruption / OERI[kcbz_check_objd_typ_3] / OERI:5400 from PQ
          Fixed: 10.2.0.5, 11.1.0.7, 11.2

          Bug# 5689412 See Note 5689412.8
          ORA-600 [kcbz_check_objd_typ_3] after SCN based recovery
          Fixed:

          Bug# 4592596 See Note 4592596.8
          Corruption (ORA-1410) from multi-table insert with direct load
          Fixed: 10.2.0.4, 11.1.0.6

          Bug# 4430244 + See Note 4430244.8
          Segment advisor can load blocks of dropped objects into buffer cache (KCB OERI errors)
          Fixed: 10.2.0.4, 11.1.0.6

          Metalink Note 466049.1 describes summary of Bugs Containing ORA - 00600[kcbz_check_objd_typ_3]

          If you have questions ask.
          Kirill Babeyev