bash-3.2$ impdp system/***** directory=import_dir nologfile=y dumpfile=exp_swx_20092012.dmp full=y
ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31640: unable to open dump file "/USwitch/exportdump/exp_swx_20092012.dmp" for read ORA-27054: NFS file system where the file is created or resides is not mounted with correct options Additional information: 3 Additional information: 18
While trying to import a dumpfile from an NFS mount point via impdp in Oracle 11g 11.2.0.3 you get below error
Solution : I solved this issue using a dual approach. the 2nd step is one I got from searching on the internet but the directory permission i discovered after a lot of trial and error methods.
1. Give full permission to the import directory from OS. Suppose the directory which you created from the database was called import_dir . Then check location of directoru from view dba_directories and give full permission to it.
SQL> select * from dba_directories; $ chmod 777 /USwitch/exportdump
Unmount and Mount the NFS file system again.
2. Set below parameter in init.ora file and then bounce database
event=’10298 trace name context forever, level 32′
Now try import again. If running RAC use nologfile=y parameter
bash-3.2$ impdp system/sys123 directory=import_dir nologfile=y dumpfile=exp_swx_20092012.dmp full=y
