Hello,

this statement (from Quest TOAD) force an ora-600

SQL> Select o.object_name, o.object_type, o.status, t.typecode,
t.attributes,
 2 t.methods
 3 from SYS.DBA_TYPES t, SYS.DBA_OBJECTS o
 4 where o.owner = 'SYSTEM'
 5 and  o.owner = t.owner
 6 and  o.object_type = 'TYPE'
 7 and  o.object_name = t.type_name
 8 and  o.subobject_name is null;
from SYS.DBA_TYPES t, SYS.DBA_OBJECTS o
      *
FEHLER in Zeile 3:
ORA-00600: internal error code, arguments: [15160], [], [], [], [], [],
[], []

This is BUG 4648181
ORA-600 [15160] JOINING DBA_OBJECTS AND DBA_SEGMENTS

Workaround: change the from clause order like this:

SQL> Select o.object_name, o.object_type, o.status, t.typecode,
t.attributes,
 2 t.methods
 3 from SYS.DBA_OBJECTS o, SYS.DBA_TYPES t
 4 where o.owner = 'SYSTEM'
 5 and  o.owner = t.owner
 6 and  o.object_type = 'TYPE'
 7 and  o.object_name = t.type_name
 8 and  o.subobject_name is null;

OBJECT_NAME           OBJECT_TYPE STATUS TYPECODE ATTRIBUTES
METHODS
--------------------------- ------------ ------- --------- ----------
----------
REPCAT$_OBJECT_NULL_VECTOR TYPE      VALID  OBJECT         4
    0

If you apply patch 4648181 you are hit
BUG 5006591
ORA-7445 [KGHALP] AND OTHER MEMORY CORRUPTIONS AFTER APPLYING PATCH 4648181

I recommend, test your application

Kind regards
Ronald


On 05.05.2006 08:35 Bart Goossens wrote:
> Hello,
>
> I've seen some complaints about the 10.2.0.2 patch, but only for
> RAC-environements. Is there anyone who allready installed the patch
> on a plain and simple single instance 10.2.0.1 database?
> Are there any issues?
>
> Kind regards,
>
> Bart
>
>
>


--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting