Skip to Content

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.

/wp-content/uploads/2016/09/3_1031941.png

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

/wp-content/uploads/2016/09/1_1031939.png

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.

Steps:

  • Confirm the current version

/wp-content/uploads/2016/09/2_1031940.png

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

     /wp-content/uploads/2016/09/4_1031969.png

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

     /wp-content/uploads/2016/09/5_1031970.png

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

       /wp-content/uploads/2016/09/6_1031971.png

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

Regards,

Ganesan

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Fidel Vales

    Hi,

    if ALL steps from the SAP note 1915315 – Database Upgrade Scripts for 12.1.0.2 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

    (0) 

Leave a Reply