Oracle Move Tablespace Datafile to other mount point or location (ORA-27054: NFS file system where the file is created or resides is not mounted)

• Move Tablespace Datafile

SQL> alter database move datafile '/u01/oradata/data01.dbf' to '/u02/oradata/data01.dbf';

Problem: ORA-27054: NFS file system where the file is created or resides is not mounted

SQL> /
alter database move datafile '/u01/oradata/users01_rename.dbf' to '/u02/oradata/users01.dbf'
*
ERROR at line 1:
ORA-01119: error in creating database file
'/u02/oradata/users01.dbf'
ORA-27054: NFS file system where the file is created or resides is not mounted
with correct options
Additional information: 3
Additional information: 2

Solution:

Setting then try move again

--Current
SQL> alter system set events '10298 trace name context forever, level 32';

--If you set the event with scope=spfile, then same as with init.ora change,
--  you have to restart the instance for the event to be recognized.
SQL> alter system set events '10298 trace name context forever, level 32' scope=spfile;

If oracle datafile store in NetApp Storage using nfs, then /etc/fstab mountpoint parameter need to setting

# cat /etc/fstab
...
NAS1:/ORADATA /ORADATA nfs rw,bg,hard,vers=3,proto=tcp,timeo=600,rsize=262144,wsize=262144,nointr,actimeo=0

Documents :

ORA-27054 ERRORS WHEN RUNNING RMAN WITH NFS (Doc ID 387700.1)

Oracle Database on ONTAP (NetApp)