(Disclaimer: I'm not an Oracle expert, I'm a sysadmin assisting our DBAs with this issue)
So this is a real head scratcher. We're rebuilding an Oracle analysis cluster after a major storage hardware failure. There's a shared staging iSCSI mount that's set up to be shared between all the compute nodes and set up through multipath/ASM as an OCFS2 partition. When we attempt to load the previous backups from the staging partition, we get the following error:
Import: Release 22.214.171.124.0 - Production on Thu Jul 13 09:53:46 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Password:Connected to: Oracle Database 11g Enterprise Edition Release 126.96.36.199.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31619: invalid dump file "/u01/app/oracle/data/data_pump_dir/TEST.DMP"
ORA-27072: File I/O error
Linux-x86_64 Error: 22: Invalid argument
Additional information: 4
Additional information: 1
Additional information: -1
The head scratcher is that:
1. We attempted this with one of the backups and it failed, so we ended up making our own test dump file to further test to make sure it wasn't the backup file that was bad.
2. This error ONLY when loading files from the OCFS2 partition. I set up a second iSCSI share that was just formatted as ext4 and impdp loads the dump file just fine.
3. We've deleted and recreated the OCFS2 partition with several different cluster sizes and whatnot and we always get the same error back.
4. I can read and write to the filesystem on the staging partition just fine.
File permissions are as follows:
-rw-r----- 1 oracle oinstall 184320 Jul 13 10:17 TEST.DMP
System is Oracle Linux 6.8 (clone of RHEL/Centos)