Applying “version 4″ Time Zone Files on an Oracle Database
Applying “version 4″ Time Zone Files on an Oracle Database Applying “version 4″ Time Zone Files on an Oracle Database if your timezone file version is less than 4 Yesterday I was upgrading the database form 10.2.0.3 to 10.2.0.5 on RHEL 5, In readme of the 10.2.0.5 patch i came across the timezoe files, We need to upgarde the timezone files of the base database to 4, is minimum requirement. I found my timezone files 3, you can use following query to find the timezone of the database : SQL> select * from v$timezone_file; FILENAME VERSION ------------ ---------- timezlrg.dat 3 If your database versions are 9.2.0.8 & 10.2.0.4,your timezone file version will be 4 by default, upgrading to 11.1.0.6.0 or 11.2.0.1.0 we need timezone version 4, If your database is 9.2.0.7, we need to upgarde it to 9.2.0.8 or database versions are 10.2.0.1, 10.2.0.2, 10.2....