Re: "sgadef.dbf" file's privileges and oracle's owner during install
Date: Mon, 30 Jan 95 19:59:58 -0500
Message-ID: <pS65K9m.briantc_at_delphi.com>
Pat Spinler <pats_at_coyote.ceramics.mot.com> writes:
>Whenever I start my database, the SGADEF.DBF file in $ORACLE_HOME/dbs
>always has its privledges set to:
>
> -rw-rw---- 1 pats dba 68 Jan 24 12:29 sgadefflex.dbf
>
>Whenever I do a startup, I end up doing a manual 'chmod' to add read
>privs for other, so that my clients can connect.
>
>Is there a way to get oracle to do this automatically when the database
>is started ?
I haven't read the whole of your posting but it sounds like one of a number of things is happening:
- Are you installing on a YP client?. Check your YP Master server to ensure the oracle2 userid is correct and not duplicated.
- Orainst tries to read the password file directly - have you tried fiddling e permissions on it?
- You aren't trying to install on an NFS mount are you?. This can be due to the password mismatch between server & client
If all else fails you can fix it in your current version:
<AS ROOT>
cd $ORACLE_HOME/bin
chown oracle2 oracle
chgrp dba oracle
chmod 4755 oracle
( The oracle executable MUST run set-uid to your oracle user)
BC * Teaching your grandmother to suck eggs * Received on Tue Jan 31 1995 - 01:59:58 CET