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

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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s