Oracle Datapump impdp Inappropriate ioctl for device

Question

i had an error while exporting my schema and then import it into a new database. My Exporting System is an Oracle Linux 7 with 19c Database and the importing system is Oracle Linux 8 with 21c XE. When i import the schema with impdp i receive the error:

impdp system/password@localhost/xepdb1 full=y directory=data_pump_dir dumpfile=test.dmp

ORA-39001: ivalid argument
ORA-39000: incorrect specification of dump file
ORA-31619: invalid dump file "opt/oracle/admin/XE/dpdump/CC96F85...01/test.dmp"
ORA-27072: File-I/O-Error
Linux-x86_64 Error: 25: Inappropriate ioctl for device
Additional information: 4
Additional information: 1

show us which `impdp` command are you executing ? It looks like you either don't have a database directory for that location, or the privileges are not right. Although innapropiate ioctl for device implies that the datapump file is corrupted — Roberto Hernandez, Oct 05 '21 at 07:51
how did you transfer the dmp file from the source server to the target server ? — Roberto Hernandez, Oct 05 '21 at 07:55
did you create the directory `data_pump_dir` ? if so, how did you do it ? — Roberto Hernandez, Oct 05 '21 at 07:57
yes. i also checked the tablespace 'TEMP' and resizes it to 512MB, the dmp file only has arround 100mb — Ivan1986, Oct 05 '21 at 08:01
run this command `df -h /opt/oracle/admin/XE/dpdump/CC96F85...01/` and let us know how much space do you have there — Roberto Hernandez, Oct 05 '21 at 08:07
I believe you have the datapump file corrupted. That might happen when the transfers are done without using binary mode — Roberto Hernandez, Oct 05 '21 at 08:10
YES. I checked the dmp file and saw it has 0kb. So it was corrupted. I dont know why. I exported again and now the impdp works !!! — Ivan1986, Oct 05 '21 at 08:12
I will put this as an answer, please accept it, as then others can benefit from it — Roberto Hernandez, Oct 05 '21 at 08:45

score 1 · Accepted Answer · answered Oct 05 '21 at 08:46

As stated in the comments

When you got the error Inappropriate ioctl for device , Oracle is not responsible, as the error is coming from Linux.

Most of the times due to:

The datapump file is corrupted.
The file is not not a valid datapump file
The datapump file is empty.

Oracle Datapump impdp Inappropriate ioctl for device

1 Answers1