Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can the time zone file release on an Oracle 11g database be upgraded from release 14 to release 18?

user3180584Jul 14 2016 — edited Jul 15 2016

I received a request to export a schema from an Oracle12c instance (12.1.0.2) and import the schema into an Oracle 11g instance (11.2.0.2).

These are the errors returned to the screen.

 

UDI-31626: operation generated ORACLE error 31626

ORA-31626: job does not exist

ORA-39086: cannot retrieve job information

ORA-06512: at "SYS.DBMS_DATAPUMP", line 3326

ORA-06512: at "SYS.DBMS_DATAPUMP", line 4551

ORA-06512: at line 1

These are the errors from the Data Pump master trace file located in directory $ORACLE_BASE/diag/rdbms/sid/SID/trace.

 

*** 2016-07-13 12:59:59.097

kswsdlaqsub: sub:SYS$SM_SYS svc:SYS.KUPC$C_2_20160713125752 unexpected exception err=604, err2=24010

 

*** 2016-07-13 13:00:00.257

kswsdlaqsub: sub:SYS$SM_SYS svc:SYS.KUPC$S_2_20160713125752 unexpected exception err=604, err2=24010


I found the following in the data pump import log file.

 

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 18 in $ORACLE_HOME/oracore/zoneinfo

 

From the source database (12.1.0.2).

 

SQL> select * from v$timezone_file;


FILENAME VERSION     CON_ID

-------------------- ---------- ----------

timezlrg_18.dat              18          0


From the target database (11.2.0.2).

 

FILENAME VERSION

-------------------- ----------

timezlrg_14.dat              14

 

 

 

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 12 2016
Added on Jul 14 2016
2 comments
728 views