EM13c: 13c Cloud Control Installation Fails at Repository Configuration With "ORA-02303: cannot drop or replace a type with type or table dependents" (Doc ID 2096776.1)

Last updated on FEBRUARY 25, 2016

Applies to:

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

Symptoms

13c Cloud Control installation fails at repository configuration with following error:

From <13c_MIDDLEWARE_HOME>/cfgtoollogs/cfgfw/CfmLogger_<timestamp>.log:
====================
INFO: oracle.sysman.top.oms:The transx action failed. Execute RepManager with -action transx.
INFO: oracle.sysman.top.oms:process_id:1v2wt3t6x1v2c
INFO: oracle.sysman.top.oms:Failure...
INFO: oracle.sysman.top.oms:1 error(s) happened in performing the action:
INFO: oracle.sysman.top.oms:1):
ORA-02303: cannot drop or replace a type with type or table dependents
File:/oracle/app/13.1/em/middleware/sysman/admin/emdrep/sql/core/latest/sdk/sdk_types.sql
Statement:CREATE OR REPLACE TYPE MGMT_INTEGER_ARRAY AS VARRAY(5000) OF INTEGER;

INFO: oracle.sysman.top.oms:The plug-in Repository Configuration has failed its perform method
====================

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