ORA-56935: existing data pump jobs are using a different version

    While importing in an Oracle 12c database, got the below error:

ERROR:

impdp dumpfile=teset2.dmp logfile=imp_teset2.lod directory=ODSFINAL remap_schema=TEST:CRMB

Import: Release 12.1.0.2.0 - Production on Fri Jan 13 00:37:12 2017

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
ORA-39006: internal error
ORA-39065: unexpected master process exception in DISPATCH
ORA-56935: existing datapump jobs are using a different version of time zone data file

ORA-39097: Data Pump job encountered unexpected error -56935

SOLUTION:

SQL> SELECT PROPERTY_NAME, SUBSTR (property_value, 1, 30) value
FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME LIKE 'DST_%'
ORDER BY PROPERTY_NAME; 2 3 4

PROPERTY_NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
DST_PRIMARY_TT_VERSION
28

DST_SECONDARY_TT_VERSION
14

DST_UPGRADE_STATE
DATAPUMP(1)

Check the value of DST_UPGRADE_STATE (1) , Run the below step to make it NONE.

SQL> ALTER SESSION SET EVENTS '30090 TRACE NAME CONTEXT FOREVER, LEVEL 32';

Session altered.

SQL> exec dbms_dst.unload_secondary;

PL/SQL procedure successfully completed.

SQL> SELECT PROPERTY_NAME, SUBSTR (property_value, 1, 30) value
FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME LIKE 'DST_%'
ORDER BY PROPERTY_NAME; 2 3 4

PROPERTY_NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
DST_PRIMARY_TT_VERSION
28

DST_SECONDARY_TT_VERSION
0

DST_UPGRADE_STATE
NONE

Run the import again, it will work fine

impdp dumpfile=teset2.dmp logfile=imp_teset2.lod directory=ODSFINAL remap_schema=TESTNOTU:BSSTDBA exclude=statistics

Import: Release 12.1.0.2.0 - Production on Fri Jan 13 00:42:33 2017

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
Master table "SYS"."SYS_IMPORT_FULL_04" successfully loaded/unloaded
import done in AL32UTF8 character set and UTF8 NCHAR character set
export done in AL32UTF8 character set and AL16UTF16 NCHAR character set
WARNING: possible data loss in character set conversions
Starting "SYS"."SYS_IMPORT_FULL_04": /******** AS SYSDBA dumpfile=teset2.dmp logfile=imp_teset2.lod directory=ODSFINAL remap_schema=TESTNOTU:BSSTDBA exclude=statistics
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "BSSTDBA"."BAU_PROD_AND_PORT_ID" 956.8 KB 8376 rows
Job "SYS"."SYS_IMPORT_FULL_04" successfully completed at Fri Jan 13 00:42:53 2017 elapsed 0 00:00:02