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 APRIL 02, 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

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