EM13c: 12c to 13c OMS Upgrade Fails At Repository Configuration With Error "ORA-02298: cannot validate (SYSMAN.EM_TENANT_TYPE_PRIV_FK) - parent keys not found"
Last updated on JUNE 15, 2016
Applies to:Enterprise Manager Base Platform - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
12c-13c OMS upgrade fails at repository configuration with following error in <13c_MIDDLEWARE_HOME>\sysman\log\schemamanager\m_<timestamp>\m_<timestamp>.EBRIFY\em_repos_modify.log:
ORA-02298: cannot validate (SYSMAN.EM_TENANT_TYPE_PRIV_FK) - parent keys not found
Statement:ALTER TABLE EM_TENANT_TYPE_PRIVILEGES_E
ADD CONSTRAINT EM_TENANT_TYPE_PRIV_FK
FOREIGN KEY ( priv_name ) REFERENCES MGMT_PRIVS_E ( priv_name)
ON DELETE CASCADE
INFO: oracle.sysman.top.oms:The plug-in Repository Upgrade has failed its perform method
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