ORA-1400 On WMSYS.OWM_VSCRIPT_PKG During Upgrade to 12.1 (Doc ID 1933789.1)

郑全

ORA-1400 On WMSYS.OWM_VSCRIPT_PKG During Upgrade to 12.1 (Doc ID 1933789.1)       

Symptoms
Cause
Solution
References

APPLIES TO:
Workspace Manager - Version 12.1.0.1 to 12.2.0.1 [Release 12.1 to 12.2]
Information in this document applies to any platform.
SYMPTOMS
During the upgrade from 11.2 to 12.1, the following error is reported in the upgrade log:

begin
  wmsys.owm_vscript_pkg.upgradeOWM(:old_owm_version_for_upgrade) ;
end;
/
begin
*
ERROR at line 1:
ORA-20001: Errors encountered during table migration. Query wmsys.wm$migration_error_table.
ORA-06512: at "WMSYS.OWM_VSCRIPT_PKG", line 3730
ORA-06512: at "WMSYS.OWM_VSCRIPT_PKG", line 3544
ORA-06512: at line 2

The wmsys.wm$migration_error_table contains the following error messages:

ERROR: ORA-01400: cannot insert NULL into ("WMSYS"."WM$WORKSPACES_TABLE$"."POST_VERSION")
ERROR: ORA-01400: cannot insert NULL into ("WMSYS"."WM$NEXTVER_TABLE$"."WORKSPACE#")
ERROR: ORA-01400: cannot insert NULL into ("WMSYS"."WM$VERSION_HIERARCHY_TABLE$"."WORKSPACE#")


CAUSE
This is caused by the following bug:

BUG 19652546 - WSM UPGRADE DOES NOT ACCOUNT FOR POSSIBLY NULL VALUES IN WM$WORKSPACES_TABLE

If an 11g database has a workspace where the post_version is NULL, upgrade to 12.1 will fail with the following error:

ORA-01400: cannot insert NULL into ("WMSYS"."WM$WORKSPACES_TABLE$"."POST_VERSION")


Run the following query to confirm Bug 19652546:

col workspace format a15
col parent_workspace for a15

select workspace, parent_workspace, post_version
from wmsys.wm$workspaces_table;


You should get output similar to the following:

SQL> select workspace, parent_workspace, post_version
   2 from wmsys.wm$workspaces_table;

WORKSPACE        PARENT_WORKSPAC POST_VERSION
---------------- --------------- ------------
LIVE


SOLUTION
Bug 19652546 is fixed in 12.2.

To avoid the error during the upgrade, deinstall and reinstall Workspace Manager before the upgrade.

connect / as sysdba
@?/rdbms/admin/owmuinst.plb
@?/rdbms/admin/owminst.plb

After the upgrade has already completed, deinstall and reinstall Workspace Manager on the target db, to avoid any future problems.