My Oracle Support Banner

Upgrade Error: ORA-04063: View "WMSYS.WM_INSTALLATION" Has Errors (Doc ID 2827507.1)

Last updated on JANUARY 28, 2022

Applies to:

Workspace Manager - Version 19.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

An ORA-4063 error was generated during the upgrade to 19c. The catupgrd0.log spool file shows:

...

21:58:57 SQL> select * from wm_installation order by name ;
select * from wm_installation order by name
*
ERROR at line 1:
ORA-04063: view "WMSYS.WM_INSTALLATION" has errors

Elapsed: 00:00:00.03
21:58:57 SQL> column file_name new_value comp_file noprint;
21:58:57 SQL> var owm_script varchar2(128);
21:58:57 SQL> begin
21:58:57 2 :owm_script := dbms_registry.nothing_script;
21:58:57 3
21:58:57 4 if (:old_owm_version_for_upgrade = 'NOT_INSTALLED') then
...
21:58:57 21 end if ;
21:58:57 22 end;
21:58:57 23 /

PL/SQL procedure successfully completed.

...

------------------------------------------------------
Identifier OWM 21-12-08 09:58:57
SCRIPT = [/u01/app/orabin4/product/19.0.0.0/dbhome_1/rdbms/admin/owmupgrd.plb]
ERROR = [ORA-04063: view "WMSYS.WM_INSTALLATION" has errors]
STATEMENT = [select * from wm_installation order by name]
------------------------------------------------------

No other errors occurred during the upgrade of Oracle Workspace Manager (OWM).

Querying DBA_OBJECTS for INVALID objects does not list WMSYS.WM_INSTALLATION view.

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
Cause
Solution


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