ORA-01119 , ORA-27040 , Linux Error : 13: while adding a datafile

Problem
 

SQL> ALTER TABLESPACE TRAIDX2 ADD DATAFILE  '/usr1/tradata/traidx2_01a.dbf' size 1000M;

ALTER TABLESPACE TRAIDX2 ADD DATAFILE

*

ERROR at line 1:

ORA-01119: error in creating database file '/usr1/tradata/traidx2_01a.dbf'

ORA-27040: skgfrcre: create error, unable to create file

Linux Error: 13: Permission denied

 
Solution
 
This might be due to the in accessibility of the file system /usr1 to oracle user
 

connect as oracle and try to create  one empty file in /usr1

 

$cd /usr1

 

$touch a.txt

touch: creating `a.txt': Permission denied

 

 

Connect  as ‘root’ and change the owner and group of the file system /usr1

 

# ls –lrt

 

drwxr-xr-x    3 oracle   dba         12288 Jan  3 12:22 archive

drwxr-xr-x    6 root     root         4096 Jan  3 12:38 usr1

 

#chown oracle /usr1

#chown dba /usr1

 

or

 

#chown oracle:dba  /usr1

 

 

Now try to create the tablespace.