Upgrading MDS schema using Patch Set Assistant (PSA) utility results in ORA-06512 error (Doc ID 1558858.1)

Last updated on APRIL 11, 2016

Applies to:

Oracle Business Process Management Suite - Version 11.1.1.5.0 to 11.1.1.7.0 [Release 11gR1]
Information in this document applies to any platform.

Symptoms

Unable to upgrade from 11.1.1.5 FP to 11.1.1.7.0 due to an exception while running the Patch Set Assistant (PSA) utility to update the schemas:

[2013-05-07T13:01:01.773-04:00] [Framework] [NOTIFICATION] [upgrade.Framework] Finished upgrading ORASDPM.ORASDPM_SCHEMA_PLUGIN with status: SUCCESS.
[2013-05-07T13:01:01.773-04:00] [Framework] [NOTIFICATION] [upgrade.Framework] Starting to upgrade MDS.MDS1.
[2013-05-07T13:01:01.787-04:00] [Framework] [NOTIFICATION] [upgrade.Framework] Database connect string: jdbc:oracle:thin:DEV115_MDS/******@localhost:1521/xe
[2013-05-07T13:01:01.788-04:00] [RCU] [NOTIFICATION] [upgrade.RCU.jdbcEngine] Connecting to database: user:DEV115_MDS, connectString:jdbc:oracle:thin:DEV115_MDS/*****@localhost:1521/xe
[2013-05-07T13:01:01.788-04:00] [RCU] [TRACE] [upgrade.RCU.jdbcEngine] Driver: oracle.jdbc.driver.OracleDriver
[2013-05-07T13:01:01.788-04:00] [RCU] [TRACE] [upgrade.RCU.jdbcEngine] jdbcUrl = jdbc:oracle:thin:DEV115_MDS/*****@localhost:1521/xe
[2013-05-07T13:01:01.829-04:00] [MDS] [NOTIFICATION] [upgrade.MDS.MDS1] upgradeScript=/home/atcdev/Oracle/Middleware/oracle_common/rcu/integration/mds/sql/upgmds.sql -v MDS_VARCHAR=NVARCHAR
[2013-05-07T13:01:01.829-04:00] [RCU] [NOTIFICATION] [upgrade.RCU.jdbcEngine] ParseNexecute Script: /home/atcdev/Oracle/Middleware/oracle_common/rcu/integration/mds/sql/upgmds.sql
[2013-05-07T13:02:22.306-04:00] [RCU] [ERROR] [upgrade.RCU.jdbcEngine] Error encountered executing SQL statement FileName: '/home/atcdev/Oracle/Middleware/oracle_common/rcu/integration/mds/sql/MDSINCB.plb' LineNumber: '313' Script log file: null
[2013-05-07T13:02:22.307-04:00] [MDS] [ERROR] [upgrade.MDS.MDS1] UPGAST-00221: unexpected error uprading schema
[2013-05-07T13:02:22.307-04:00] [MDS] [ERROR] [upgrade.MDS.MDS1] [[
oracle.sysman.assistants.common.dbutil.SQLFatalErrorException: DETAILED_TEXT oracle.sysman.assistants.common.dbutil.jdbc.DatabaseObjectCreationException$ErrorInfo@1cdc46bc

at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.parseNexecuteScript(JDBCEngine.java:1414)
at oracle.ias.update.plugin.UpgradePlugin.executeJDBCEngineScript(UpgradePlugin.java:982)
at oracle.ias.update.plugin.UpgradePlugin.executeJDBCEngineScript(UpgradePlugin.java:780)
at oracle.ias.update.plugin.UpgradePlugin.executeJDBCEngineScript(UpgradePlugin.java:839)
at oracle.ias.update.plugin.mds.MDSUpdatePlugin.upgradeMDS(MDSUpdatePlugin.java:195)
at oracle.ias.update.plugin.mds.MDSUpdatePlugin.upgrade(MDSUpdatePlugin.java:129)
at oracle.ias.update.plugin.Plugin.upgrade(Plugin.java:348)
at oracle.ias.update.plan.PlanStep.upgrade(PlanStep.java:295)
at oracle.ias.update.UpgradeDriver.doUpgrades(UpgradeDriver.java:475)
at oracle.ias.update.gui.UAUpgradeThread.run(UAUpgradeThread.java:42)

]]
[2013-05-07T13:02:22.312-04:00] [MDS] [ERROR] [UPGCMP-05501] [upgrade.MDS.MDS1] Oracle Metadata Services schema upgrade is invalid.
[2013-05-07T13:02:22.312-04:00] [MDS] [ERROR] [upgrade.MDS.MDS1] Cause: Specified Metadata Services schema was updated but is invalid.
[2013-05-07T13:02:22.312-04:00] [MDS] [ERROR] [upgrade.MDS.MDS1] Action: Restore the Metadata Services schema from a backup and retry. Check the error messages in Oracle Metadata service component log files. Correct the problem before running the Assistant again.
[2013-05-07T13:02:22.317-04:00] [Framework] [NOTIFICATION] [upgrade.Framework] Finished upgrading MDS.MDS1 with status: FAILURE.

 

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