ORA-27054 when create datafiles on Shared Folder
Posted: 28. Jul 2010, 17:00
Host : Windows 7
Guest : Oracle Enterprise Linux 5
[oracle@el5_ora DBLINUX]$ cat /etc/fstab
/dev/VolGroup00/LogVol00 / ext3 defaults 1 1
LABEL=/boot /boot ext3 defaults 1 2
tmpfs /dev/shm tmpfs defaults 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0
/dev/VolGroup00/LogVol01 swap swap defaults 0 0
Temp /Temp vboxsf defaults 0 0
For a test, I want to create an Oracle 11g tablespace on a shared folder without having my vdi file growing. At the end of my test, I want to simply drop my tablespace and always keep same size for my VM.
Tablespace creation :
CREATE TABLESPACE data DATAFILE '/Temp/DBLINUX/data01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED;
ORA-01119: error in creating database file '/Temp/DBLINUX/data01.dbf'
ORA-27054: NFS file system where the file is created or resides is not mounted
with correct options
Any idea what are the "correct options" , please ?
Guest : Oracle Enterprise Linux 5
[oracle@el5_ora DBLINUX]$ cat /etc/fstab
/dev/VolGroup00/LogVol00 / ext3 defaults 1 1
LABEL=/boot /boot ext3 defaults 1 2
tmpfs /dev/shm tmpfs defaults 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0
/dev/VolGroup00/LogVol01 swap swap defaults 0 0
Temp /Temp vboxsf defaults 0 0
For a test, I want to create an Oracle 11g tablespace on a shared folder without having my vdi file growing. At the end of my test, I want to simply drop my tablespace and always keep same size for my VM.
Tablespace creation :
CREATE TABLESPACE data DATAFILE '/Temp/DBLINUX/data01.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED;
ORA-01119: error in creating database file '/Temp/DBLINUX/data01.dbf'
ORA-27054: NFS file system where the file is created or resides is not mounted
with correct options
Any idea what are the "correct options" , please ?