What the permission a datafile should be?(i19)

 I am trying to create a datafile in a directory and I keep
experiencing this problem:

>>
SQL> CREATE TABLESPACE snoopdogg DATAFILE
'/mydir/oracleowned/snoopdogg.dbf' SIZE 5M AUTOEXTEND ON NEXT 512K
MAXSIZE UNLIMITED online ;
CREATE TABLESPACE snoopdogg DATAFILE '/mydir/oracleowned/snoopdogg.dbf'
SIZE 5M AUTOEXTEND ON NEXT 512K MAXSIZE UNLIMITED online
*
ERROR at line 1:
ORA-01157: cannot identify data file 48 - file not found
ORA-01110: data file 48:
'/mydir/oracleowned/snoopdogg.dbf'
<<

Directory permissions:
>>
drwxrwxrwx   3 oracle   dba           512 Apr 20 13:36 oracleowned/
drwxrws---   5 sim      p002          512 Apr 19 17:03 mydir/
<<

What are the rules for permissions upon datafile dirs?

Oracle ver: 8.0.3
OS : solaris

Many Thanks
S.


Ans:

The rules I use are;

For database file directories aka (/mydir/oracleowned) should be 750 with
oracle owner and dba group. The data files themselves are OK at 640.

The other problem that can cause this is if the SUID has been lost from the
Oracle Executable $ORACLE_HOME/bin/oracle. Make sure that it is 4751 with
oracle owned and dba group. Check $ORACLE_HOME/orainst/root.sh to make sure
the permissions suggested are correct for your version. You should see the
unix chmod and chown permissions in the script.

Andrew
 

Hosted by www.Geocities.ws

1