Tuesday, March 18, 2025

How to upgrade timezone version file - TSTZ

   No comments
  • Introduction: In Oracle, the timezone_file refers to the time zone data file that Oracle Database uses to store and manage time zone information. This file contains rules for daylight saving time and standard time for various regions. This guide will walk you through to update the timezone_file step-by-step.

  • Time Zone Files Location:
    • o Oracle stores time zone files in the $ORACLE_HOME/oracore/zoneinfo/ directory.
    o The files are named as timezlrg_XX.dat (large time zone file) and timezone_XX.dat (small time zone file), where XX represents the version number.

  • Prerequisites:
    • o Downtime required at Database end for 45 mins.

  • Environment:
    • Hostname: test
    IP: 192.168.101.15
    ORACLE_SID : orcl

  • Now let's upgrade the timezone_file step by step:
1. First check the current timezone file and also the available timezone file to be upgraded: 

SQL> SELECT version FROM v$timezone_file;

   VERSION
----------
        32

SQL>
SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 ORCLPDB2                       READ WRITE NO
SQL>
SQL> alter session set container=ORCLPDB2;

Session altered.

SQL> SELECT version FROM v$timezone_file;

   VERSION
----------
        32

SQL>
SQL> exit

[oracle@test binaries]$ cd $ORACLE_HOME/oracore/zoneinfo/
[oracle@test zoneinfo]$ ls -lrth
total 49M
-rw-r--r--. 1 oracle oinstall  337K Dec 18  2012      timezone_13.dat
-rw-r--r--. 1 oracle oinstall  773K Dec 18  2012      timezlrg_14.dat
-rw-r--r--. 1 oracle oinstall  280K Dec 18  2012      timezone_4.dat
-rw-r--r--. 1 oracle oinstall  269K Dec 18  2012      timezone_2.dat
-rw-r--r--. 1 oracle oinstall  775K Jun 17  2014      timezlrg_10.dat
-rw-r--r--. 1 oracle oinstall  296K Dec  9  2015      timezone_8.dat
-rw-r--r--. 1 oracle oinstall  334K Dec  9  2015      timezone_17.dat
-rw-r--r--. 1 oracle oinstall  337K Dec  9  2015      timezone_14.dat
-rw-r--r--. 1 oracle oinstall  338K Dec  9  2015      timezone_11.dat
-rw-r--r--. 1 oracle oinstall  603K Dec  9  2015      timezlrg_8.dat
-rw-r--r--. 1 oracle oinstall  336K Jun 22  2016      timezone_22.dat
-rw-r--r--. 1 oracle oinstall  338K Jun 22  2016      timezone_10.dat
-rw-r--r--. 1 oracle oinstall  763K Jun 22  2016      timezlrg_25.dat
-rw-r--r--. 1 oracle oinstall  764K Jun 22  2016      timezlrg_18.dat
-rw-r--r--. 1 oracle oinstall  767K Jul 25  2016      timezlrg_27.dat
-rw-r--r--. 1 oracle oinstall  335K Jul 25  2016      timezone_27.dat
-rw-r--r--. 1 oracle oinstall  280K Aug 10  2016      timezone_3.dat
-rw-r--r--. 1 oracle oinstall  335K Aug 10  2016      timezone_26.dat
-rw-r--r--. 1 oracle oinstall  333K Aug 10  2016      timezone_25.dat
-rw-r--r--. 1 oracle oinstall  333K Aug 10  2016      timezone_24.dat
-rw-r--r--. 1 oracle oinstall  336K Aug 10  2016      timezone_23.dat
-rw-r--r--. 1 oracle oinstall  336K Aug 10  2016      timezone_21.dat
-rw-r--r--. 1 oracle oinstall  336K Aug 10  2016      timezone_20.dat
-rw-r--r--. 1 oracle oinstall  268K Aug 10  2016      timezone_1.dat
-rw-r--r--. 1 oracle oinstall  336K Aug 10  2016      timezone_19.dat
-rw-r--r--. 1 oracle oinstall  334K Aug 10  2016      timezone_18.dat
-rw-r--r--. 1 oracle oinstall  336K Aug 10  2016      timezone_16.dat
-rw-r--r--. 1 oracle oinstall  337K Aug 10  2016      timezone_15.dat
-rw-r--r--. 1 oracle oinstall  337K Aug 10  2016      timezone_12.dat
-rw-r--r--. 1 oracle oinstall  783K Aug 10  2016      timezlrg_9.dat
-rw-r--r--. 1 oracle oinstall  588K Aug 10  2016      timezlrg_7.dat
-rw-r--r--. 1 oracle oinstall  573K Aug 10  2016      timezlrg_6.dat
-rw-r--r--. 1 oracle oinstall  574K Aug 10  2016      timezlrg_5.dat
-rw-r--r--. 1 oracle oinstall  519K Aug 10  2016      timezlrg_4.dat
-rw-r--r--. 1 oracle oinstall  516K Aug 10  2016      timezlrg_3.dat
-rw-r--r--. 1 oracle oinstall  497K Aug 10  2016      timezlrg_2.dat
-rw-r--r--. 1 oracle oinstall  768K Aug 10  2016      timezlrg_26.dat
-rw-r--r--. 1 oracle oinstall  759K Aug 10  2016      timezlrg_24.dat
-rw-r--r--. 1 oracle oinstall  771K Aug 10  2016      timezlrg_23.dat
-rw-r--r--. 1 oracle oinstall  767K Aug 10  2016      timezlrg_22.dat
-rw-r--r--. 1 oracle oinstall  765K Aug 10  2016      timezlrg_21.dat
-rw-r--r--. 1 oracle oinstall  772K Aug 10  2016      timezlrg_20.dat
-rw-r--r--. 1 oracle oinstall  483K Aug 10  2016      timezlrg_1.dat
-rw-r--r--. 1 oracle oinstall  768K Aug 10  2016      timezlrg_19.dat
-rw-r--r--. 1 oracle oinstall  761K Aug 10  2016      timezlrg_17.dat
-rw-r--r--. 1 oracle oinstall  783K Aug 10  2016      timezlrg_16.dat
-rw-r--r--. 1 oracle oinstall  773K Aug 10  2016      timezlrg_15.dat
-rw-r--r--. 1 oracle oinstall  765K Aug 10  2016      timezlrg_13.dat
-rw-r--r--. 1 oracle oinstall  768K Aug 10  2016      timezlrg_12.dat
-rw-r--r--. 1 oracle oinstall  769K Aug 10  2016      timezlrg_11.dat
-rw-r--r--. 1 oracle oinstall  344K Aug 10  2016      timezone_9.dat
-rw-r--r--. 1 oracle oinstall  281K Aug 10  2016      timezone_7.dat
-rw-r--r--. 1 oracle oinstall  280K Aug 10  2016      timezone_6.dat
-rw-r--r--. 1 oracle oinstall  280K Aug 10  2016      timezone_5.dat
-rw-r--r--. 1 oracle oinstall  765K Sep 28  2016      timezlrg_28.dat
-rw-r--r--. 1 oracle oinstall  334K Sep 28  2016      timezone_28.dat
-rw-r--r--. 1 oracle oinstall  770K Dec  5  2016      timezlrg_29.dat
-rw-r--r--. 1 oracle oinstall  334K Dec  5  2016      timezone_29.dat
-rw-r--r--. 1 oracle oinstall  333K May  3  2017      timezone_30.dat
-rw-r--r--. 1 oracle oinstall  768K May  3  2017      timezlrg_30.dat
-rw-r--r--. 1 oracle oinstall  333K Nov  6  2017      timezone_31.dat
-rw-r--r--. 1 oracle oinstall  769K Nov  6  2017      timezlrg_31.dat
-rw-r--r--. 1 oracle oinstall   52K Jun 14  2018      timezdif.csv
-rw-r--r--. 1 oracle oinstall   59K Jun 14  2018      readme.txt
-rw-r--r--. 1 oracle oinstall  333K Jun 20  2018      timezone_32.dat
-rw-r--r--. 1 oracle oinstall  769K Jun 20  2018      timezlrg_32.dat
-rw-r--r--. 1 oracle oinstall  400K Jul 14  2024      timezone_43.dat
-rw-r--r--. 1 oracle oinstall  400K Jul 14  2024      timezone_42.dat
-rw-r--r--. 1 oracle oinstall  397K Jul 14  2024      timezone_41.dat
-rw-r--r--. 1 oracle oinstall  407K Jul 14  2024      timezone_40.dat
-rw-r--r--. 1 oracle oinstall  407K Jul 14  2024      timezone_39.dat
-rw-r--r--. 1 oracle oinstall  411K Jul 14  2024      timezone_38.dat
-rw-r--r--. 1 oracle oinstall  411K Jul 14  2024      timezone_37.dat
-rw-r--r--. 1 oracle oinstall  411K Jul 14  2024      timezone_36.dat
-rw-r--r--. 1 oracle oinstall  411K Jul 14  2024      timezone_35.dat
-rw-r--r--. 1 oracle oinstall  414K Jul 14  2024      timezone_34.dat
-rw-r--r--. 1 oracle oinstall  416K Jul 14  2024      timezone_33.dat
-rw-r--r--. 1 oracle oinstall  923K Jul 14  2024      timezlrg_43.dat
-rw-r--r--. 1 oracle oinstall  923K Jul 14  2024      timezlrg_42.dat
-rw-r--r--. 1 oracle oinstall  921K Jul 14  2024      timezlrg_41.dat
-rw-r--r--. 1 oracle oinstall  955K Jul 14  2024      timezlrg_40.dat
-rw-r--r--. 1 oracle oinstall  970K Jul 14  2024      timezlrg_39.dat
-rw-r--r--. 1 oracle oinstall 1009K Jul 14  2024      timezlrg_38.dat
-rw-r--r--. 1 oracle oinstall 1009K Jul 14  2024      timezlrg_37.dat
-rw-r--r--. 1 oracle oinstall 1019K Jul 14  2024      timezlrg_36.dat
-rw-r--r--. 1 oracle oinstall 1018K Jul 14  2024      timezlrg_35.dat
-rw-r--r--. 1 oracle oinstall 1021K Jul 14  2024      timezlrg_34.dat
-rw-r--r--. 1 oracle oinstall 1021K Jul 14  2024      imezlrg_33.dat
-rw-r--r--. 1 oracle oinstall   74K Jul 14  2024      readme_43.txt
-rw-r--r--. 1 oracle oinstall   74K Jul 14  2024      readme_42.txt
-rw-r--r--. 1 oracle oinstall   74K Jul 14  2024      readme_41.txt
-rw-r--r--. 1 oracle oinstall   74K Jul 14  2024      readme_40.txt
-rw-r--r--. 1 oracle oinstall   74K Jul 14  2024      readme_39.txt
-rw-r--r--. 1 oracle oinstall   74K Jul 14  2024      readme_38.txt
-rw-r--r--. 1 oracle oinstall   74K Jul 14  2024      readme_37.txt
-rw-r--r--. 1 oracle oinstall   74K Jul 14  2024      readme_36.txt
-rw-r--r--. 1 oracle oinstall   74K Jul 14  2024      readme_35.txt
-rw-r--r--. 1 oracle oinstall   74K Jul 14  2024      readme_34.txt
-rw-r--r--. 1 oracle oinstall   74K Jul 14  2024      readme_33.txt
drwxr-xr-x. 2 oracle oinstall  4.0K Oct 14 02:31      big
drwxr-xr-x. 2 oracle oinstall  4.0K Oct 14 02:31      little
[oracle@test zoneinfo]$
As per the above the current timezone file is 32. Also we have maximum available timezone file is 43, so that we can upgrade till timezone file 43.

