My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.