EM 13c: Upgrade to Enterprise Manager 13c Cloud Control Fails at MDS Schema Configuration With Error: PLS-00201: identifier ALL_USERS must be declared (Doc ID 2210164.1)

Last updated on DECEMBER 14, 2016

Applies to:

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

Symptoms

Upgrade from 12c to 13c Enterprise Manager (EM) Cloud Control fails at MDS Schema configuration.

From .../Middleware/cfgtoollogs/emmdscreate_<Timestamp>.log:

2016_11_02_AD_13_47_50_CDT EM 12c MDS schema detected. Begin upgrade process.
2016_11_02_AD_13_47_51_CDT UA response file is at /var/tmp/RCUMDSUPG3467800914077490131.tmp
2016_11_02_AD_13_47_51_CDT Begin to execute UA at /u1/app/oracle/product/13.2.0/GRID/Middlware/oracle_common/upgrade/bin/ua
2016_11_02_AD_13_47_51_CDT Oracle Fusion Middleware Upgrade Assistant 12.1.3.0.0
2016_11_02_AD_13_47_52_CDT Log file is located at: /u1/app/oracle/product/13.2.0/GRID/Middlware/oracle_common/upgrade/logs/ua2016-11-02-13-47-51PM.log
2016_11_02_AD_13_47_53_CDT Reading installer inventory, this will take a few moments.
2016_11_02_AD_13_48_44_CDT Oracle Metadata Services schema examine is in progress
2016_11_02_AD_13_48_45_CDT Oracle Metadata Services schema examine finished with status: succeeded
2016_11_02_AD_13_48_45_CDT Oracle Metadata Services schema upgrade is in progress
2016_11_02_AD_13_48_45_CDT -- 10%
2016_11_02_AD_13_48_45_CDT ----- 20%
2016_11_02_AD_13_48_46_CDT ---------- 40%
2016_11_02_AD_13_48_49_CDT --------------- 60%
2016_11_02_AD_13_48_49_CDT -------------------- 80%
2016_11_02_AD_13_48_49_CDT ------------------------- 100%
2016_11_02_AD_13_48_49_CDT Oracle Metadata Services schema upgrade finished with status: failed
2016_11_02_AD_13_48_49_CDT UA return with status 255
2016_11_02_AD_13_48_49_CDT MDS operation fails

 

From .../Middleware/oracle_common/upgrade/logs/ua2016-11-02-13-47-51PM.log:

[2016-11-02T13:48:49.462-05:00] [RCU] [ERROR] [] [upgrade.RCU.jdbcEngine] [tid: 1] [ecid: 6edd2d32-d689-4b2c-86d8-00811db6286b-00000001,0] Error encountered executing SQL statement FileName: '/u1/app/oracle/product/13.2.0/GRID/Middlware/oracle_common/common/sql/mds/sql/configurestats.sql' LineNumber: '59' Script log file: null
[2016-11-02T13:48:49.463-05:00] [MDS] [ERROR] [] [upgrade.MDS.SCHEMA_UPGRADE] [tid: 1] [ecid: 6edd2d32-d689-4b2c-86d8-00811db6286b-00000001,0] UPGAST-00221: unexpected error upgrading schema
[2016-11-02T13:48:49.463-05:00] [MDS] [ERROR] [] [upgrade.MDS.SCHEMA_UPGRADE] [tid: 1] [ecid: 6edd2d32-d689-4b2c-86d8-00811db6286b-00000001,0] [[
oracle.sysman.assistants.common.dbutil.SQLFatalErrorException: java.sql.SQLException: ORA-06550: line 2, column 16:
PLS-00201: identifier 'ALL_USERS' must be declared
ORA-06550: line 2, column 16:
PL/SQL: Item ignored
ORA-06550: line 9, column 5:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 9, column 5:
PL/SQL: Statement ignored
ORA-06550: line 11, column 24:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 10, column 5:
PL/SQL: Statement ignored
ORA-06550: line 18, column 7:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 17, column 5:
PL/SQL: Statement ignored

 

Note that in EM 13c, the OMS Oracle Home is the same as the Middleware Home.

 

 

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