Re: Oracle 7.1.4.1.10 can't connect after installation

dlincke_at_bandon.unisg.ch (David-Michael Lincke) wrote:  

>> Check the permissions on $ORACLE_HOME/bin/oracle. They should be
>> -rwsr-sr-x (which is 6755)
>> Note this sets user and group ID on execution. This is necessary in
>> order for you to access the datafiles owned by oracle. This is
>> normally set during the installation process.
>
>That was the exact problem. root.sh didn't set those permissions, though.
>It was only after relinking the oracle server that the permissions were
>set.
>
>Thanks a lot anyway,
>
>dave
>
>--
>David-Michael Lincke Institute for Information Management at USG
>EMail: dlincke_at_sgcl1.unisg.ch
>URL: http://www-iwi.unisg.ch/about/team/dal.html

Just to be accurate here I have to say that relinking would not correct the permissions. The make file provided for this (ORACLE_HOME/rdbms/lib/oracle.mk) both relinks and installs the kernel and related products (sqldba,exp,etc.). Doing "make -f oracle.mk oracle" merely relinks the oracle executable leaving it in the current directory with the wrong permissions. Doing "make -f oracle.mk install" removes the current executables from the bin dir., relinks new ones, moves them to bin dir. and sets correct permissions.

-- 
Ted Alexander (tealexan_at_ca.oracle.com)
Oracle Canada Technical Support