EM 13c: Enterprise Manager 12c Cloud Control Upgrade to 13.1.0.0.0 Fails with Error: ORA-54032: column to be renamed is used in a virtual column expression (Doc ID 2191605.1)

Last updated on OCTOBER 12, 2016

Applies to:

Enterprise Manager Base Platform - Version 13.1.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Enterprise Manager (EM) Cloud Control upgrade from EM12c 12.1.0.4 to 13.1.0.0 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:Completed...
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
File:/project/mw/oem_02/em13c/middleware/sysman/admin/emdrep/sql/core/13.1.0.0/met_bsln/met_bsln_table_upgrade.sql
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

 

 

 

Changes

 

Cause

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