When you use Data pump to import data in your database , you can see below error.
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "<Dump file path>" for read
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3
Here is Solution
Here are the mount options that need to be used for NFS volumes on Linux are:
rsize=32k, wsize=32k, hard, actimeo=0
Along with the error there are warning messages printed in the alert log with the mount options to be used.Sometimes you may need to do the following to allow datapump to work with NFS mounted files:
Set the event in the init.ora, to disable the mount point parameter checking:
event="10298 trace name context forever, level 32"
Note that the event 10298 skips all mount checks. Setting this event has to be done with care. Verify settings with your System Administrator to ensure no datafiles are corrupted
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "<Dump file path>" for read
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 3
Here is Solution
Here are the mount options that need to be used for NFS volumes on Linux are:
rsize=32k, wsize=32k, hard, actimeo=0
Along with the error there are warning messages printed in the alert log with the mount options to be used.Sometimes you may need to do the following to allow datapump to work with NFS mounted files:
Set the event in the init.ora, to disable the mount point parameter checking:
event="10298 trace name context forever, level 32"
Note that the event 10298 skips all mount checks. Setting this event has to be done with care. Verify settings with your System Administrator to ensure no datafiles are corrupted
No comments:
Post a Comment