Symptom
You are upgrading your oracle database from source release 10.2.0.5 or 11.2.0.3 or 11.2.0.4 to target release oracle database 12c release1 (12.1.0.2).
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
Connected.
SQL> SELECT version FROM v$timezone_file;
Read more...
Keywords
New Timezone File, Oracle upgrade, 12C, 12.1.0.2, DST, version 18, time zone file , KBA , BC-DB-ORA , Oracle , Problem
About this page
This 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.