Forum OpenACS Q&A: Can't create tablespace in Oracle
SVRMGR> connect internal; Connected. SVRMGR> create tablespace oacs datafile '/ora8/m02/oradata/ora8/oacs01.dbf' size 50M autoextend on next 10M maxsize 300M extent management local uniform size 32K; create tablespace oacs4 * ORA-01119: error in creating database file '/ora8/m02/oradata/ora8/oacs01.dbf' ORA-27040: skgfrcre: create error, unable to create file Linux Error: 13: Permission denied
Hope this helps.
SVRMGR> exit joeuser:~$ su - Password: ************ root:~# mkdir -p /ora8/m02/oradata/ora8/ root:~# chown joeuser.web /ora8/m02/oradata/ora8 root:~# chmod 775 /ora8/m02/oradata/ora8 root:~# exit joeuser:~$I did get around the problem by changing permissions on the directory to 777 just to complete this step, but now have problems that suggest errors with jvminst. So looks like starting over is the next step. Thanks.
The OACS installation instructions are:
root:~# mkdir /ora8 root:/ora8# cd /ora8 root:/ora8# mkdir -p m01 m02 m03/oradata/ora8 root:/ora8# chown -R oracle.dba /ora8 root:/ora8# exit
As you can see, this is taken from this page http://openacs.org/doc/openacs-4/oracle.html and there is no mention that this directory should be joeuser.web since it's the oracle directory!
Note: The above mention refers to /ora8/m03 but it's the same as using m02.
Permissions 777 poses a security risk that I wouldn't be willing to take .