Oracle Workspace Manager Invalid After 12.1 Upgrade (Doc ID 2528241.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

Oracle Workspace Manager database component shows INVALID after upgrading from 12.1 to 12.2.

1) Before Upgrade:

Oracle Component                   Upgrade Action          Current Status
----------------                             --------------                --------------
Oracle Workspace Manager        [to be upgraded]       VALID

2) After Upgrade:

COMP_NAME                           STATUS                VERSION
Oracle Workspace Manager       INVALID               12.2.0.1.0

Verified OWM has no invalid objects:

SQL> select * from dba_objects where owner = 'WMSYS' and STATUS != 'VALID'
no rows selected.

SQL> select dbms_wm.getWorkspace from dual
GETWORKSPACE
--------------------------------------------------------------------------------
LIVE
1 row selected.

3) There are several errors registered:

sql> select sys.dbms_registry.count_errors_in_registry('OWM') from dual;
SYS.DBMS_REGISTRY.COUNT_ERRORS_IN_REGISTRY('OWM')
-------------------------------------------------
4

Error messages may look like below:

sql> SELECT distinct(substr(to_char(message),1,60)) OWM_Upgrade_Errors
FROM sys.registry$error
WHERE substr(to_char(message),1,9) != 'ORA-00001'
AND trim(identifier) = 'OWM';

OWM_UPGRADE_ERRORS
------------------------------------------------------------
ORA-06512: at line 87 ORA-06512: at line 87

ORA-06512: at "WMSYS.OWM_MIG_PKG", line 128 ORA-06512: at "W
ORA-06512: at "WMSYS.LT_CTX_PKG", line 1839 ORA-06508: PL/SQ
ORA-06512: at "WMSYS.OWM_MIG_PKG", line 1861 ORA-06512: at "
ORA-04063: package body "WMSYS.LTUTIL" has errors
ORA-04063: package body "WMSYS.LTUTIL" has errors ORA-06508:
ORA-06508: PL/SQL: could not find program unit being called:
ORA-06512: at "WMSYS.OWM_MIG_PKG", line 1962 ORA-06512: at l
ORA-06512: at "WMSYS.OWM_MIG_PKG", line 250 ORA-06512: at li
ORA-06512: at "WMSYS.OWM_VSCRIPT_PKG", line 3841 ORA-06512:
ORA-06512: at line 87
ORA-04063: package body "WMSYS.LTUTIL" has errors ORA-06512:
ORA-06512: at "WMSYS.OWM_MIG_PKG", line 88 ORA-06512: at lin
ORA-06512: at "WMSYS.OWM_MIG_PKG", line 1934 ORA-06512: at "
ORA-01952: system privileges not granted to 'WMSYS' ORA-0651
ORA-06512: at line 1
ORA-06512: at "WMSYS.LT_CTX_PKG", line 1831 ORA-06512: at "W

17 rows selected.

4) The script in Doc ID 2350450.1 shows PLSQL_WARNINGS was set to DISABLE:ALL during the upgrade:

sql> show parameters plsql_warnings
plsql_warnings string DISABLE:ALL

5) Error logged in upg_summary.log (displayed partially)

Oracle Workspace Manager
ORA-01952: system privileges not granted to 'WMSYS' ORA-06512: at "WMSYS.OWM_VSCRIPT_PKG", line 3841
ORA-06512: at line 87
ORA-06512: at line 87

ORA-06512: at "WMSYS.OWM_VSCRIPT_PKG", line 3841 ORA-06512: at line 87
ORA-06512: at line 87

ORA-06512: at line 87 ORA-06512: at line 87

ORA-06512: at line 87
ORA-04063: package body "WMSYS.LTUTIL" has errors ORA-06508: PL/SQL: could not find program unit being called: "WMSYS.LTUTIL"
ORA-06512: at "WMSYS.OWM_MIG_PKG", line 250
ORA-06512: at line 1

......

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.