标题: ORA-1400 On WMSYS.OWM_VSCRIPT_PKG During Upgrade to 12.1 (Doc ID 1933789.1) [打印本页] 作者: 郑全 时间: 2024-5-22 19:09 标题: 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.