After Upgrade From 10.2.0.4 To 10.2.0.5(.8) There Are WMSYS Objects Not In Sync (Doc ID 1516195.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Symptoms

After upgrading 10.2.0.4 to 10.2.0.5 (10.2.0.5.8) Multimedia is invalid and there are severla WMSYS's objects
invalid due to the error ORA-942 Table or View does not exist.

All the public synonyms for SYS objects as well as the privilege to use them existed, therefore this is not a problem

The result of the query

suggested in
HCKW-0016 - Dependency$ p_timestamp mismatch for VALID objects (Doc ID 1361045.1)
as well the hcheck.sql script from
"hcheck.sql" script to check for known problems in Oracle8i, Oracle9i, Oracle10g and Oracle 11g (Doc ID 136697.1)
show there is a problem with timestamps out of sync:

D_NAME                             D_TYPE OWNER
------------------------------ ---------- ------------------------------   
P_OBJ P_NAME                         P_Timestamp
---------- ------------------------------ -----------------------------
STIME                         X
----------------------------- --------
WM$VERSIONED_TABLES                     2 WMSYS      
9896 WM$ED_UNDO_CODE_TABLE_TYPE     29-JUL-2001 12:08:55
18-NOV-2012 08:50:02          *DIFFER*

WM$VERSIONED_TABLES_UNDO_CODE           2 WMSYS      
9895 WM$ED_UNDO_CODE_NODE_TYPE      29-JUL-2001 12:08:55
18-NOV-2012 08:50:02          *DIFFER*

XDB$NLOCKS                              2 XDB     41457
XDB$NLOCKS_T                   10-NOV-2008 10:40:55
18-NOV-2012 08:48:45          *DIFFER*

XDW1RlNY2a0P7gQwrSJxHQ/g==             55 XDB    
41603 privilegeNameType1_T           10-NOV-2008 10:41:02
18-NOV-2012 08:48:45          *DIFFER*

Cause