About the warning: Database is using a timezone file older than version 14.
Hi,
I am in the middle of upgrading the database from 11gR1 to 11gR2 (11.2.0.2).
11gR1 (11.1.0.7) came with eBS R12 installation, and no RAC is in use.
When I ran pre-upgrade information tool, I got few warnings.
One of them is about timezone as below.
WARNING: --> Database is using a timezone file older than version 14.
.... After the release migration, it is recommended that DBMS_DST package
.... be used to upgrade the 11.1.0.7.0 database timezone version
.... to the latest version which comes with the new release.
Currently, the database has file version 10.
SELECT version FROM v$timezone_file;
10
In this case, should I download version 14 from My Oracle Support and place the file to the current directory of <$ORACLE_HOME/oracore/zoneinfo>?
Where can I download from My Oracle Support? I can't find when searching for the file...
Also, as described in the WARNING, can this be performed after the upgrade is completed?