All we need is an easy explanation of the problem, so here it is.
I’m running a impdp command for a dmp file, but when i read the log file, it show a error like this:
ORA-39097: Data Pump job encountered unexpected error -30094 ORA-39065: unexpected master process exception in DISPATCH ORA-30094: failed to find the time zone data file for version 4 in $ORACLE_HOME/oracore/zoneinfo
I’ve checked version using
SELECT * from v$timezone_file;, and the result displayed is 14.
And i’m running the impdp on server with the following properties:
Oracle Database 11g Express Edition Release 220.127.116.11.0 - 64bit Production PL/SQL Release 18.104.22.168.0 - Production CORE 22.214.171.124.0 Production TNS for 64-bit Windows: Version 126.96.36.199.0 - Production NLSRTL Version 188.8.131.52.0 - Production
I’ve read about upgrading versions, but I don’t quite understand the concept of it, if someone can help me.
How to solve :
I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.
Oracle Express did not ship with a full set of timezones definitions for some reason. See here: http://oraclequirks.blogspot.com/2011/11/ora-30094-failed-to-find-time-zone-data.html?m=1
The recommended "fix" would be to do a software-only of the full Oracle version and copy the files from there. Unfortunately, Oracle 11 is no longer available, so my recommendation would be to – if possible – use Oracle XE 18 instead of 11, and see if you have the same problem. If you do, then get a full software-only install of Oracle 18 or 19 and copy the timezone files from there.
Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