My Oracle Support Banner

12.2 : Post-Upgrade Fixup(postupgrade_fixups.sql) fails with “upg_by_std_upgrd Failed Manual fixup recommended.” (Doc ID 2380677.1)

Last updated on JANUARY 08, 2020

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.


 During Upgrade from to following message is seen in Pre-Upgrade Log-

Run <preupgradeLogDirPath>/postupgrade_fixups.sql to complete all of the AFTER UPGRADE action items below marked with ‘(AUTOFIXUP)’.

+ Check the Oracle documentation for the identified components for their specific upgrade procedure.
The database upgrade script will not upgrade the following Oracle components: OLAP Catalog,OWB
The Oracle database upgrade script upgrades most, but not all Oracle Database components that may be installed. Some components that are not
upgraded may have their own upgrade scripts, or they may be deprecated or obsolete.

 Post Upgrade,When postupgrade_fixups.sql is executed the following message is seen :

Auto-Generated by: Oracle Preupgrade Script
Version: Build: 12
Generated on: 2018-03-08 13:47:06

For Source Database: IRSTEST
Source Database Version:
For Upgrade to Version:

Check Name Status Further DBA Action
———- —— ——————
old_time_zones_exist Passed None
post_dictionary Passed None
fixed_objects Passed None
upg_by_std_upgrd Failed Manual fixup recommended. <=======




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

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