EM 13c: Upgrading Enterprise Manager Cloud Control OMS from 12.1.0.5 To 13.2 Fails in Repository Configuration with ORA-00942 Error for Table EM_ODBA_ODASYS_TAGS_E

(Doc ID 2340514.1)

Last updated on JANUARY 02, 2018

Applies to:

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

Symptoms

Upgrading Enterprise Manager (EM) Cloud Control from 12.1.0.5 to 13.2 fails in the Repository Configuration step.
Configuring the software-only upgrade installation of EM 13.2 with the ConfigureGC.sh script shows the status bar achieving 38% and then the installation errors out with the following error message logged in <EM 13.2 OMS Oracle Home>/cfgtoollogs/cfgfw/CfmLogger_<date stamp>.log:

Fri Dec 8 13:53:55.008 CET 2017 rcu:Statement Type: 'BEGIN/END Anonymous Block'
Fri Dec 8 13:53:56.719 CET 2017 rcu:Extracting Statement from File Name: '/u01/app/oracle/em132/sysman/admin/emdrep/sql/upgrade_header.sql'Line Number: 2197
Fri Dec 8 13:53:56.719 CET 2017 rcu:Extracted SQL Statement: [DEFINE EM_SQL_ROOT = /u01/app/oracle/em132/plugins/oracle.dba.odba.oms.plugin_13.1.1.1.0/sql]
Fri Dec 8 13:53:56.719 CET 2017 rcu:Extracted SQL Statement: [DEFINE EM_SQL_ROOT = /u01/app/oracle/em132/plugins/oracle.dba.odba.oms.plugin_13.1.1.1.0/sql]
Fri Dec 8 13:53:56.719 CET 2017 rcu:Statement Type: 'DEFINE Statement'
Fri Dec 8 13:53:56.719 CET 2017 rcu:Extracting Statement from File Name: '/u01/app/oracle/em132/sysman/admin/emdrep/sql/upgrade_header.sql'Line Number: 2197
Fri Dec 8 13:53:56.719 CET 2017 rcu:Extracted SQL Statement: [DEFINE EM_SQL_ROOT = /u01/app/oracle/em132/plugins/oracle.dba.odba.oms.plugin_13.1.1.1.0/sql]
Fri Dec 8 13:53:56.719 CET 2017 rcu:Extracted SQL Statement: [DEFINE EM_SQL_ROOT = /u01/app/oracle/em132/plugins/oracle.dba.odba.oms.plugin_13.1.1.1.0/sql]
Fri Dec 8 13:53:56.719 CET 2017 rcu:Statement Type: 'DEFINE Statement'
Fri Dec 8 13:53:56.720 CET 2017 rcu:Extracting Statement from File Name: '/u01/app/oracle/em132/plugins/oracle.dba.odba.oms.plugin_13.1.1.1.0/sql/odba/13.1.1.1.0/oak/oak_edition_views_upgrade.sql'Line Number: 29
Fri Dec 8 13:53:56.720 CET 2017 rcu:Extracted SQL Statement: [create or replace editioning view EM_ODBA_ODASYS_TAGS as select * from EM_ODBA_ODASYS_TAGS_E]
Fri Dec 8 13:53:56.720 CET 2017 rcu:Statement Type: 'DDL Statement'
JDBC SQLException - ErrorCode: 942SQLState:42000 Message: ORA-00942: table or view does not exist

Error encountered executing SQL statement FileName: '/u01/app/oracle/em132/plugins/oracle.dba.odba.oms.plugin_13.1.1.1.0/sql/odba/13.1.1.1.0/oak/oak_edition_views_upgrade.sql' LineNumber: '31'
SQL Statement: [create or replace editioning view EM_ODBA_ODASYS_TAGS as select * from EM_ODBA_ODASYS_TAGS_E]
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

 

 

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