Re: Oracle 7 and UNIX permissions - Help

Gerard H. Pille (ghp_at_infosoft.be) wrote:

: Hello Lisa,
 

: Are you sure you have run 'root.sh' after installation? It might be that oracle (in
: $ORACLE_HOME/bin) hasn't got its setuid bit on.
: ls -l $ORACLE_HOME/bin/oracle should give something like
 

: -rws--x--x oracle dba ...... oracle
: ^

Thanks for your response. I checked all of the modifications that should have been made by root.sh and all appears okay. The permissions on the oracle binary are 6751, so that appears okay as well.

: Or your problem might be more basic: do the users, on login, execute oraenv, which sets
: up their environment for a specific $ORACLE_SID?

Unfortunately, the environment appears to be set appropriately. I can connect to the databases just fine when I've temporarily made the dbs files group writable when I'm a member of that group or when I've temporarily made the files world (!) writable.

If the setuid is actually setting the uid, is does seem odd that I don't have permission to access the files in dbs that are owned by oracle.

Any other thoughts on what I should look at are most humbly welcomed.

-elizabeth
: --
: Kind reGards
: \ / |
: X |
: / \ s
: Gerard
 

-- 
==================================================================
Elizabeth Bagley                PHONE:  209-278-3923
Systems Administator, CCMS      FAX:    209-278-4660
California State Univ., Fresno  http://www.csufresno.edu/Elizabeth