12.1:Executing postupgrade_fixups.sql shows "OLDER TIMEZONE IN USE" .

(Doc ID 2092618.1)

Last updated on OCTOBER 17, 2017

Applies to:

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


 After Upgrading database to 12.1 , warning occurred  as following while executing postupgrade_fixups.sql :


Check Summary: Check for use of older timezone data file
Fix Summary: Update the timezone using the DBMS_DST package after upgrade is complete.
Fixup Returned Information:
INFORMATION: --> Older Timezone in use

Database is using a time zone file older than version 18.
After the upgrade, it is recommended that DBMS_DST package
be used to upgrade the database time zone version
to the latest version which comes with the new release.
Please refer to My Oracle Support note number 977512.1 for 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 hundreds of Community platforms