Skip to Content
Author's profile photo Former Member

Upgrading timezone_file version manually during Oracle 12c upgrade

Some of us might have faced a situation to upgrade timezone_file version manually during Oracle 12c upgrade. Here are the steps to follow in Windows.

When you upgrade Oracle to 12102, you will have have an option in DBUA to upgrade the timezone data.


If you don’t check it, then, when you run “post_upgrade_checks.sql”, it will give you the below warning message.


Remember that there will be no “upgrade_TSTZ.sql” script to upgrade the timezone data in Oracle 12102 under folder <ORACLE_HOME>\sap\ora-upgrade\post_upgrade”. We have this script only in 11g.

So the only option is to upgrade it manually.


  • Confirm the current version


Check the latest version of the timezone_file in location “<ORACLE_HOME>\oracore\zoneinfo”, the file format will be “timezlrg_18.dat” (12c release time zone version)

  • Shutdown your database and startup in upgrade mode


  • execute SQL command “SQL>EXEC DBMS_DST.BEGIN_UPGRADE (18);


  • Shutdown and startup your database again and check for the new version is updated.


Then run “post_upgrade_checks.sql” script again and the warning will disappear now.



Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Fidel Vales
      Fidel Vales


      if ALL steps from the SAP note 1915315 - Database Upgrade Scripts for are done, nothing of what you mention is necessary.

      in the note clearly is stated (point 4a of DBUA dialog):

      You should select the following options

      • Recompile ...
      • Upgrade timezone data ...

      therefore, if you run into the problem is because you did not follow the detailed instructions delivered by SAP.  It would be better that you advice to follow the mentioned note (which is for UNIX and WINDOWS) to avoid problems