Shulou(Shulou.com)05/31 Report--

Editor to share with you the oracle data pump dump file storage nfs report ORA-27054 error how to do, I believe that most people do not know much, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Problem description: source side 10.2.0.4 destination side: 11.2.0.4 divide 1T storage and source side into a NFS on the destination side

Error: specify dump export as local file system, normal. Specifies that dump is exported to the nfs file system with an error.

The error message is as follows:

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31641: unable to create dump file "/ devotd_dpump/expdp_metadata_vspp_sun.dmp"

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

Additional information: 3

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

CAUSE

The NFS mount options seem to be incorrect. No specific setting was found to address this. The below options were tried but the same error was still encountered:

Mount options as per Note 781349.1-ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

Backup using RMAN into this problematic mount point was successful

Traditional export using exp to this problematic mount point was successful

Creation of a new datafile to this mount point was successful

Creation of a file from OS side to this problematic mount point was successful

Reboot of the NFS mount point made no difference

SOLUTION

The only solution which worked in this case was to set the below event which disables the mount point parameter checking:

Sqlplus / as sysdba

Alter system set events' 10298 trace name context forever, level 32'

After doing 10298 events, solve the problem.

The above is all the contents of this article "how to store nfs report ORA-27054 errors in dump file of data pump in oracle". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.