12c EM: 'Internal Error has Occurred' While Trying To Access Enterprise Manager 12c Upgrade Console Link (Doc ID 1913255.1)

Last updated on AUGUST 03, 2014

Applies to:

Enterprise Manager Base Platform - Version 10.2.0.5 to 11.1.0.1 [Release 10.2 to 11.1]
Information in this document applies to any platform.

Symptoms

Requirement is to upgrade a 10.2.0.5 OMS to the 12.1.0.4 version.
After applying the pre-upgrade console patch : 17797433 to the 10.2.0.5 OMS, trying to access the pre-upgrade console link in the console UI fails with:

Internal Error has occured. Check the log file for details.

The <OMS_HOME>/sysman/log/emoms.trc file shows errors such as:

2014-07-29 21:14:02,196 [EMUI_21_14_01_/console/targets] WARN  pref.SubtabPref getFolders.710 - Unknown folder id: VirtualServers retrieved from repository
2014-07-29 21:14:22,669 [EMUI_21_14_22_/console/upgrade/upgradeConsole] ERROR preupg.UpgradeConsoleSQLHelper fetchMasterProperties.487 - Exception while running sql query select PROPERTY_VALUE from PRE_UPGC_MASTER_INFO where PROPERTY_NAME=?
java.sql.SQLException: ORA-00942: table or view does not exist

       at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:315)
       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:281)
       at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:638)
       at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedState
.........
2014-07-29 21:14:22,672 [EMUI_21_14_22_/console/upgrade/upgradeConsole] ERROR preupg.PreUpgConsoleController prepareData.458 - showParallelSystemgot exception
2014-07-29 21:14:22,674 [EMUI_21_14_22_/console/upgrade/upgradeConsole] ERROR preupg.UpgradeConsoleSQLHelper getUpgradeStrategy.323 - Exception while running update sql query select UPGRADE_STRATEGY from  PRE_UPGC_STRATEGY
java.sql.SQLException: ORA-00942: table or view does not exist

       at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:315)
       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:281)

 

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