Actions For DST Updates When Upgrading To Or Applying The 11.2.0.4 Patchset (Doc ID 1579838.1)

Last updated on JUNE 13, 2023

Applies to:

Purpose

To provide a step by step flow to determine if there are DST version implications when upgrading to 11.2.0.4 or applying the 11.2.0.4 patchset on a 11.2.0.1 , 11.2.0.2 or 11.2.0.3 database home.

Oracle has 2 datatypes that may have stored data which would be affected by an update of the RDBMS DST definitions. These datatypes are TIMESTAMP WITH LOCAL TIME ZONE (TSLTZ) and TIMESTAMP WITH TIME ZONE (TSTZ). Note that there is other functionality which uses these DST definitions, but this does not affect the stored information directly.
Note that "sysdate" and the "date" datatype do not use the DST definitions provided by Oracle, they rely pure on the Operating System.

The Oracle Java Virtual Machine (OJVM) also has DST information, but has no internal datatypes which store that information, hence this can be updated by simply applying the latest/newest OJVM DST patch.available.

Scope

These steps should be followed before
* applying 11.2.0.4 on an 11.2.0.3 , 11.2.0.2 or 11.2.0.1 database home.
* upgrading from 11.1.0.x , 10.2.0.x, 10.1.0.x , 9.2.0.x or 9.0.1.x version directly to 11.2.0.4 release.

The goal is to see what actions are needed on DST information before or after upgrading to 11.2.0.4
Used abbreviations:

TZ: TimeZone
TSTZ: TimeStamp with Time Zone
TSLTZ: TimeStamp with Local Time Zone
OJVM: Oracle Java Virtual Machine

Details

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