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 and later
Information in this document applies to any platform.


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/]
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.


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

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