2.Now run the utltz_* scripts present in $ORACLE_HOME/rdbms/admin/ to upgrade timezone file. We need to run the same for CDB & each PDBs:
At CDB:

[oracle@test admin]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Mar 6 04:10:47 2025
Version 19.24.0.0.0

Copyright (c) 1982, 2024, Oracle. All rights reserved.

Connected to:
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.24.0.0.0

SQL>
SQL> @$ORACLE_HOME/rdbms/admin/utltz_countstats.sql

Session altered.

.
Amount of TSTZ data using num_rows stats info in DBA_TABLES.
.

For SYS tables first ...
Note: empty tables are not listed.
Stat date - Owner.TableName.ColumnName - num_rows
17/04/2019 - SYS.AQ$_ALERT_QT_S.CREATION_TIME - 3
17/04/2019 - SYS.AQ$_ALERT_QT_S.DELETION_TIME - 3
17/04/2019 - SYS.AQ$_ALERT_QT_S.MODIFICATION_TIME - 3
17/04/2019 - SYS.AQ$_AQ$_MEM_MC_S.CREATION_TIME - 3
17/04/2019 - SYS.AQ$_AQ$_MEM_MC_S.DELETION_TIME - 3
17/04/2019 - SYS.AQ$_AQ$_MEM_MC_S.MODIFICATION_TIME - 3
17/04/2019 - SYS.AQ$_AQ_PROP_TABLE_S.CREATION_TIME - 1
17/04/2019 - SYS.AQ$_AQ_PROP_TABLE_S.DELETION_TIME - 1
17/04/2019 - SYS.AQ$_AQ_PROP_TABLE_S.MODIFICATION_TIME - 1
17/04/2019 - SYS.AQ$_ORA$PREPLUGIN_BACKUP_QTB_S.CREATION_TIME - 1
17/04/2019 - SYS.AQ$_ORA$PREPLUGIN_BACKUP_QTB_S.DELETION_TIME - 1
17/04/2019 - SYS.AQ$_ORA$PREPLUGIN_BACKUP_QTB_S.MODIFICATION_TIME - 1
17/04/2019 - SYS.AQ$_PDB_MON_EVENT_QTABLE$_S.CREATION_TIME - 1
17/04/2019 - SYS.AQ$_PDB_MON_EVENT_QTABLE$_S.DELETION_TIME - 1
17/04/2019 - SYS.AQ$_PDB_MON_EVENT_QTABLE$_S.MODIFICATION_TIME - 1
17/04/2019 - SYS.AQ$_SCHEDULER$_EVENT_QTAB_S.CREATION_TIME - 3
17/04/2019 - SYS.AQ$_SCHEDULER$_EVENT_QTAB_S.DELETION_TIME - 3
17/04/2019 - SYS.AQ$_SCHEDULER$_EVENT_QTAB_S.MODIFICATION_TIME - 3
17/04/2019 - SYS.AQ$_SCHEDULER$_REMDB_JOBQTAB_S.CREATION_TIME - 1
17/04/2019 - SYS.AQ$_SCHEDULER$_REMDB_JOBQTAB_S.DELETION_TIME - 1
17/04/2019 - SYS.AQ$_SCHEDULER$_REMDB_JOBQTAB_S.MODIFICATION_TIME - 1
17/04/2019 - SYS.AQ$_SCHEDULER_FILEWATCHER_QT_S.CREATION_TIME - 1
17/04/2019 - SYS.AQ$_SCHEDULER_FILEWATCHER_QT_S.DELETION_TIME - 1
17/04/2019 - SYS.AQ$_SCHEDULER_FILEWATCHER_QT_S.MODIFICATION_TIME - 1
17/04/2019 - SYS.AQ$_SUBSCRIBER_TABLE.CREATION_TIME - 1
17/04/2019 - SYS.AQ$_SUBSCRIBER_TABLE.DELETION_TIME - 1
17/04/2019 - SYS.AQ$_SUBSCRIBER_TABLE.MODIFICATION_TIME - 1
17/04/2019 - SYS.AQ$_SYS$SERVICE_METRICS_TAB_S.CREATION_TIME - 4
17/04/2019 - SYS.AQ$_SYS$SERVICE_METRICS_TAB_S.DELETION_TIME - 4
17/04/2019 - SYS.AQ$_SYS$SERVICE_METRICS_TAB_S.MODIFICATION_TIME - 4
17/04/2019 - SYS.KET$_AUTOTASK_STATUS.ABA_START_TIME - 1
17/04/2019 - SYS.KET$_AUTOTASK_STATUS.ABA_STATE_TIME - 1
17/04/2019 - SYS.KET$_AUTOTASK_STATUS.MW_RECORD_TIME - 1
17/04/2019 - SYS.KET$_AUTOTASK_STATUS.MW_START_TIME - 1
17/04/2019 - SYS.KET$_AUTOTASK_STATUS.RECONCILE_TIME - 1
17/04/2019 - SYS.KET$_CLIENT_CONFIG.FIELD_2 - 7
17/04/2019 - SYS.KET$_CLIENT_CONFIG.LAST_CHANGE - 7
15/10/2024 - SYS.OPTSTAT_HIST_CONTROL$.SPARE6 - 45
15/10/2024 - SYS.OPTSTAT_HIST_CONTROL$.SVAL2 - 45
15/10/2024 - SYS.OPTSTAT_SNAPSHOT$.TIMESTAMP - 84
17/04/2019 - SYS.OPTSTAT_USER_PREFS$.CHGTIME - 72
17/04/2019 - SYS.RADM_FPTM$.TSWTZ_COL - 1
17/04/2019 - SYS.REG$.NTFN_GROUPING_START_TIME - 2
17/04/2019 - SYS.REG$.REG_TIME - 2
17/04/2019 - SYS.SCHEDULER$_EVENT_LOG.LOG_DATE - 29
17/04/2019 - SYS.SCHEDULER$_GLOBAL_ATTRIBUTE.ATTR_TSTAMP - 11
17/04/2019 - SYS.SCHEDULER$_JOB.END_DATE - 21
17/04/2019 - SYS.SCHEDULER$_JOB.LAST_ENABLED_TIME - 21
17/04/2019 - SYS.SCHEDULER$_JOB.LAST_END_DATE - 21
17/04/2019 - SYS.SCHEDULER$_JOB.LAST_START_DATE - 21
17/04/2019 - SYS.SCHEDULER$_JOB.NEXT_RUN_DATE - 21
17/04/2019 - SYS.SCHEDULER$_JOB.START_DATE - 21
17/04/2019 - SYS.SCHEDULER$_SCHEDULE.END_DATE - 4
17/04/2019 - SYS.SCHEDULER$_SCHEDULE.REFERENCE_DATE - 4
17/04/2019 - SYS.SCHEDULER$_WINDOW.ACTUAL_START_DATE - 9
17/04/2019 - SYS.SCHEDULER$_WINDOW.END_DATE - 9
17/04/2019 - SYS.SCHEDULER$_WINDOW.LAST_START_DATE - 9
17/04/2019 - SYS.SCHEDULER$_WINDOW.MANUAL_OPEN_TIME - 9
17/04/2019 - SYS.SCHEDULER$_WINDOW.NEXT_START_DATE - 9
17/04/2019 - SYS.SCHEDULER$_WINDOW.START_DATE - 9
Total numrows of SYS TSTZ columns is : 70713
There are in total 169 SYS TSTZ columns.

