My Oracle Support Banner

Applying the DSTv23 update for the Oracle Database (Doc ID 1907093.1)

Last updated on JANUARY 06, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.5 to 12.1.0.2 [Release 10.1 to 12.1]
Oracle Database - Standard Edition - Version 10.1.0.5 to 12.1.0.2 [Release 10.1 to 12.1]
Information in this document applies to any platform.

Purpose

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample or bulit-in schema(s), Public Documentation delivered with an Oracle database product or other training material.  Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.
Proactive backports of the RDBMS DSTv23 <patch 19396455> are done to
* 12.1.0.2 for the following platforms: Linux X86-64 , Oracle Solaris on Sparc (64-BIT)   . 
* 12.1.0.1, 11.2.0.4, 11.2.0.3 and 11.1.0.7 for the following platforms: Linux X86, Linux X86-64 , Microsoft Windows X86 (32-BIT) , Microsoft Windows X86-64 (64-BIT) , Oracle Solaris on Sparc (64-BIT) , Oracle Solaris on Intel X86-64 (64-BIT), IBM AIX on Power Systems (64-BIT) , HP-UX Itanium (64-BIT), HP-UX PA-RISC (64-BIT) . 
* 10.2.0.5 for HP OpenVMS on Itanium

Please log a SR if you need a backport to a platform or current version not mentioned.
There are no "PSU DST patches" , for example an Oracle DST patch for 11.2.0.4 can be applied using Opatch on *any* 11.2.0.4 psu (same goes for any other Oracle RDBMS version)

Note that backports to versions who are NOT in Premier Support are possible / available for download only for customers with a valid Extended Support .
Exceptions for other version/platform combination are only possible for customers with an existing Extended Support contract for the specific version/platform combination or platforms with Extended Support Fee Waiver Period.
Please log a SR if you need a backport to such an platform / version (if you need several log 1 sr clearly stating which version/platforms you have Extended Support contract for and need ).
See <Note 412160.1> , section "G) For what versions are DST patches provided / there is no DST version X for my Oracle RDBMS version?"
Please consult your Sales representative to enroll in an Extended Support contract if required.
If you log a SR requesting a backport or the password for versions in Extended Support and there is no Extended Support contract in place the patch cannot be provided.

Proactive backports of the OJVM DSTv23 <patch 19397646> are done for 12.1.0.2, 12.1.0.1 , 11.2.0.4 and 11.2.0.3.  Other supported versions can be requested .
The OJVM DST patch is platform generic.

A problem has been found with the 12.1.0.1 RDBMS DSTv23 <patch 19396455> for Linux X86, Linux X86-64 , Microsoft Windows X86 (32-BIT) , Microsoft Windows X86-64 (64-BIT) , Oracle Solaris on Intel X86-64 (64-BIT).
When applied sqlplus will coredump or simply exit. The patches where corrected and re-uploaded on 22 September 2014.
Please use the current (22 September 2014 released) patches for 12.1.0.1 for those platforms.
The 12.1.0.1 RDBMS DSTv23 <patch 19396455> for Oracle Solaris on Sparc (64-BIT) IBM AIX on Power Systems (64-BIT) , HP-UX Itanium (64-BIT), HP-UX PA-RISC (64-BIT) had no problem

The RDBMS DSTv23 update includes the timezone information from the IANA ( http://www.iana.org/time-zones ) data tzdata2014f.tar and contains all previous Oracle RDBMS DST updates.
The OJVM DSTv23 update includes the timezone information from the IANA (http://www.iana.org/time-zones ) data tzdata2014f.tar and contains all previous Oracle OJVM DST updates.

This is archived content. The note covers the "DSTv23" update, newer DST updates are available.
Please see <Note 412160.1> Updated Time Zones in Oracle Time Zone File patches for information on the newer DST patches.


An complete overview of timezone updates is found in <Note 412160.1> Updated DST transitions and new Time Zones in Oracle Time Zone File patches.
The biggest update in DSTv23 is for Russia,  <note 1907147.1> The Russian Government re-introduces DST in 2014 - Impact on Oracle RDBMS will help you to check if there is an actual need to apply DSTv23 to your system

Compared to DSTv22 this is the list of updated timezones in DSTv23 for non historical dates ( meaning update to the timezone after 1970):

 Africa/Cairo, Africa/Casablanca, Africa/El_Aaiun, Asia/Taipei, Asia/Yekaterinburg, Asia/Omsk, Asia/Novosibirsk , Asia/Krasnoyarsk, Asia/Irkutsk,  Asia/Yakutsk, Asia/Vladivostok, Asia/Magadan, Asia/Sakhalin, Europe/Kaliningrad, Europe/Moscow, Europe/Simferopol, Europe/Volgograd, Egypt, ROC, W-SU.

Scope

This note will give an overview on what checks to perform before applying the DSTv23 update.

Please note that SYSDATE is NOT affected by "Oracle DST patches" seen SYSDATE is purely depending on the OS to get the time.
So even an "unpatched database" will return a correct SYSDATE if the server (OS) time is correct.
For "sysdate" you do not need any DST patch  <note 1627439.1> How to diagnose wrong time ( SYSDATE and SYSTIMESTAMP) after DST change , server reboot , database restart or installation when connecting to a database on an Unix server
For more information about Timestamp with (local) Time Zone please check <Note 340512.1> Timestamps & time zones - Frequently Asked Questions

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 1) What is my current installed RDBMS DST version?
 1.a) for Oracle RDBMS 12gR1 and 11gR2
 1.b) For Oracle RDBMS 10g and 11gR1:
 2) Oracle RDBMS 12cR1 : Applying the RDBMS DSTv23 patch 19396455 on Oracle RDBMS 12cR1 ( 12.1.0.1 and 12.1.0.2) .
 2.a) Applying the RDBMS DSTv23 patch 19396455 on the server side in Oracle RDBMS 12cR1.
 2.b) Applying the RDBMS DSTv23 patch 19396455 on the client side in Oracle RDBMS 12cR1.
 3) Oracle RDBMS 11gR2 : Applying the RDBMS DSTv23 patch 19396455 on Oracle RDBMS 11gR2 ( 11.2.0.4 , 11.2.0.3 , 11.2.0.2 or 11.2.0.1)
 3.a) Applying the RDBMS DSTv23 patch 19396455 on the server side in Oracle RDBMS 11gR2
 3.b) Applying the RDBMS DSTv23 patch 19396455 on the client side in Oracle RDBMS 11gR2.
 4) 10g and 11.1 only:  What to check before applying the RDBMS DSTv23 patch 19396455 .
 5) 10g and 11.1 only: You have affected TSTZ data stored (sys_tzuv2_temptab returns rows).
 6) 10g and 11.1 only: Applying the RDBMS DSTv23 patch 19396455 .
 6a) 10g and 11.1 only: Supported versions and platforms.
 6b) 10g and 11.1 only: RDBMS DSTv23 patch 19396455 needs Patch 7695070 installed using Opatch.
 6c) 10g and 11.1 only: Applying the RDBMS DSTv23 patch 19396455 on the server side.
 6d) 10g and 11.1 only: After the server apply of RDBMS DSTv23 patch 19396455 and restart of the database:
 6e) 10g and 11.1 only: Applying the RDBMS DSTv23 patch 19396455 on clients
 7) The OJVM DSTv23 patch 19397646 .
 
8) Other Oracle products:
 8.1) Enterprise Manager (Grid Control, OMS, Repository and Agents )
 8.2) Grid Infrastructure home.
 8.3) Oracle Applications
 8.4) Java in the Database home
 8.5) Oracle solaris
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.