12.2 : Post-Upgrade Fixup(postupgrade_fixups.sql) fails with “upg_by_std_upgrd Failed Manual fixup recommended.”
Last updated on APRIL 02, 2018
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
During Upgrade from 18.104.22.168 to 22.214.171.124.The 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: 126.96.36.199.0 Build: 12
Generated on: 2018-03-08 13:47:06
For Source Database: IRSTEST
Source Database Version: 188.8.131.52.0
For Upgrade to Version: 184.108.40.206.0
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. <=======
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