Upgrade Error: ORA-04063: View "WMSYS.WM_INSTALLATION" Has Errors
(Doc ID 2827507.1)
Last updated on JULY 20, 2024
Applies to:
Workspace Manager - Version 19.3.0.0.0 and laterInformation 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 |