Kom på arbejde her til morgen, og fandt nedenstående Oracle 600 fejl i min mail box. Miljøet er SUN 9 og databaserne er 10.2.0.2. Jeg havde siddet og trukket nogle data ud i går aftes fra DBA_TYPES og DBA_OBJECTS. Nedenstående er mit SQL script der producere denne 600 fejl.

  1  Select o.object_name, o.object_type, o.status, t.typecode,
  2  t.attributes,
  3       t.methods
  4       from SYS.DBA_TYPES t, SYS.DBA_OBJECTS o
  5       where o.owner = 'SYSTEM'
  6       and o.owner = t.owner
  7       and o.object_type = 'TYPE'
  8       and o.object_name = t.type_name
  9*      and o.subobject_name is null
SQL> /
     from SYS.DBA_TYPES t, SYS.DBA_OBJECTS o
              *
ERROR at line 4:
ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []
 
Efter lidt kiggen omkring (BUG 4648181) ligger problemmet i FROM sætningen SYS.DBA_TYPES t, SYS.DBA_OBJECTS o, hvis der f.eks gøres følgende
  
  1  select o.object_name, o.object_type, o.status, t.typecode,
  2  t.attributes,
  3       t.methods
  4       from SYS.DBA_OBJECTS o, SYS.DBA_TYPES t
  5       where o.owner = 'SYSTEM'
  6       and o.owner = t.owner
  7       and o.object_type = 'TYPE'
  8       and o.object_name = t.type_name
  9*      and o.subobject_name is null
SQL> /
 
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE         STATUS  TYPECODE                       ATTRIBUTES    METHODS
------------------- ------- ------------------------------ ---------- ----------
REPCAT$_OBJECT_NULL_VECTOR
TYPE                VALID   OBJECT                                  4          0

Altså der byttes om på FROM sætningen fra SYS.DBA_TYPES t, SYS.DBA_OBJECTS o, til SYS.DBA_OBJECTS o, SYS.DBA_TYPES t. Og dette er altså W.A på denne ! Nedenfor Metalink forklaring på denne fejl.

PURPOSE:
  This article discusses the internal error "ORA-600 [15160]", what it means and possible actions. The information here is only applicable to the versions listed and is provided only for guidance.

ERROR:
  ORA-600 [15160]

VERSIONS:
  versions 7.0 to 10.1

DESCRIPTION:

  We are attempting to find a suitable table as the starting point in a complex join operation.This error is reported when a suitable table can not be indentified.

FUNCTIONALITY:
  Kernel Kompile Optimizer

IMPACT:
  PROCESS FAILURE
  NON CORRUPTIVE - No underlying data corruption.

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.