My Oracle Support Banner

Error ORA-00600 XSOOPS xsOBJTYPE1 While Recompiling Objects After Converting Database to 64-Bit (Doc ID 787408.1)

Last updated on MARCH 10, 2020

Applies to:

Oracle OLAP - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample or bulit-in schema(s), Public Documentation delivered with an Oracle database product or other training material.  Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.

Recompilation of objects in database using utlrp.sql script after upgrading the database to 64-bit fails with below errors in alert.log.

*** 2009-02-28 12:07:29.832
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [XSOOPS], [xsOBJTYPE1], [], [], [], [], [], []
Current SQL statement for this session:
declare
rc sys_refcursor;
begin
:1 := "SYS"."OLAPIMPL_T"."ODCITABLEDESCRIBE"(:2 ,'SYS.AWCREATE duration session','OLAPSYS.OLAP_SYS_AW_ACCESS_TBL','','DIMENSION AW_DIM_ACCESS_INFO FROM OLAP_SYS_RETURN_INFO');
end;
----- PL/SQL Call Stack -----
object line object
handle number name
000007FFAB5800C0 23 SYS.OLAPIMPL_T
000007FFAB5800C0 17 SYS.OLAPIMPL_T
000007FF978A8EA8 4 anonymous block
000007FFBEC3AE48 946 package body SYS.DBMS_UTILITY
000007FFBEC3B100 1 anonymous block
000007FFBEF2D750 320 package body SYS.UTL_RECOMP
000007FFBEF2D750 636 package body SYS.UTL_RECOMP
000007FFBEF2D750 589 package body SYS.UTL_RECOMP
000007FFBDB36640 4 anonymous block
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedmp+663 CALL??? ksedst+55 003B777D8 00000001D 000000000 00001DC00
ksfdmp+19 CALL??? ksedmp+663 000000003 00CD4EB80 01AAB1CF8 003B9B9C0
kgerinv+158 CALL??? ksfdmp+19 01ABB1CF8 0FFFFFFFF 00455B2EC 0037CD3C3

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.