Updating the RDBMS DST version in 12c Release 1 (12.1.0.1 ) and above using DBMS_DST (Doc ID 1509653.1)

Last updated on JULY 19, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.2.0.1 [Release 12.1 to 12.2]
Oracle Teleservice - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Database Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database - Standard Edition - Version 12.1.0.1 to 12.2.0.1 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Purpose

If the only goal is to update the RDBMS DST version to the default RDBMS DST version included in the 12.1.0.x version after an Oracle RDBMS version upgrade to 12.1.0.x
then simply run the scripts found in <note 1585343.1> Scripts to automatically update the RDBMS DST (timezone) version in an 11gR2 or 12cR1 database.
Those scripts do all the steps in this note.

This document can be used only till release 12.2.0.1. For the subsequent releases, the timezone upgrade scripts are included in the target ORACLE_HOME under rdbms/admin directory. Refer to Database Globalization Support Guide in "4.7 Upgrading the Time Zone File and Timestamp with Time Zone Data" Section.

This note provides an overview of

what is changed related to RDBMS DST updates in 12cR1
how to perform a manual RDBMS DST version update in Oracle RDBMS 12cR1 (= the steps used in the scripts of <note 1585343.1>).

This note does not cover OJVM DST updates for the simple reason that OJVM DST updates do not need any action on stored data. They can be simply applied. See the readme of the OJVM patches for installation instructions.
The RDBMS and OJVM DST versions are NOT technically related so they do not NEED to be the same.