My Oracle Support Banner

Applying the DSTv44 update for the Oracle Database (Doc ID 3071901.1)

Last updated on FEBRUARY 17, 2025

Applies to:

Oracle Database Cloud Exadata Service
Oracle Cloud Infrastructure - Exadata Cloud Service
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine)
Gen 2 Exadata Cloud at Customer
Oracle Database - Standard Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Purpose

RDBMS DSTv44 Patch 37537949 32327201 32327201 32327201 32327201 32327201 32327201 3232720132327201 32327201 32327201 32327201 32327201 32327201 32327201 32327201 32327201 32327201 32327
and OJVM DSTv44 Patch 37537990 are proactively done for all supported versions and platforms.

Scope

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

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

Please note that SYSDATE is NOT affected by "Oracle DST patches" seen as 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 the wrong time ( SYSDATE and SYSTIMESTAMP) after DST change, server reboot, database restart, or installation when connecting to a database on a 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 11gR2 and higher
 1.b) For Oracle RDBMS 10g and 11gR1:
 2) Oracle RDBMS 12c : Applying the RDBMS DSTv44 patch 37537949 on Oracle RDBMS 12c ( 12.1.0.1 , 12.1.0.2 , 12.2.0.1 , 18.x, 19.x and 21.x )
 2.a) Applying the RDBMS DSTv44 patch 37537949 on the server-side in Oracle RDBMS 12c and above
 2.b) Applying the RDBMS DSTv44 patch 37537949 on the client side in Oracle RDBMS 12c.
 3) Oracle RDBMS 11gR2 : Applying the RDBMS DSTv44 patch 37537949 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 DSTv44 patch 37537949 on the server side in Oracle RDBMS 11gR2
 3.b) Applying the RDBMS DSTv44 patch 37537949 on the client-side in Oracle RDBMS 11gR2.
 4) 10g and 11.1 only:
 5) The OJVM DSTv44 patch 37537990.
  6) Other Oracle products:
 6.a) Enterprise Manager (Grid Control, OMS, Repository and Agents )
 6.b) Grid Infrastructure home.
 6.c) Oracle Applications
 6.d) Java in the Database home
 6.e) Oracle solaris
 7. Steps to upgrade:
References

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