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 AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

 During Upgrade from 11.2.0.4 to 12.2.0.1.The following message is seen in Pre-Upgrade Log-

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

INFORMATION ONLY
================
+ 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: 12.2.0.1.0 Build: 12
Generated on: 2018-03-08 13:47:06

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

Fixup
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. <=======

 

 

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!


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