.
For non-SYS tables ...
Note: empty tables are not listed.
Stat date - Owner.Tablename.Columnname - num_rows
17/04/2019 - GSMADMIN_INTERNAL.AQ$_CHANGE_LOG_QUEUE_TABLE_S.CREATION_TIME - 1
17/04/2019 - GSMADMIN_INTERNAL.AQ$_CHANGE_LOG_QUEUE_TABLE_S.DELETION_TIME - 1
17/04/2019 - GSMADMIN_INTERNAL.AQ$_CHANGE_LOG_QUEUE_TABLE_S.MODIFICATION_TIME -1
17/04/2019 - WMSYS.AQ$_WM$EVENT_QUEUE_TABLE_S.CREATION_TIME - 1
17/04/2019 - WMSYS.AQ$_WM$EVENT_QUEUE_TABLE_S.DELETION_TIME - 1
17/04/2019 - WMSYS.AQ$_WM$EVENT_QUEUE_TABLE_S.MODIFICATION_TIME - 1
17/04/2019 - WMSYS.WM$WORKSPACES_TABLE$.CREATETIME - 1
17/04/2019 - WMSYS.WM$WORKSPACES_TABLE$.LAST_CHANGE - 1
Total numrows of non-SYS TSTZ columns is : 8
There are in total 20 non-SYS TSTZ columns.
Total Minutes elapsed : 0
Session altered.

