UDI-00018: Data Pump client is incompatible with database version 11.2.0.4.0

ERROR: UDI-00018: Data Pump client is incompatible with database version 11.2.0.4.0



Cause: The Import utility is at a higher version than the database version and is thereby incompatible.
Action: Use the same version of Import utility as the database.


[oracle@test_host dbdump]$impdp parfile=impdp_CAP_21122016.par
Import: Release 12.1.0.2.0 - Production on Wed Dec 21 11:36:44 2016
Copyright (c) 1982, 2015, Oracle and/or its affiliates.  All rights reserved.
UDI-00018: Data Pump client is incompatible with database version 11.2.0.4.0

Check which IMPDP utility is used

[oracle@test_host dbdump]$which impdp
/u01/app/oracle/product/12.1.0.2/dbhome_1/bin/impdp

Start the IMPDP from same database version
[oracle@test_host dbdump]$/u01/app/oracle/product/11.2.0/dbhome_1/bin/impdp parfile =impdp_CAP_21122016.par
Import: Release 11.2.0.4.0 - Production on Wed Dec 21 11:46:39 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
Master table "SYS"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_SCHEMA_01":  /******** AS SYSDBA parfile=impdp_CAP_21122016.par
Processing object type SCHEMA_EXPORT/USER





No comments:

Post a Comment