My Oracle Support Banner

Upgrade Schema to Agile 9.3.6 RUP18 Fails with Error: 'Failed to upgrade schema. Refer /log/oracle_93615_0.log for more details' in Console and ORA-00942 at ALTER TABLE CAD_PUBLISH_WORKSPACE in oracle_93615_0.log (Doc ID 2861366.1)

Last updated on JANUARY 24, 2024

Applies to:

Oracle Agile PLM Framework - Version 9.3.6.0 and later
Information in this document applies to any platform.

Symptoms

Updating Agile database schema from one RUP to another (i.e. Upgrade from Agile 9.3.6 RUP10 to RUP18) fails with below error in the console and UpgradeSchema_summary.log

Error

 

Changes

Imported source database schema on the target instance, and then ran Upgrade Schema utility included in RUP

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.