My Oracle Support Banner

Applying the DSTv34 update for the Oracle Database (Doc ID 2602555.1)

Last updated on OCTOBER 30, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 19.3.0.0.0 [Release 11.2 to 18]
Oracle Database - Standard Edition - Version 11.2.0.1 to 19.3.0.0.0 [Release 11.2 to 18]
Information in this document applies to any platform.

Purpose

 



RDBMS DSTv34 Patch 29997937 29997937 29997937 29997937 29997937 29997937 2999793729997937 29997937 29997937 29997937 29997937 29997937 29997937 29997937 29997937 29997937 29997937 29997937 and OJVM DSTv34 Patch  are proactively done for all supported versions and platforms

 

Scope

This note will give an overview on what checks to perform before applying the DSTv34 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 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 12c and 11gR2
 1.b) For Oracle RDBMS 10g and 11gR1:
 2) Oracle RDBMS 12c : Applying the RDBMS DSTv34 patch 29997937 on Oracle RDBMS 12c ( 12.1.0.1 , 12.1.0.2 and 12.2.0.1 and 18.1) .
 2.a) Applying the RDBMS DSTv34 patch 29997937 on the server side in Oracle RDBMS 12c.
 2.b) Applying the RDBMS DSTv34 patch 29997937 on the client side in Oracle RDBMS 12c.
 3) Oracle RDBMS 11gR2 : Applying the RDBMS DSTv34 patch 29997937 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 DSTv34 patch 29997937 on the server side in Oracle RDBMS 11gR2
 3.b) Applying the RDBMS DSTv34 patch 29997937 on the client side in Oracle RDBMS 11gR2.
 4) 10g and 11.1 only: 
 5) The OJVM DSTv34 patch 29997959 .
 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
References

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