Problem
While performing database export to an NFS share using Oracle Data Pump Export expdp utility, you get errors similar to below:
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "exp.dmp"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
SVR4 Error: 2: No such file or directory
Solution
The cause is probably incorrect mount options being used. Also, the options maybe correct but the order still invalid.
Oracle documentation suggests the options used in the correct order like:
# mount -F nfs -o rw,bg,hard,rsize=32768,wsize=32768,vers=3,forcedirectio,nointr,proto=tcp,suid host:/folder1 /folder2
If the problem still persists, you might want to disable mount options checking by using the command:
sqlplus / as sysdba
alter system set events '10298 trace name context forever, level 32';
alter system set events '10298 trace name context forever, level 32';
To enable mount option checking back:
alter system set events '10298 trace name context off';
Reference:
- Doc ID 1518979.1 DataPump Export (EXPDP) Fails With Errors ORA-39001 ORA-39000 ORA-31641 ORA-27054 ORA-27037 When The Dump File Is On NFS Mount Point
- Doc ID 781349.1 ORA-27054: NFS File System Where the File is Created or Resides is Not Mounted With Correct Options
- Doc ID 359515.1 Mount Options for Oracle files for RAC databases and Clusterware when used with NFS on NAS devices
No comments:
Post a Comment