Upgrade Timezone version (DSTv14) in 11gR2 database after upgrading the database from 11.2.0.3

Upgrade Timezone version (DSTv14) in 11gR2 database after upgrading the database from 11.2.0.3


SQL>  select * from v$timezone_file;

FILENAME                VERSION
-------------------- ----------
timezlrg_3.dat                3

SQL>


SQL> sELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
  FROM DATABASE_PROPERTIES
  WHERE PROPERTY_NAME LIKE 'DST_%'
  ORDER BY PROPERTY_NAME  2    3    4
  5
SQL> /

PROPERTY_NAME                  VALUE
------------------------------ ------------------------------
DST_PRIMARY_TT_VERSION         3
DST_SECONDARY_TT_VERSION       0
DST_UPGRADE_STATE              NONE

SQL>


execute script in below order to update timezone DSTv14


Conn / as sysdba
spool countstatsTSTZ.log
@countstatsTSTZ.sql
spool off

Conn / as sysdba

spool upg_tzv_check.log

@upg_tzv_check.sql

spool off

Conn / as sysdba

spool upg_tzv_apply.log

@upg_tzv_apply.sql

spool off

Conn / as sysdba

spool upg_tzv_check.log

upg_tzv_check.sql

spool off

SQL> select * from v$timezone_file;

FILENAME                VERSION

-------------------- ----------

timezlrg_14.dat              14

SQL> sELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value

  FROM DATABASE_PROPERTIES

  WHERE PROPERTY_NAME LIKE 'DST_%'

  ORDER BY PROPERTY_NAME  2    3    4

  5  /

PROPERTY_NAME                  VALUE

------------------------------ ------------------------------

DST_PRIMARY_TT_VERSION         14

DST_SECONDARY_TT_VERSION       0

DST_UPGRADE_STATE              NONE

SQL>