Trace File With ORA-00942 in XDB.FUNCSTATS.ODCISTATSDELETE Function when Upgrading XML DB Component to 11.1.0.7 (Doc ID 987606.1)

Last updated on JANUARY 11, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.1.0.7 - Release: 11.1 to 11.1
Information in this document applies to any platform.

Symptoms

While upgrading from 10.2.0.2 to 11.1.0.7, found the following error the alert.log file:

Thu Apr 09 13:37:00 2009
SERVER COMPONENT id=CONTEXT: status=VALID, version=11.1.0.7.0, timestamp=2009-04-09 13:37:00
Errors in file e:\app\administrator\diag\rdbms\orc6\orc6\trace\orc6_ora_1172.trc:
ORA-00604: error occurred at recursive SQL level 3
ORA-00942: table or view does not exist
Thu Apr 09 13:40:43 2009
SERVER COMPONENT id=XDB: status=VALID, version=11.1.0.7.0, timestamp=2009-04-09 13:40:43

The trace file has following content:

*** 2009-04-09 13:37:02.515
----- Error Stack Dump -----
ORA-00604: error occurred at recursive SQL level 3
ORA-00942: table or view does not exist
----- Current SQL Statement for this session (sql_id=amsx6a4s0vgav) -----
begin
:1 := XDB.FUNCSTATS.ODCISTATSDELETE(SYS.ODCIINDEXINFO('XDB', 'XDBHI_IDX',
SYS.ODCICOLINFOLIST(sys.ODCICOLINFO('XDB', 'XDB$RESOURCE', '"SYS_NC00032$"',
'XMLTYPE', 'SYS', NULL, 0, 30392, 0, 0)), NULL, 0, 0, 0, 0), :2, SYS.ODCIENV(0, 3, 0, 84));
end;
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x3bf53d64 34 XDB.FUNCSTATS
0x3f37e438 2 anonymous block
0x3bea9748 7 anonymous block

----- Call Stack Trace -----
ksedmp()+47 call dbkedDefDump() 1 ? 0 ?
qm_init_uga()+1658 call ksedmp() 1 ? BFFF03DC ? 981D039 ? 0 ? AE7AB2B8 ? 10609D80 ?
qmrvstatsdel()+306 call qm_init_uga() AE7AB2B8 ? AE7AB268 ? 0 B754B6B4 ? B754B0D4 ?
spefcpfa()+291 call 00000000 BFFF1474 ? AE7AB4AC ?
...

Changes

Database upgraded from 10g to 11gR1.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms