Re: file perms issue on linux install

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 01 Feb 2007 08:58:27 -0800
Message-ID: <1170349102.526964@bubbleator.drizzle.com>

kcboyes_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.

When I create a directory structure for an Oracle installation here's what I do:

mkdir -p /app/oracle
chown -R oracle:dba /app/oracle
chmod -R 775 /app/oracle

Then the following is in my .bashrc:

umask 022

ORACLE_BASE=/app/oracle/product
ORACLE_HOME=/app/oracle/product/10.1.0/db_1
ORACLE_SID=orcl

export PATH ORACLE_BASE ORACLE_HOME ORACLE_SID

If you've done the equivalent of this it is the way it should be.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Thu Feb 01 2007 - 10:58:27 CST