ORA-00942: table or view does not exist, ORA-6512: at "WMSYS.OWM_MIG_PKG" during database upgrade of Oracle Workspace Manager (Doc ID 1399508.1)

Last updated on MARCH 20, 2017

Applies to:

Workspace Manager - Version 10.1.0.2 to 11.2.0.3 [Release 10.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 29-Jul-2013***

Symptoms

During a database upgrade, an ORA-00942 is encountered while Oracle Workspace Manager (OWM) is being upgraded:

...
...

SQL> execute wmsys.ltric.recreatePtUpdDelTriggers;

PL/SQL procedure successfully completed.

SQL> execute wmsys.owm_mig_pkg.moveWMMetaData;
BEGIN wmsys.owm_mig_pkg.moveWMMetaData; END;
*
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-06512: at "WMSYS.OWM_MIG_PKG", line 1579
ORA-06512: at "WMSYS.OWM_MIG_PKG", line 1596
ORA-06512: at line 1

SQL> /* Recompile any invalid objects */
SQL> execute wmsys.owm_mig_pkg.recompileAllObjects ;

PL/SQL procedure successfully completed.

...
...


After the upgrade, dba_registry shows OWM is VALID, and there are no INVALID objects related to this component:

COMP_ID      STATUS      VERSION    COMP_NAME
------------ ----------- ---------- ----------------------------------------
CATALOG      VALID       11.2.0.3.0 Oracle Database Catalog Views
CATJAVA      VALID       11.2.0.3.0 Oracle Database Java Packages
CATPROC      VALID       11.2.0.3.0 Oracle Database Packages and Types
CONTEXT      VALID       11.2.0.3.0 Oracle Text
EXF          VALID       11.2.0.3.0 Oracle Expression Filter
JAVAVM       VALID       11.2.0.3.0 JServer JAVA Virtual Machine
ORDIM        VALID       11.2.0.3.0 Oracle Multimedia
OWM          VALID       11.2.0.3.0 Oracle Workspace Manager
RUL          VALID       11.2.0.3.0 Oracle Rules Manager
XDB          VALID       11.2.0.3.0 Oracle XML Database
XML          VALID       11.2.0.3.0 Oracle XDK

11 rows selected.

SELECT OWNER, OBJECT_NAME, OBJECT_TYPE
FROM DBA_OBJECTS
WHERE STATUS = 'INVALID'
ORDER BY OWNER, OBJECT_NAME, OBJECT_TYPE;

no rows selected

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