SQL>

SQL>

SQL> @$ORACLE_HOME/rdbms/admin/utltz_countstar.sql

Session altered.

.
Estimating amount of TSTZ data using COUNT(*).
This might take some time ...
.

For SYS tables first ...
Note: empty tables are not listed.
Owner.TableName.ColumnName - COUNT(*) of that column
SYS.AQ$_ALERT_QT_S.CREATION_TIME - 4
SYS.AQ$_ALERT_QT_S.DELETION_TIME - 4
SYS.AQ$_ALERT_QT_S.MODIFICATION_TIME - 4
SYS.AQ$_AQ$_MEM_MC_S.CREATION_TIME - 3
SYS.AQ$_AQ$_MEM_MC_S.DELETION_TIME - 3
SYS.AQ$_AQ$_MEM_MC_S.MODIFICATION_TIME - 3
SYS.AQ$_AQ_PROP_TABLE_S.CREATION_TIME - 1
SYS.AQ$_AQ_PROP_TABLE_S.DELETION_TIME - 1
SYS.AQ$_AQ_PROP_TABLE_S.MODIFICATION_TIME - 1
SYS.AQ$_ORA$PREPLUGIN_BACKUP_QTB_S.CREATION_TIME - 1
SYS.AQ$_ORA$PREPLUGIN_BACKUP_QTB_S.DELETION_TIME - 1
SYS.AQ$_ORA$PREPLUGIN_BACKUP_QTB_S.MODIFICATION_TIME - 1
SYS.AQ$_PDB_MON_EVENT_QTABLE$_S.CREATION_TIME - 1
SYS.AQ$_PDB_MON_EVENT_QTABLE$_S.DELETION_TIME - 1
SYS.AQ$_PDB_MON_EVENT_QTABLE$_S.MODIFICATION_TIME - 1
SYS.AQ$_SCHEDULER$_EVENT_QTAB_S.CREATION_TIME - 3
SYS.AQ$_SCHEDULER$_EVENT_QTAB_S.DELETION_TIME - 3
SYS.AQ$_SCHEDULER$_EVENT_QTAB_S.MODIFICATION_TIME - 3
SYS.AQ$_SCHEDULER$_REMDB_JOBQTAB_S.CREATION_TIME - 1
SYS.AQ$_SCHEDULER$_REMDB_JOBQTAB_S.DELETION_TIME - 1
SYS.AQ$_SCHEDULER$_REMDB_JOBQTAB_S.MODIFICATION_TIME - 1
SYS.AQ$_SCHEDULER_FILEWATCHER_QT_S.CREATION_TIME - 1
SYS.AQ$_SCHEDULER_FILEWATCHER_QT_S.DELETION_TIME - 1
SYS.AQ$_SCHEDULER_FILEWATCHER_QT_S.MODIFICATION_TIME - 1
SYS.AQ$_SUBSCRIBER_TABLE.CREATION_TIME - 1
SYS.AQ$_SUBSCRIBER_TABLE.DELETION_TIME - 1
SYS.AQ$_SUBSCRIBER_TABLE.MODIFICATION_TIME - 1
SYS.AQ$_SYS$SERVICE_METRICS_TAB_S.CREATION_TIME - 4
SYS.AQ$_SYS$SERVICE_METRICS_TAB_S.DELETION_TIME - 4
SYS.AQ$_SYS$SERVICE_METRICS_TAB_S.MODIFICATION_TIME - 4
SYS.ATSK$_SCHEDULE_CONTROL.MRCT_TASK_TIME_TZ - 1
SYS.KET$_AUTOTASK_STATUS.ABA_START_TIME - 1
SYS.KET$_AUTOTASK_STATUS.ABA_STATE_TIME - 1
SYS.KET$_AUTOTASK_STATUS.MW_RECORD_TIME - 1
SYS.KET$_AUTOTASK_STATUS.MW_START_TIME - 1
SYS.KET$_AUTOTASK_STATUS.RECONCILE_TIME - 1
SYS.KET$_CLIENT_CONFIG.FIELD_2 - 7
SYS.KET$_CLIENT_CONFIG.LAST_CHANGE - 7
SYS.OPTSTAT_HIST_CONTROL$.SPARE6 - 45
SYS.OPTSTAT_HIST_CONTROL$.SVAL2 - 45
SYS.OPTSTAT_SNAPSHOT$.TIMESTAMP - 1015
SYS.OPTSTAT_USER_PREFS$.CHGTIME - 72
SYS.RADM_FPTM$.TSWTZ_COL - 1
SYS.REG$.NTFN_GROUPING_START_TIME - 2
SYS.REG$.REG_TIME - 2
SYS.SCHEDULER$_EVENT_LOG.LOG_DATE - 18
SYS.SCHEDULER$_GLOBAL_ATTRIBUTE.ATTR_TSTAMP - 11
SYS.SCHEDULER$_JOB.END_DATE - 22
SYS.SCHEDULER$_JOB.LAST_ENABLED_TIME - 22
SYS.SCHEDULER$_JOB.LAST_END_DATE - 22
SYS.SCHEDULER$_JOB.LAST_START_DATE - 22
SYS.SCHEDULER$_JOB.NEXT_RUN_DATE - 22
SYS.SCHEDULER$_JOB.START_DATE - 22
SYS.SCHEDULER$_JOB_RUN_DETAILS.LOG_DATE - 18
SYS.SCHEDULER$_JOB_RUN_DETAILS.REQ_START_DATE - 18
SYS.SCHEDULER$_JOB_RUN_DETAILS.START_DATE - 18
SYS.SCHEDULER$_SCHEDULE.END_DATE - 4
SYS.SCHEDULER$_SCHEDULE.REFERENCE_DATE - 4
SYS.SCHEDULER$_WINDOW.ACTUAL_START_DATE - 9
SYS.SCHEDULER$_WINDOW.END_DATE - 9
SYS.SCHEDULER$_WINDOW.LAST_START_DATE - 9
SYS.SCHEDULER$_WINDOW.MANUAL_OPEN_TIME - 9
SYS.SCHEDULER$_WINDOW.NEXT_START_DATE - 9
SYS.SCHEDULER$_WINDOW.START_DATE - 9
SYS.WRI$_ALERT_HISTORY.CREATION_TIME - 46
SYS.WRI$_ALERT_HISTORY.TIME_SUGGESTED - 46
SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY.SAVTIME - 3213
SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY.SPARE6 - 3213
SYS.WRI$_OPTSTAT_IND_HISTORY.SAVTIME - 248
SYS.WRI$_OPTSTAT_IND_HISTORY.SPARE6 - 248
SYS.WRI$_OPTSTAT_OPR.END_TIME - 27
SYS.WRI$_OPTSTAT_OPR.SPARE6 - 27
SYS.WRI$_OPTSTAT_OPR.START_TIME - 27
SYS.WRI$_OPTSTAT_OPR_TASKS.END_TIME - 602
SYS.WRI$_OPTSTAT_OPR_TASKS.SPARE6 - 602
SYS.WRI$_OPTSTAT_OPR_TASKS.START_TIME - 602
SYS.WRI$_OPTSTAT_TAB_HISTORY.SAVTIME - 297
SYS.WRI$_OPTSTAT_TAB_HISTORY.SPARE6 - 297
SYS.WRM$_DATABASE_INSTANCE.STARTUP_TIME_TZ - 6
SYS.WRM$_SNAPSHOT.BEGIN_INTERVAL_TIME_TZ - 2
SYS.WRM$_SNAPSHOT.END_INTERVAL_TIME_TZ - 2
SYS.XS$PRIN.END_DATE - 15
SYS.XS$PRIN.START_DATE - 15
Total count * of SYS TSTZ columns is : 11074
There are in total 169 SYS TSTZ columns.

