My Oracle Support Banner

Applying the DSTv20 update for the Oracle Database (Doc ID 1552819.1)

Last updated on AUGUST 24, 2021

Applies to:

Oracle Database - Standard Edition - Version 10.1.0.5 to 12.1.0.1 [Release 10.1 to 12.1]
Oracle Database - Enterprise Edition - Version 10.1.0.5 to 12.1.0.1 [Release 10.1 to 12.1]
Information in this document applies to any platform.
Bug 16799735 - DST 20: HALF YEARLY DST PATCHES, JUN 2013
Bug 16799766 - DST CHANGES FOR DSTV20 (TZDATA2013C) - NEED OJVM FIX

Purpose

Proactive backports of the RDBMS DSTv20 <patch 16799735> is done to 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), HP-UX Itanium (64-BIT), HP-UX PA-RISC (64-BIT), IBM AIX on Power Systems (64-BIT) for 11.2.0.3, 11.2.0.2 , 11.1.0.7, 10.2.0.5 and also for 10.2.0.5 on HP OpenVMs on Itanium.

Please log a SR if you need a backport to a platform or current version not mentioned.
Note that backports to 11.1.0.7 and 10.2.0.5 are available for download only for customers with a valid Extended Support or for platforms with a free Extended Support extension. See <Note 412160.1> , section "G) For what versions are DST patches provided / there is no DST version X for my Oracle RDBMS version?"

Proactive backports of the OJVM DSTv20 <patch 16799766> is done for 11.2.0.3 , 11.1.0.7,  10.2.0.5. The OJVM DST patch is platform generic.

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

This is archived content. The note covers the "DSTv20" 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.

All DST patches are always cumulative, which means they contain also ALL the previous DST changes / corrections.
This means that:

In 11gR2 and higher the time to update to a new RDBMS DST version is depending 99% on the dataset size, not the target DST version.
For example if the current RDBMS DST version 14 then going from DSTv14 to DSTv22 will take the roughly the same amount of time as going from DSTv14 to DSTv20 .

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

  Africa/Casablanca, America/Port-au-Prince, America/Santiago, America/Asuncion, Antarctica/Palmer, Asia/Gaza, Asia/Hebron, Pacific/Easter, Chile/Continental, Chile/EasterIsland

Scope

This note will give an overview on what checks to perform before applying the DSTv20 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 227334.1> Dates & Calendars - Frequently Asked Questions
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 DST version?
 2)10g and 11.1 only:  What to check before applying the RDBMS DSTv20 patch 16799735 .
 3) 10g and 11.1 only: You have affected TSTZ data stored (sys_tzuv2_temptab returns rows).
 4) 10g and 11.1 only: Applying the RDBMS DSTv20 patch 16799735 .
 4a) 10g and 11.1 only: Supported versions and platforms.
 4b) 10g and 11.1 only: RDBMS DSTv20 patch 16799735 needs Patch 7695070 installed using Opatch.
 4c) 10g and 11.1 only: Applying the RDBMS DSTv20 patch 16799735 on the server side.
 4d) 10g and 11.1 only: After the server apply of RDBMS DSTv20 patch 16799735 and restart of the database:
 4e) 10g and 11.1 only: Applying the RDBMS DSTv20 patch 16799735 on clients
 5) Oracle RDBMS 11gR2 : Applying the RDBMS DSTv20 patch 18759211 on Oracle RDBMS 11gR2 ( 11.2.0.4 , 11.2.0.3 , 11.2.0.2 or 11.2.0.1)
 5.a) 11gR2 : Applying the RDBMS DSTv20 patch 16799735 on the server side on Oracle RDBMS 11gR2.
 5.b) 11gR2 : Applying the RDBMS DSTv20 patch 16799735 on the client side on Oracle RDBMS 11gR2.
 6) Oracle RDBMS 12cR1 : Applying the RDBMS DSTv21 patch 17432124 on Oracle RDBMS 12cR1 ( 12.1.0.1 and 12.1.0.2).
 6.a) 12cR1 : Applying the RDBMS DSTv20 patch 16799735 on the server side on Oracle RDBMS 12cR1.
 6.b) 12cR1 : Applying the RDBMS DSTv20 patch 16799735 on the client side on Oracle RDBMS 12cR1.
 7) The OJVM DSTv20 patch 16799766.
References

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