EM 13c: Enterprise Manager 13.2 Cloud Control Upgrade Fails at Repository Configuration with Error : ORA-01555: snapshot too old: rollback segment number with name "" too small

(Doc ID 2308947.1)

Last updated on SEPTEMBER 26, 2017

Applies to:

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

Symptoms

Enterprise Manager (EM) 13.2 Cloud Control
Upgrade from EM 12.1.0.5.0

EM OMS upgrade from 12.1.0.5 to 13.2 fails at Repository Configuration with is logged error:

From <EM 13.2 OMS Oracle Home>/cfgtoollogs/cfgfw/CfmLogger_<DATE_TIME>.log

Upgrade from OMS 12.1.0.5.0 to 13.2.0.0.0 failed with below error :
RCU-6130:Action failed - RCU-6134:Error while trying to execute JDBC action.
Repository Creation Utility: Create - Completion Summary
Database details:
Connect Descriptor : (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=prod_p.aah.local)(PORT=1526))(CONNECT_DATA=(SID=prdm)))
Connected As : SYS
RCU Logfile : /opt/oracle/Middleware_13C/sysman/log/schemamanager/m_091417_0224_PM/m_091417_0224_PM.EBRIFY/rcu.log
RCU Checkpoint Object : /opt/oracle/Middleware_13C/sysman/log/schemamanager//RCUCheckpointObj
Component schemas created:
Component Status Logfile
EM Repository EBRification Failed /opt/oracle/Middleware_13C/sysman/log/schemamanager/m_091417_0224_PM/m_091417_0224_PM.EBRIFY/em_repos_ebrify.log
java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number with name "" too small

 

From <EM 13.2 OMS Oracle Home>/sysman/log/schemamanager/latest/rcu.log:

Fri Sep 15 01:06:09.704 CDT 2017 ERROR rcu: oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine::executeNextSQLStatement: Error encountered executing SQL statement FileName: '/opt/oracle/Middleware_13C/sysman/admin/emdrep/sql/core/latest/ebr/schema_udt_spefication.sql' LineNumber: '470' Script log file: /opt/oracle/Middleware_13C/sysman/log/schemamanager/m_091417_0224_PM/m_091417_0224_PM.EBRIFY/em_repos_ebrify.log
Fri Sep 15 01:06:09.704 CDT 2017 TRACE rcu: oracle.sysman.assistants.rcu.backend.action.AbstractSQLAction::removeLocalErrors: Removing Local Fatal and Ignorable Errors
Fri Sep 15 01:06:09.704 CDT 2017 TRACE rcu: oracle.sysman.assistants.rcu.backend.action.AbstractSQLAction::removeLocalErrors: Removing LocalFatal Errors
Fri Sep 15 01:06:09.704 CDT 2017 TRACE rcu: oracle.sysman.assistants.rcu.backend.action.AbstractSQLAction::removeLocalErrors: Removing LocalIgnorable Errors
Fri Sep 15 01:06:09.704 CDT 2017 INCIDENT_ERROR rcu: oracle.sysman.assistants.rcu.backend.action.JDBCAction::cleanAndLog: RCU-6134:Error while trying to execute JDBC action. - EM_REPOS_EBRIFY
oracle.sysman.assistants.common.dbutil.SQLFatalErrorException: java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number with name "" too small
ORA-06512: at line 220

 

 

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