.
For non-SYS tables ...
Note: empty tables are not listed.
Owner.TableName.ColumnName - COUNT(*) of that column
GSMADMIN_INTERNAL.AQ$_CHANGE_LOG_QUEUE_TABLE_S.CREATION_TIME - 1
GSMADMIN_INTERNAL.AQ$_CHANGE_LOG_QUEUE_TABLE_S.DELETION_TIME - 1
GSMADMIN_INTERNAL.AQ$_CHANGE_LOG_QUEUE_TABLE_S.MODIFICATION_TIME - 1
WMSYS.AQ$_WM$EVENT_QUEUE_TABLE_S.CREATION_TIME - 1
WMSYS.AQ$_WM$EVENT_QUEUE_TABLE_S.DELETION_TIME - 1
WMSYS.AQ$_WM$EVENT_QUEUE_TABLE_S.MODIFICATION_TIME - 1
WMSYS.WM$WORKSPACES_TABLE$.CREATETIME - 1
WMSYS.WM$WORKSPACES_TABLE$.LAST_CHANGE - 1
Total count * of non-SYS TSTZ columns is : 8
There are in total 20 non-SYS TSTZ columns.
Total Minutes elapsed : 0

Session altered.

SQL>



SQL> @$ORACLE_HOME/rdbms/admin/utltz_upg_check.sql

Session altered.

INFO: Starting with RDBMS DST update preparation.
INFO: NO actual RDBMS DST update will be done by this script.
INFO: If an ERROR occurs the script will EXIT sqlplus.
INFO: Doing checks for known issues ...
INFO: Database version is 19.0.0.0 .
INFO: This database is a Multitenant database.
INFO: Current container is CDB$ROOT .
INFO: Updating the RDBMS DST version of the CDB / CDB$ROOT database
INFO: will NOT update the RDBMS DST version of PDB databases in this CDB.
WARNING: There are 1 open PDBs .
WARNING: They will be closed when running utltz_upg_apply.sql .
INFO: Database RDBMS DST version is DSTv32 .
INFO: No known issues detected.
INFO: Now detecting new RDBMS DST version.
A prepare window has been successfully started.
INFO: Newest RDBMS DST version detected is DSTv43 .
INFO: Next step is checking all TSTZ data.
INFO: It might take a while before any further output is seen ...
A prepare window has been successfully ended.
INFO: A newer RDBMS DST version than the one currently used is found.
INFO: Note that NO DST update was yet done.
INFO: Now run utltz_upg_apply.sql to do the actual RDBMS DST update.
INFO: Note that the utltz_upg_apply.sql script will
INFO: restart the database 2 times WITHOUT any confirmation or prompt.

Session altered.

SQL>
SQL>
SQL> @$ORACLE_HOME/rdbms/admin/utltz_upg_apply.sql

Session altered.

