Applying the DSTv43 update for the Oracle Database (Doc ID 3002390.1)

Last updated on JULY 20, 2024

Applies to:

Purpose

RDBMS DSTv43 Patch 36260493 32327201 32327201 32327201 32327201 32327201 32327201 3232720132327201 32327201 32327201 32327201 32327201 32327201 32327201 32327201 32327201 32327201 32327
and OJVM DSTv43 Patch 36260537 are proactively done for all supported versions and platforms.

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 customers with a valid Extended Support can download the backports to versions that are NOT in Premier Support.
Exceptions for another version/platform combinations are only possible for customers with an existing Extended Support contract for the specific version/platform combination or platforms with an Extended Support Fee Waiver Period.

Please log a SR if you need a backport to such a platform/version (if you need several, log 1 SR clearly stating which version/platforms you have an 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 for 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.

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

A complete overview of timezone updates is found in Note 412160.1 Primary Note DST FAQ : Updated DST Transitions and New Time Zones in Oracle RDBMS and OJVM Time Zone File Patches .

The changes included in the DSTv43 patch (and not included in DSTv42) are listed below

This is a combination of [tz-announce] 2024a release & [tz-announce] 2023d release.

2024A Briefly:
     Kazakhstan unifies on UTC+5 beginning 2024-03-01.
     Palestine springs forward a week later after Ramadan.
     zic no longer pretends to support indefinite-past DST.
     localtime no longer mishandles Ciudad Juárez in 2422.

   Changes to future timestamps:
    Kazakhstan unifies on UTC+5.  This affects Asia/Almaty and Asia/Qostanay which together represent the eastern portion of the country that will transition from UTC+6 on 2024-03-01 at 00:00 to join the western portion.

https://mm.icann.org/pipermail/tz-announce/2024-February/000081.html

2023D Briefly:
     Ittoqqortoormiit, Greenland changes time zones on 2024-03-31.
     Vostok, Antarctica changed time zones on 2023-12-18.
     Casey, Antarctica changed time zones five times since 2020.
     Code and data fixes for Palestine timestamps starting in 2072.
     A new data file zonenow.tab for timestamps starting now.

   Changes to future timestamps:
    Ittoqqortoormiit, Greenland(America/Scoresbysund) joins most of the rest of Greenland's timekeeping practice on 2024-03-31, by changing its time zone from -01/+00 to -02/-01 at the same moment as the spring-forward transition.  Its clocks will therefore not
     spring forward as previously scheduled.  The time zone change reverts to its common practice before 1981.

https://mm.icann.org/pipermail/tz-announce/2023-December/000080.html

Scope

This note will give an overview of what checks needs to be performed before applying the DSTv43 update.

Note that all DST patches are always cumulative, which means they contain also ALL the previous DST changes/corrections.

Details

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