Actions For DST Updates When Upgrading To Or Applying The 220.127.116.11 Patchset
(Doc ID 1579838.1)
Last updated on DECEMBER 30, 2019
Oracle Database - Standard Edition - Version 18.104.22.168 to 22.214.171.124 [Release 8.1.7 to 11.2] Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [Release 8.1.7 to 11.2] Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Cloud Machine - Version N/A and later Oracle Database Exadata Express Cloud Service - Version N/A and later Information in this document applies to any platform.
To provide a step by step flow to determine if there are DST version implications when upgrading to 184.108.40.206 or applying the 220.127.116.11 patchset on a 18.104.22.168 , 22.214.171.124 or 126.96.36.199 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.
These steps should be followed before * applying 188.8.131.52 on an 184.108.40.206 , 220.127.116.11 or 18.104.22.168 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 22.214.171.124 release.
The goal is to see what actions are needed on DST information before or after upgrading to 126.96.36.199 Used abbreviations:
TZ: TimeZone TSTZ: TimeStamp with Time Zone TSLTZ: TimeStamp with Local Time Zone OJVM: Oracle Java Virtual Machine
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!