EM 13c: Enterprise Manager 12c Cloud Control Upgrade to 188.8.131.52.0 Fails with Error: ORA-54032: column to be renamed is used in a virtual column expression
Last updated on OCTOBER 12, 2016
Applies to:Enterprise Manager Base Platform - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
Enterprise Manager (EM) Cloud Control upgrade from EM12c 220.127.116.11 to 18.104.22.168 fails at the repository configuration step.
From <OMS Oracle Home>/cfgtoollogs/cfgfq/CfmLogger_2016-10-05_01-22-54-AM.log:
INFO: oracle.sysman.top.oms:Starting both repos upgrade and transx loading in parallel
INFO: oracle.sysman.top.oms:Running the repository in the upgrade mode
INFO: oracle.sysman.top.oms:The command run for transx is /project/mw/oem_01/em13c/middleware/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<full_qualified_host_name>)(PORT=1521)))(LOAD_BALANCE=ON)(CONNECT_DATA=(SERVICE_NAME=OEM02))) -action transx -repos_user SYSMAN -dbUser SYS -mwHome /project/mw/oem_01/em13c/middleware -mwOraHome /project/mw/oem_01/em13c/middleware
ORA-54032: column to be renamed is used in a virtual column expression
Statement:ALTER TABLE EM_METBSLN_DATASOURCE_E RENAME COLUMN target_guid TO object_guid
INFO: oracle.sysman.top.oms:The plug-in Repository Upgrade has failed its perform method
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms