ORA-29283: invalid file operation ORA-06512: at “SYS.UTL_FILE“, line 536 ORA-39000: bad dump file s

在数据泵导入时发生报错ORA-29283: invalid file operation

[oracle@localhost dir]$  impdp user/userdirectory=dir dumpfile=user2020.dmp logfile=imp.log

Import: Release 11.2.0.4.0 - Production on Tue Oct 20 17:08:29 2020

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation

查找问题发现是指定文件夹有问题，解决办法

• 查看文件夹

SQL> select * from dba_directories;

OWNER        DIRECTORY_NAME            DIRECTORY_PATH
------------------------------------------------------------
SYS        DIR                         /oracle/dir
SYS        XMLDIR                      /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/xml
SYS        ORACLE_OCM_CONFIG_DIR       /u01/app/oracle/product/11.2.0/dbhome_1/ccr/hosts/localhost.localdomain/state
SYS        DATA_PUMP_DIR               /u01/app/oracle/admin/ora11g/dpdump/
SYS        ORACLE_OCM_CONFIG_DIR2      /u01/app/oracle/product/11.2.0/dbhome_1/ccr/state

• 重建文件并授权问题解决

SQL> create or replace directory  dir as  '/oracle/midsora' ;

Directory created.

SQL> grant read ,write on directory  dir  to tsunami;

Grant succeeded.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@localhost dir]$  impdp user/user directory=dir dumpfile=user2020.dmp logfile=imp.log

Import: Release 11.2.0.4.0 - Production on Tue Oct 20 17:10:09 2020

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39142: incompatible version number 4.1 in dump file "/oracle/midsora/tsunami2020.dmp"

报错ORA-39000: bad dump file specification

问题分析：数据泵从高版本库向低版本库导入数据时必须指定版本号，否则会出现上面的错误。
原因是导出的实例是12c，导入的实例是11g。

重新导出：

expdp system/oracle directory=dir dumpfile=user2020.dmp logfile=user2020.log version=11.2.0.4.0

再导入就没问题：

impdp user/userdirectory=dir dumpfile=user2020.dmp logfile=imp.log