INFO: If an ERROR occurs, the script will EXIT SQL*Plus.
INFO: The database RDBMS DST version will be updated to DSTv43 .
INFO: This database is a Multitenant database.
INFO: Current container is CDB$ROOT .
INFO: Updating the RDBMS DST version of the CDB / CDB$ROOT database
INFO: will NOT update the RDBMS DST version of PDB databases in this CDB.
WARNING: There are 1 open PDBs .
WARNING: They will be closed when CDB$ROOT is restarted
WARNING: This script will restart the database 2 times
WARNING: WITHOUT asking ANY confirmation.
WARNING: Hit control-c NOW if this is not intended.
INFO: Restarting the database in UPGRADE mode to start the DST upgrade.
Database closed.
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.

Total System Global Area 1459616616 bytes
Fixed Size 9177960 bytes
Variable Size 855638016 bytes
Database Buffers 587202560 bytes
Redo Buffers 7598080 bytes
Database mounted.
Database opened.

INFO: Starting the RDBMS DST upgrade.
INFO: Upgrading all SYS owned TSTZ data.
INFO: It might take time before any further output is seen ...
An upgrade window has been successfully started.
INFO: Restarting the database in NORMAL mode to upgrade non-SYS TSTZ data.
Database closed.
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.

Total System Global Area 1459616616 bytes
Fixed Size 9177960 bytes
Variable Size 855638016 bytes
Database Buffers 587202560 bytes
Redo Buffers 7598080 bytes
Database mounted.
Database opened.

INFO: Upgrading all non-SYS TSTZ data.
INFO: It might take time before any further output is seen ...
INFO: Do NOT start any application yet that uses TSTZ data!
INFO: Next is a list of all upgraded tables:
Table list: "GSMADMIN_INTERNAL"."AQ$_CHANGE_LOG_QUEUE_TABLE_L"
Number of failures: 0
Table list: "GSMADMIN_INTERNAL"."AQ$_CHANGE_LOG_QUEUE_TABLE_S"
Number of failures: 0
Table list: "MDSYS"."SDO_DIAG_MESSAGES_TABLE"
Number of failures: 0
Table list: "DVSYS"."AUDIT_TRAIL$"
Number of failures: 0
Table list: "DVSYS"."SIMULATION_LOG$"
Number of failures: 0
INFO: Total failures during update of TSTZ data: 0 .
An upgrade window has been successfully ended.
INFO: Your new Server RDBMS DST version is DSTv43 .
INFO: The RDBMS DST update is successfully finished.
INFO: Make sure to exit this SQL*Plus session.
INFO: Do not use it for timezone related selects.

Session altered.

SQL>
SQL> exit
At PDB:

[oracle@test admin]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Mar 6 04:15:33 2025
Version 19.24.0.0.0

Copyright (c) 1982, 2024, Oracle. All rights reserved.

Connected to:
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.24.0.0.0

SQL> SELECT version FROM v$timezone_file;

VERSION
----------
        43

SQL> show pdbs

CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 ORCLPDB2                       READ WRITE NO

SQL> alter session set container=ORCLPDB2;

Session altered.

SQL> SELECT version FROM v$timezone_file;

VERSION
----------
        32

SQL> @$ORACLE_HOME/rdbms/admin/utltz_countstats.sql

Session altered.

.
Amount of TSTZ data using num_rows stats info in DBA_TABLES.
.
For SYS tables first ...
Note: empty tables are not listed.
Stat date  - Owner.TableName.ColumnName - num_rows
17/04/2019 - SYS.AQ$_ALERT_QT_S.CREATION_TIME - 3
17/04/2019 - SYS.AQ$_ALERT_QT_S.DELETION_TIME - 3
17/04/2019 - SYS.AQ$_ALERT_QT_S.MODIFICATION_TIME - 3
17/04/2019 - SYS.AQ$_AQ$_MEM_MC_S.CREATION_TIME - 3
17/04/2019 - SYS.AQ$_AQ$_MEM_MC_S.DELETION_TIME - 3
17/04/2019 - SYS.AQ$_AQ$_MEM_MC_S.MODIFICATION_TIME - 3
17/04/2019 - SYS.AQ$_AQ_PROP_TABLE_S.CREATION_TIME - 1
17/04/2019 - SYS.AQ$_AQ_PROP_TABLE_S.DELETION_TIME - 1
17/04/2019 - SYS.AQ$_AQ_PROP_TABLE_S.MODIFICATION_TIME - 1
17/04/2019 - SYS.AQ$_ORA$PREPLUGIN_BACKUP_QTB_S.CREATION_TIME - 1
17/04/2019 - SYS.AQ$_ORA$PREPLUGIN_BACKUP_QTB_S.DELETION_TIME - 1
17/04/2019 - SYS.AQ$_ORA$PREPLUGIN_BACKUP_QTB_S.MODIFICATION_TIME - 1
...
...
Total numrows of SYS TSTZ columns is : 82193
There are in total 169 SYS TSTZ columns.
.
For non-SYS tables ...
Note: empty tables are not listed.
Stat date  - Owner.Tablename.Columnname - num_rows
17/04/2019 - GSMADMIN_INTERNAL.AQ$_CHANGE_LOG_QUEUE_TABLE_S.CREATION_TIME - 1
17/04/2019 - GSMADMIN_INTERNAL.AQ$_CHANGE_LOG_QUEUE_TABLE_S.DELETION_TIME - 1
17/04/2019 - GSMADMIN_INTERNAL.AQ$_CHANGE_LOG_QUEUE_TABLE_S.MODIFICATION_TIME - 1
17/04/2019 - WMSYS.AQ$_WM$EVENT_QUEUE_TABLE_S.CREATION_TIME - 1
17/04/2019 - WMSYS.AQ$_WM$EVENT_QUEUE_TABLE_S.DELETION_TIME - 1
17/04/2019 - WMSYS.AQ$_WM$EVENT_QUEUE_TABLE_S.MODIFICATION_TIME - 1
17/04/2019 - WMSYS.WM$WORKSPACES_TABLE$.CREATETIME - 1
17/04/2019 - WMSYS.WM$WORKSPACES_TABLE$.LAST_CHANGE - 1
Total numrows of non-SYS TSTZ columns is : 8
There are in total 20 non-SYS TSTZ columns.
Total Minutes elapsed : 0

Session altered.

SQL>
SQL>
SQL> @$ORACLE_HOME/rdbms/admin/utltz_countstar.sql

Session altered.

Estimating amount of TSTZ data using COUNT(*).
This might take some time ...

