EXPDP-UED-00018数据泵导出数据提示版本不一致

zhp19891010

OS：Oracle Enterprise Linux 5.7
DB version：11G R2 11.2.0.1 单实例

[oracle@zhp ~]$ expdp  jssi/**** schemas=jssi  directory=data_pump_dir dumpfile=jssi20140416.dmp  CONTENT=METADATA_ONLY

Export: Release 11.2.0.1.0 - Production on Wed Apr 16 22:23:42 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
UDE-00018: Data Pump client is incompatible with database version 11.2.0.1.0

[oracle@zhp ~]$ oerr ude 18
00018, 00000, "Data Pump client is incompatible with database version %s"
// *Cause:  The Export utility is at a higher version than the database
//          version and is thereby incompatible.
// *Action: Use the same version of Export utility as the database.
[oracle@zhp ~]$ expdp  jssi/jssi schemas=jssi  directory=data_pump_dir dumpfile=jssi20140416.dmp  CONTENT=METADATA_ONLY version ='11.2.0.1.0'

Export: Release 11.2.0.1.0 - Production on Wed Apr 16 22:24:22 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
UDE-00018: Data Pump client is incompatible with database version 11.2.0.1.0

在本机上面导出数据提示客户端版本不一致 。数据库 和导出数据库的操作在同一台及其上面 版本一致，请问从哪里下手解决

江南的诗

select owner, object_name, object_type, status from dba_objects where status != 'VALID';

@$ORACLE_HOME/rdbms/admin/utlrp

Maclean Liu(刘相兵

ODM FINDING:

UDE-00018: Data Pump client is incompatible with database version 11.2.0.1 (Doc ID 1274439.1)

APPLIES TO:

Oracle Server - Enterprise Edition - Version 10.1.0.2 to 11.2.0.2 [Release 10.1 to 11.2]
Information in this document applies to any platform.
SYMPTOMS

You recently installed a patch into your database. Since then the DataPump export utility (expdp) fails with errors message:

Export: Release 11.2.0.1.0 - Production on Thu Dec 16 10:40:39 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
UDE-00018: Data Pump client is incompatible with database version 11.2.0.1.0
CAUSE

Invalid packages DBMS_METADATA_INT or/and DBMS_METADATA_UTIL can produce such a behavior.

SOLUTION

1. Verify, if packages DBMS_METADATA_UTIL/DBMS_METADATA_INT are invalid:

SQL> connect / as sysdba
SQL> select owner, object_name, object_type, status from dba_objects where status != 'VALID';
2. Re-compile the invalid objects with:

SQL> connect / as sysdba
SQL> @$ORACLE_HOME/rdbms/admin/utlrp
and retry with DataPump export.

Note: If the packages don't become valid, then check the root cause in view DBA_ERRORS.


UDE-18 (Data Pump client is incompatible with database version xx.yy).

%expdp system/manager@m10102wa DIRECTORY=my_dir \
DUMPFILE=expdp_s.dmp LOGFILE=expdp_s.log SCHEMAS=scott

Export: Release 10.2.0.3.0 - Production on Tuesday, 26 February, 2008 14:46:22
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

UDE-00018: Export utility version can not be more recent than the Data Pump server.

or:

%expdp system/manager@m10203wa DIRECTORY=my_dir \
DUMPFILE=expdp_s.dmp LOGFILE=expdp_s.log SCHEMAS=scott

Export: Release 11.1.0.6.0 - Production on Tuesday, 26 February, 2008 14:49:43
Copyright (c) 2003, 2007, Oracle.  All rights reserved.  

UDE-00018: Data Pump client is incompatible with database version 10.2.0.3.0
Cause: An attempt was made to connect with a higher version Export Data Pump client (e.g. 11.1.0.6.0) to a lower version database (e.g. 10.2.0.3.0), where the Export Data Pump client used Oracle Net to connect to the lower version database. This is not supported.
Action: Use the Export Data Pump client that matches the database version of the source database (i.e.: 10.2.0.3.0 in this case, or any other lower release Export Data Pump client).

Maclean Liu(刘相兵

如2楼的 回复：
@$ORACLE_HOME/rdbms/admin/utlrp