OMS Upgrade to 13c fails in Repository Upgrade step with "ORA-01403: no data found" error in "caw_data_upgrade.sql" (Doc ID 2107483.1)

Last updated on AUGUST 25, 2017

Applies to:

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

Symptoms

 

OMS Upgrade from 12.1.0.5 to 13.1.1.0. Fails in 'Repository Upgrade' step, with below error

Error:


        Repository Create in progress.
        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=host1.local)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=SID1)))
        Connected As : SYS
        RCU Logfile : /occ/product/13.1.0.0/mw/sysman/log/schemamanager/m_020216_0706_PM/m_020216_0706_PM.RESUME_RETRY/rcu.log
        RCU Checkpoint Object : /occ/product/13.1.0.0/mw/sysman/log/schemamanager/RCUCheckpointObj
        Component schemas created:
        Component Status Logfile
        EM Repository Upgrade Configuration Failed /occ/product/13.1.0.0/mw/sysman/log/schemamanager/m_020216_0706_PM/m_020216_0706_PM.RESUME_RETRY/em_repos_modify.log

        Repository Creation Utility - Create : Operation Completed
        java.lang.Exception: The last RCUModel exit status code is not SUCCEEDED.
        at oracle.sysman.emdrep.schemamanager.SchemaAction.perform(SchemaAction.java:687)
        at oracle.sysman.emdrep.schemamanager.SchemaResumeAction.perform(SchemaResumeAction.java:108)
        at oracle.sysman.emdrep.schemamanager.EMRCURunner.run(EMRCURunner.java:118)

        perform - mode finished for action: configure

        You can see the log file: /occ/product/13.1.0.0/mw/cfgtoollogs/oui/configActions2016-02-02_07-06-33PM.log

   Error in OMS_HOME/cfgtoollogs/cfgfw/CfmLogger_<TIMESTAMP>.log

        Error encountered executing SQL statement FileName: '/occ/product/13.1.0.0/mw/plugins/oracle.sysman.db.oms.plugin_13.1.1.0.0/sql/db/13.1.0.1/caw/caw_data_upgrade.sql'   LineNumber: '127'

       END;
        ]
       java.sql.SQLException: ORA-01403: no data found
      ORA-06512: at line 36

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