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 JANUARY 30, 2022
Applies to:
Workspace Manager - Version 10.2.0.5 and laterInformation in this document applies to any platform.
Symptoms
After upgrading 10.2.0.4 to 10.2.0.5 (10.2.0.5.8) Multimedia is invalid and there are several WMSYS 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*
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 |