Scripts to update the RDBMS DST (timezone) version in an 11gR2 or 12c database . (Doc ID 1585343.1)

Last updated on NOVEMBER 12, 2024

Applies to:

Oracle Database - Standard Edition - Version 11.2.0.1 to 12.2.0.1 [Release 11.2 to 12.2]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Goal

This document can be used only till release 12.2.0.1. For the subsequent releases (18c, 19c), the timezone upgrade scripts are included in the target ORACLE_HOME under rdbms/admin directory. utltz_countstats.sql, utltz_countstar.sql, utltz_upg_check.sql & utltz_upg_apply.sql.

Solution

	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

Upgrading Timezone file on Oracle Releases post 12cR2

1) (optional) run countstatsTSTZ.sql or countstarTSTZ.sql and removed uneeded TSTZ data to reduce the time needed to run upg_tzv_check.sql and upg_tzv_apply.sql

2) run upg_tzv_check.sql using SQL*PLUS from the database home

3) if upg_tzv_check.sql has run sucessfully , run upg_tzv_apply.sql using SQL*PLUS from the database home

4) Selects to see what is happening / what do if the scripts "hang":

5) Can the RDBMS DST version be updated without downtime? Or in a "rolling" fashion on RAC?

6) CDB /PDB (Multitenant) database and DST updates.

7) . New database creation using DBCA.

1) countstatsTSTZ.sql output

2) upg_tzv_check.sql output

3) upg_tzv_apply.sql output

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