You are upgrading your oracle database from source release 10.2.0.5 or 22.214.171.124 or 126.96.36.199 to target release oracle database 12c release1 (188.8.131.52).
In Pre-upgrade phase, when running pre_upgrade_checks.sql, you get errors as below:
ERROR: --> New Timezone File in use
Database is using a time zone file newer than version 18.
BEFORE upgrading the database, patch the new
ORACLE_HOME/oracore/zoneinfo/ with a time zone data file of the
same version as the one used in the <source database version> release database.
You can run following command to check the currently used TimeZone file version in the source database. You can see the returned version is higher than 18.
SQL> conn / as sysdba
SQL> SELECT version FROM v$timezone_file;
New Timezone File, Oracle upgrade, 12C, 184.108.40.206, DST, version 18, time zone file , KBA , BC-DB-ORA , Oracle , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.