Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: File permissions upon datafile dirs?
Simeon,
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
Simeon Bailey wrote:
> Hey, :-)
> 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.
Received on Mon Apr 19 1999 - 23:21:31 CDT