For SYS tables first ...
Note: empty tables are not listed.
Owner.TableName.ColumnName - COUNT(*) of that column
SYS.AQ$_ALERT_QT_S.CREATION_TIME - 3
SYS.AQ$_ALERT_QT_S.DELETION_TIME - 3
SYS.AQ$_ALERT_QT_S.MODIFICATION_TIME - 3
SYS.AQ$_AQ$_MEM_MC_S.CREATION_TIME - 3
SYS.AQ$_AQ$_MEM_MC_S.DELETION_TIME - 3
SYS.AQ$_AQ$_MEM_MC_S.MODIFICATION_TIME - 3
SYS.AQ$_AQ_PROP_TABLE_S.CREATION_TIME - 1
SYS.AQ$_AQ_PROP_TABLE_S.DELETION_TIME - 1
SYS.AQ$_AQ_PROP_TABLE_S.MODIFICATION_TIME - 1
SYS.AQ$_ORA$PREPLUGIN_BACKUP_QTB_S.CREATION_TIME - 1
SYS.AQ$_ORA$PREPLUGIN_BACKUP_QTB_S.DELETION_TIME - 1
SYS.AQ$_ORA$PREPLUGIN_BACKUP_QTB_S.MODIFICATION_TIME - 1
SYS.AQ$_PDB_MON_EVENT_QTABLE$_S.CREATION_TIME - 1
SYS.AQ$_PDB_MON_EVENT_QTABLE$_S.DELETION_TIME - 1
SYS.AQ$_PDB_MON_EVENT_QTABLE$_S.MODIFICATION_TIME - 1
SYS.AQ$_SCHEDULER$_EVENT_QTAB_S.CREATION_TIME - 3
SYS.AQ$_SCHEDULER$_EVENT_QTAB_S.DELETION_TIME - 3
SYS.AQ$_SCHEDULER$_EVENT_QTAB_S.MODIFICATION_TIME - 3
SYS.AQ$_SCHEDULER$_REMDB_JOBQTAB_S.CREATION_TIME - 1
SYS.AQ$_SCHEDULER$_REMDB_JOBQTAB_S.DELETION_TIME - 1
SYS.AQ$_SCHEDULER$_REMDB_JOBQTAB_S.MODIFICATION_TIME - 1
SYS.AQ$_SCHEDULER_FILEWATCHER_QT_S.CREATION_TIME - 1
SYS.AQ$_SCHEDULER_FILEWATCHER_QT_S.DELETION_TIME - 1
SYS.AQ$_SCHEDULER_FILEWATCHER_QT_S.MODIFICATION_TIME - 1
SYS.AQ$_SUBSCRIBER_TABLE.CREATION_TIME - 1
SYS.AQ$_SUBSCRIBER_TABLE.DELETION_TIME - 1
SYS.AQ$_SUBSCRIBER_TABLE.MODIFICATION_TIME - 1
SYS.AQ$_SYS$SERVICE_METRICS_TAB_S.CREATION_TIME - 4
SYS.AQ$_SYS$SERVICE_METRICS_TAB_S.DELETION_TIME - 4
SYS.AQ$_SYS$SERVICE_METRICS_TAB_S.MODIFICATION_TIME - 4
SYS.ATSK$_SCHEDULE_CONTROL.MRCT_TASK_TIME_TZ - 1
SYS.KET$_AUTOTASK_STATUS.ABA_START_TIME - 1
SYS.KET$_AUTOTASK_STATUS.ABA_STATE_TIME - 1
SYS.KET$_AUTOTASK_STATUS.MW_RECORD_TIME - 1
SYS.KET$_AUTOTASK_STATUS.MW_START_TIME - 1
SYS.KET$_AUTOTASK_STATUS.RECONCILE_TIME - 1
SYS.KET$_CLIENT_CONFIG.FIELD_2 - 7
SYS.KET$_CLIENT_CONFIG.LAST_CHANGE - 7
SYS.OPTSTAT_HIST_CONTROL$.SPARE6 - 45
SYS.OPTSTAT_HIST_CONTROL$.SVAL2 - 45
SYS.OPTSTAT_SNAPSHOT$.TIMESTAMP - 740
SYS.OPTSTAT_USER_PREFS$.CHGTIME - 72
SYS.RADM_FPTM$.TSWTZ_COL - 1
SYS.REG$.NTFN_GROUPING_START_TIME - 2
SYS.REG$.REG_TIME - 2
SYS.SCHEDULER$_EVENT_LOG.LOG_DATE - 10
SYS.SCHEDULER$_GLOBAL_ATTRIBUTE.ATTR_TSTAMP - 11
SYS.SCHEDULER$_JOB.END_DATE - 20
SYS.SCHEDULER$_JOB.LAST_ENABLED_TIME - 20
SYS.SCHEDULER$_JOB.LAST_END_DATE - 20
SYS.SCHEDULER$_JOB.LAST_START_DATE - 20
SYS.SCHEDULER$_JOB.NEXT_RUN_DATE - 20
SYS.SCHEDULER$_JOB.START_DATE - 20
SYS.SCHEDULER$_JOB_RUN_DETAILS.LOG_DATE - 10
SYS.SCHEDULER$_JOB_RUN_DETAILS.REQ_START_DATE - 10
SYS.SCHEDULER$_JOB_RUN_DETAILS.START_DATE - 10
SYS.SCHEDULER$_SCHEDULE.END_DATE - 4
SYS.SCHEDULER$_SCHEDULE.REFERENCE_DATE - 4
SYS.SCHEDULER$_WINDOW.ACTUAL_START_DATE - 9
SYS.SCHEDULER$_WINDOW.END_DATE - 9
SYS.SCHEDULER$_WINDOW.LAST_START_DATE - 9
SYS.SCHEDULER$_WINDOW.MANUAL_OPEN_TIME - 9
SYS.SCHEDULER$_WINDOW.NEXT_START_DATE - 9
SYS.SCHEDULER$_WINDOW.START_DATE - 9
SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY.SAVTIME - 3319
SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY.SPARE6 - 3319
SYS.WRI$_OPTSTAT_IND_HISTORY.SAVTIME - 259
SYS.WRI$_OPTSTAT_IND_HISTORY.SPARE6 - 259
SYS.WRI$_OPTSTAT_OPR.END_TIME - 21
SYS.WRI$_OPTSTAT_OPR.SPARE6 - 21
SYS.WRI$_OPTSTAT_OPR.START_TIME - 21
SYS.WRI$_OPTSTAT_OPR_TASKS.END_TIME - 611
SYS.WRI$_OPTSTAT_OPR_TASKS.SPARE6 - 611
SYS.WRI$_OPTSTAT_OPR_TASKS.START_TIME - 611
SYS.WRI$_OPTSTAT_TAB_HISTORY.SAVTIME - 295
SYS.WRI$_OPTSTAT_TAB_HISTORY.SPARE6 - 295
SYS.XS$PRIN.END_DATE - 15
SYS.XS$PRIN.START_DATE - 15
Total count * of SYS TSTZ columns is : 10889
There are in total 169 SYS TSTZ columns.

