Re: file perms issue on linux install

From: Eberhard Niendorf <eberhard.niendorf_schrott_at_t-online.de>
Date: Fri, 02 Feb 2007 22:44:45 +0100
Message-ID: <eq0bcd$7ch$02$1@news.t-online.com>

kcboyes_at_gmail.com wrote:

> On Feb 1, 1:55 pm, Eberhard Niendorf <eberhard.niendorf_schr..._at_t-
> online.de> wrote:

>> kcbo..._at_gmail.com wrote:
>> > I've just installed Oracle 10gR2 on my redhat-based linux machine and
>> > seem
>> > to have a problem with file permissions. My ORACLE_BASE=/clientdata/
>> > oracle
>> > and here is the listing of that directory:
>>
>> > [kboyes_at_uberdev4 oracle]$ ls -al
>> > total 56
>> > drwxrwxr-x 7 oracle oinstall 4096 Jan 31 13:31 .
>> > drwxrwxr-x+ 21 root root 4096 Jan 31 12:47 ..
>> > drwxr-x--- 3 oracle oinstall 4096 Jan 31 13:31 admin
>> > drwxr-x--- 3 oracle oinstall 4096 Jan 31 13:32 flash_recovery_area
>> > drwxr-x--- 3 oracle oinstall 4096 Jan 31 13:31 oradata
>> > drwxrwx--- 6 oracle oinstall 4096 Jan 31 13:52 oraInventory
>> > drwxrwx--- 3 oracle oinstall 4096 Jan 31 13:28 product
>>
>> > I would have expected product to be r-w for other since the way it is
>> > now, ordinary users can't run things like sqlplus.
>>
>> > It doesn't make sense that ordinary users would need to be in the
>> > oinstall group.
>>
>> > Any help would be appreciated.
>> > Thank,
>> > Kevin.
>>
>> This is a new security feature on all Unix-OS... It's documented in the
>> install manuals and You only need to execute a script as follows:
>> sh $ORACLE_HOME/install/changePerm.sh
>>
>> Eberhard Niendorf

> 
> Sounds like the right thing except I don't have that script in my
> install.
> Also, it isn't mentioned in my Installation Guide (B15660-02) (10g R2
> for Linux x86).
> 
> Thanks though
> Kevin.

Sorry, I made a mistake. The script changePerm.sh comes with patchset 10.2.0.2 and 10.2.0.3. This script comes also with newer patchsets in 9iR2 and 10gR1. It is documented in the patchset READMEs. For 10.2.0.1 there are the patch 4516865 which addressed the problem, but I would recommend the patchset 10.2.0.3.

If You have no Oracle support You have to fix it manually. You cannot influence the Oracle install process by setting umask etc. Without Oracle support You can try the following to use sqlplus: find $ORACLE_HOME -type d | xargs chmod o+rx chmod o+r $ORACLE_HOME/lib/libclntsh.so.10.1 chmod o+rx $ORACLE_HOME/bin/sqlplus

Eberhard Niendorf Received on Fri Feb 02 2007 - 15:44:45 CST