12.2 :DBUA errors out with DST version in source is newer than version shipped with 12.2.0.1.0

(Doc ID 2347761.1)

Last updated on FEBRUARY 12, 2018

Applies to:

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

Symptoms

DBUA gives error during 11.2.0.4 to 12.2 upgrade ,even though the  12.2.0.1 Oracle Home is patched with Timezone version 28.

Prerequisite Check Details

Cause : The database is using a time zone file version that is newer than the version shipped with the 12.2.0.1.0 release.
Action : Patch the new 12.2.0.1.0 $ORACLE_HOME/oracore/zoneinfo/ with the version 28 time zone data file from the 11.2.0.4.0 $ORACLE_HOME/oracore/zoneinfo/.

 

 

Changes

 DBUA ugrade to 12.2.0.1.0

12.2.0.1 Oracle Home is already patched with Timezone version 28.

echo $ORACLE_HOME

/oracle/app/oracle/product/12.2.0.1/dbhome_1

cd $ORACLE_HOME/oracore/zoneinfo

check readme.txt contents it shows version 28

Current Structure version: 3

Current Content Version :28

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