For non-SYS tables ...
Note: empty tables are not listed.
Owner.TableName.ColumnName - COUNT(*) of that column
GSMADMIN_INTERNAL.AQ$_CHANGE_LOG_QUEUE_TABLE_S.CREATION_TIME - 1
GSMADMIN_INTERNAL.AQ$_CHANGE_LOG_QUEUE_TABLE_S.DELETION_TIME - 1
GSMADMIN_INTERNAL.AQ$_CHANGE_LOG_QUEUE_TABLE_S.MODIFICATION_TIME - 1
WMSYS.AQ$_WM$EVENT_QUEUE_TABLE_S.CREATION_TIME - 1
WMSYS.AQ$_WM$EVENT_QUEUE_TABLE_S.DELETION_TIME - 1
WMSYS.AQ$_WM$EVENT_QUEUE_TABLE_S.MODIFICATION_TIME - 1
WMSYS.WM$WORKSPACES_TABLE$.CREATETIME - 1
WMSYS.WM$WORKSPACES_TABLE$.LAST_CHANGE - 1
Total count * of non-SYS TSTZ columns is : 8
There are in total 20 non-SYS TSTZ columns.
Total Minutes elapsed : 0

Session altered.

SQL>
SQL>
SQL> @$ORACLE_HOME/rdbms/admin/utltz_upg_check.sql

Session altered.

INFO: Starting with RDBMS DST update preparation.
INFO: NO actual RDBMS DST update will be done by this script.
INFO: If an ERROR occurs the script will EXIT sqlplus.
INFO: Doing checks for known issues ...
INFO: Database version is 19.0.0.0 .
INFO: This database is a Multitenant database.
INFO: This database is a PDB.
INFO: Current PDB is ORCLPDB2 .
INFO: Database RDBMS DST version is DSTv32 .
INFO: No known issues detected.
INFO: Now detecting new RDBMS DST version.
A prepare window has been successfully started.
INFO: Newest RDBMS DST version detected is DSTv43 .
INFO: Next step is checking all TSTZ data.
INFO: It might take a while before any further output is seen ...
A prepare window has been successfully ended.
INFO: A newer RDBMS DST version than the one currently used is found.
INFO: Note that NO DST update was yet done.
INFO: Now run utltz_upg_apply.sql to do the actual RDBMS DST update.
INFO: Note that the utltz_upg_apply.sql script will
INFO: restart the database 2 times WITHOUT any confirmation or prompt.

Session altered.

SQL>

SQL>
SQL> @$ORACLE_HOME/rdbms/admin/utltz_upg_apply.sql

Session altered.

INFO: If an ERROR occurs, the script will EXIT SQL*Plus.
INFO: The database RDBMS DST version will be updated to DSTv43 .
INFO: This database is a Multitenant database.
INFO: This database is a PDB.
INFO: Current PDB is ORCLPDB2 .
WARNING: This script will restart the database 2 times
WARNING: WITHOUT asking ANY confirmation.
WARNING: Hit control-c NOW if this is not intended.
INFO: Restarting the database in UPGRADE mode to start the DST upgrade.
Pluggable Database closed.
Pluggable Database opened.
INFO: Starting the RDBMS DST upgrade.
INFO: Upgrading all SYS owned TSTZ data.
INFO: It might take time before any further output is seen ...
An upgrade window has been successfully started.
INFO: Restarting the database in NORMAL mode to upgrade non-SYS TSTZ data.
Pluggable Database closed.
Pluggable Database opened.
INFO: Upgrading all non-SYS TSTZ data.
INFO: It might take time before any further output is seen ...
INFO: Do NOT start any application yet that uses TSTZ data!

INFO: Next is a list of all upgraded tables:
Table list: "GSMADMIN_INTERNAL"."AQ$_CHANGE_LOG_QUEUE_TABLE_L"
Number of failures: 0
Table list: "GSMADMIN_INTERNAL"."AQ$_CHANGE_LOG_QUEUE_TABLE_S"
Number of failures: 0
Table list: "MDSYS"."SDO_DIAG_MESSAGES_TABLE"
Number of failures: 0
Table list: "DVSYS"."AUDIT_TRAIL$"
Number of failures: 0
Table list: "DVSYS"."SIMULATION_LOG$"
Number of failures: 0
INFO: Total failures during update of TSTZ data: 0 .
An upgrade window has been successfully ended.
INFO: Your new Server RDBMS DST version is DSTv43 .
INFO: The RDBMS DST update is successfully finished.
INFO: Make sure to exit this SQL*Plus session.
INFO: Do not use it for timezone related selects.

Session altered.

SQL> 
SQL> exit
3. Now take the bounce of database and check timezone file at both CDB & PDB level: 

[oracle@test admin]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Mar 6 04:28:19 2025
Version 19.24.0.0.0

Copyright (c) 1982, 2024, Oracle. All rights reserved.

Connected to:
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.24.0.0.0

SQL>
SQL>
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL>
SQL> startup
ORACLE instance started.

Total System Global Area 1459616616 bytes
Fixed Size                  9177960 bytes
Variable Size             855638016 bytes
Database Buffers          587202560 bytes
Redo Buffers                7598080 bytes
Database mounted.
Database opened.
SQL>
SQL> SELECT version FROM v$timezone_file;

VERSION
----------
43

SQL> alter session set container=ORCLPDB2;

Session altered.

SQL> SELECT version FROM v$timezone_file;

VERSION
----------
43

SQL> exit
Disconnected from Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.24.0.0.0
[oracle@test admin]$


Thanks for visiting!!

0 comments:

Post a Comment