Wednesday, January 21, 2015

ORA-00942 for WMSYS.OWM_MIG_PKG When Upgrading from 11.2.0.3 to 11.2.0.4

"ORA-06512: at "WMSYS.OWM_MIG_PKG", line 1579" was observed while upgrading 11.2.0.3 enterprise edition to 11.2.0.4. Upgrade was continued selecting the ignore option. Show below is the output from the upgrade result summary.

If after the upgrade the database registry shows the status valid for oracle workspace manager then this error could be safely ignored.
COMP_ID                        COMP_NAME                                STATUS     VERSION
------------------------------ ---------------------------------------- ---------- -----------
EM                             Oracle Enterprise Manager                VALID      11.2.0.4.0
OWB                            OWB                                      VALID      11.2.0.3.0
APEX                           Oracle Application Express               VALID      3.2.1.00.12
AMD                            OLAP Catalog                             VALID      11.2.0.4.0
SDO                            Spatial                                  VALID      11.2.0.4.0
ORDIM                          Oracle Multimedia                        VALID      11.2.0.4.0
XDB                            Oracle XML Database                      VALID      11.2.0.4.0
CONTEXT                        Oracle Text                              VALID      11.2.0.4.0
EXF                            Oracle Expression Filter                 VALID      11.2.0.4.0
RUL                            Oracle Rules Manager                     VALID      11.2.0.4.0
OWM                            Oracle Workspace Manager                 VALID      11.2.0.4.0
CATALOG                        Oracle Database Catalog Views            VALID      11.2.0.4.0
CATPROC                        Oracle Database Packages and Types       VALID      11.2.0.4.0
JAVAVM                         JServer JAVA Virtual Machine             VALID      11.2.0.4.0
XML                            Oracle XDK                               VALID      11.2.0.4.0
CATJAVA                        Oracle Database Java Packages            VALID      11.2.0.4.0
APS                            OLAP Analytic Workspace                  VALID      11.2.0.4.0
XOQ                            Oracle OLAP API                          VALID      11.2.0.4.0
RAC                            Oracle Real Application Clusters         VALID      11.2.0.4.0




Useful metalink notes
ORA-00942 during database upgrade of Oracle Workspace Manager [ID 1399508.1]
Post-Upgrade Status Script utlu112s.sql Fails with ORA-942 [ID 1051991.1]
ORA-20194 And ORA-01720 During Upgrade of Oracle Workspace Manager When Upgrading from 11.2.0.3 to 11.2.0.4 [ID 1666657.1]

Related Posts
Upgrading RAC from 11.2.0.3 to 11.2.0.4 - Grid Infrastructure
Upgrading RAC from 11.2.0.3 to 11.2.0.4 - Database