Wednesday, February 6, 2019

Oracle Database 11.2 -- ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

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';

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: