TimeZone Upgrade¶

example: TimeZone 40 upgrade 41

1. Prepare patch¶

1.1 Upload patch

p35099667_190000_Linux-x86-64.zip → for timezone 41

p6880880_190000_Linux-x86-64.zip

1.2 Unzip patch

cd /home/oracle/patch
unzip p35099667_190000_Linux-x86-64.zip
unzip p6880880_190000_Linux-x86-64.zip

1.3 Apply patch

cd /home/oracle/patch/35099667
/home/oracle/patch/OPatch/opatch apply

2. Upgrade timezone¶

2.1 Upgrade tz

export ORACLE_SID=RF
sqlplus / as sysdba

@/oracle/ora19c/rdbms/admin/utltz_countstats.sql
@/oracle/ora19c/rdbms/admin/utltz_countstar.sql
@/oracle/ora19c/rdbms/admin/utltz_upg_check.sql
@/oracle/ora19c/rdbms/admin/utltz_upg_apply.sql
select * from v$timezone_file;