Home » Infrastructure » Unix » Oracle Installation Permissions Problem (10GR2)
Oracle Installation Permissions Problem [message #295820] Wed, 23 January 2008 10:42 Go to previous message
ziggy25
Messages: 206
Registered: July 2005
Senior Member
I am trying to install Oracle and everything works fine all the way to the end of the installation.

The problem i have is the permissions allocated to the files and directories in the $ORACLE_HOME directory. When i installed oracle i set umask to 022. This resulted in the following directory format


ls -ls $ORACLE_BASE
   2 drwxr-x---   3 oracle   oinstall     512 Jan 23 16:30 admin
   2 drwxr-xr-x   3 oracle   oinstall     512 Jan 23 16:32 oradata
   2 drwxrwx---   3 oracle   oinstall     512 Jan 23 16:16 product



ls -ls $ORACLE_BASE/product/
2 drwxrwx---   3 oracle   oinstall     512 Jan 23 16:16 10.2.0




ls -ls $ORACLE_BASE/product/10.2.0
drwxr-x---  60 oracle   oinstall    1024 Jan 23 16:30 db



ls -ls $ORACLE_BASE/product/10.2.0/db (i.e. $ORACLE_HOME)
   2 drwxr-x---   4 oracle   oinstall     512 Jan 23 16:20 OPatch
   2 drwxr-x---   7 oracle   oinstall     512 Jan 23 16:17 assistants
  12 drwxr-xr-x   2 oracle   oinstall    5632 Jan 23 16:22 bin
   2 drwxr-x---   3 oracle   oinstall     512 Jan 23 16:20 cdata
   2 drwxr-x---   6 oracle   oinstall     512 Jan 23 16:29 cfgtoollogs
   2 drwxr-x---   4 oracle   oinstall     512 Jan 23 16:17 clone
   2 drwxr-x---   2 oracle   oinstall     512 Jan 23 16:20 config
   2 drwxr-x---   6 oracle   oinstall     512 Jan 23 16:17 crs
   2 drwxr-x---   7 oracle   oinstall     512 Jan 23 16:20 css
   2 drwxr-x---  10 oracle   oinstall     512 Jan 23 16:20 ctx
   2 drwxr-x---   2 oracle   oinstall     512 Jan 23 16:32 dbs
   2 drwxr-x---   3 oracle   oinstall     512 Jan 23 16:17 demo
   2 drwxr-x---   3 oracle   oinstall     512 Jan 23 16:17 diagnostics
   2 drwxr-x---   3 oracle   oinstall     512 Jan 23 16:17 has
   2 drwxr-x---   7 oracle   oinstall     512 Jan 23 16:22 hs
   2 drwxr-x---   5 oracle   oinstall     512 Jan 23 16:22 install
   2 -rw-r-----   1 oracle   oinstall      38 Jan 23 16:17 install.platform
   2 drwxr-x---   2 oracle   oinstall     512 Jan 23 16:22 instantclient32
   2 drwxr-x---  12 oracle   oinstall     512 Jan 23 16:22 inventory
   2 drwxr-x---   7 oracle   oinstall     512 Jan 23 16:17 javavm
   2 drwxr-x---   4 oracle   oinstall     512 Jan 23 16:20 jdbc
   2 drwxr-x---   7 oracle   oinstall     512 Jan 23 16:20 jdk
   4 drwxr-x---   2 oracle   oinstall    1536 Jan 23 16:20 jlib
   2 drwxr-x---   3 oracle   oinstall     512 Jan 23 16:17 jre
   2 drwxr-x---  13 oracle   oinstall     512 Jan 23 16:20 ldap
  12 drwxr-x---   3 oracle   oinstall    5632 Jan 23 16:22 lib
   8 drwxr-x---   4 oracle   oinstall    3584 Jan 23 16:22 lib32
   2 drwxr-x---   3 oracle   oinstall     512 Jan 23 16:30 log
   2 drwxr-x---   6 oracle   oinstall     512 Jan 23 16:17 md
   2 drwxr-x---   2 oracle   oinstall     512 Jan 23 16:17 mesg
   2 drwxr-x---   7 oracle   oinstall     512 Jan 23 16:20 mgw
   2 drwxr-x---  13 oracle   oinstall     512 Jan 23 16:22 network
   2 drwxr-x---   6 oracle   oinstall     512 Jan 23 16:17 nls
   2 drwxr-x---  15 oracle   oinstall     512 Jan 23 16:22 oc4j
   2 drwxr-x---   6 oracle   oinstall     512 Jan 23 16:17 odbc
   2 drwxr-x---   5 oracle   oinstall     512 Jan 23 16:17 olap
   2 drwxr-x---   7 oracle   oinstall     512 Jan 23 16:20 opmn
   2 -rw-r--r--   1 oracle   oinstall      61 Jan 23 16:16 oraInst.loc
   2 drwxr-x---   4 oracle   oinstall     512 Jan 23 16:17 oracore
   2 drwxr-x---   8 oracle   oinstall     512 Jan 23 16:17 ord
   2 drwxr-x---   7 oracle   oinstall     512 Jan 23 16:20 oui
   2 drwxr-x---   4 oracle   oinstall     512 Jan 23 16:17 owm
   2 drwxr-x---   6 oracle   oinstall     512 Jan 23 16:17 perl
   2 drwxr-x---   7 oracle   oinstall     512 Jan 23 16:17 plsql
   2 drwxr-x---   8 oracle   oinstall     512 Jan 23 16:17 precomp
   2 drwxr-x---   7 oracle   oinstall     512 Jan 23 16:20 racg
   2 drwxr-x---  14 oracle   oinstall     512 Jan 23 16:22 rdbms
   2 drwxr-x---   4 oracle   oinstall     512 Jan 23 16:20 relnotes
  20 -rwxr-xr-x   1 oracle   oinstall    9549 Jan 23 16:22 root.sh
   0 -rwxr-xr-x   1 oracle   oinstall       0 Jun  7  2005 root.sh.old
   2 drwxr-x---   3 oracle   oinstall     512 Jan 23 16:17 slax
   2 drwxr-x---   3 oracle   oinstall     512 Jan 23 16:17 sqlj
   2 drwxr-x---   9 oracle   oinstall     512 Jan 23 16:20 sqlplus
   2 drwxr-x---  13 oracle   oinstall     512 Jan 23 16:20 srvm
   2 drwxr-x---  13 oracle   oinstall     512 Jan 23 16:20 sysman
   2 drwxr-x---   3 oracle   oinstall     512 Jan 23 16:17 tg4ifmx
   2 drwxr-x---   3 oracle   oinstall     512 Jan 23 16:17 tg4ingr
   2 drwxr-x---   3 oracle   oinstall     512 Jan 23 16:17 tg4sybs
   2 drwxr-x---   3 oracle   oinstall     512 Jan 23 16:17 tg4tera
   2 drwxr-x---   4 oracle   oinstall     512 Jan 23 16:17 uix
   2 drwxr-x---   3 oracle   oinstall     512 Jan 23 16:17 wwg
   2 drwxr-x---   6 oracle   oinstall     512 Jan 23 16:19 xdk


Now everything works correctly if im using the oracle:oinstall user (i.e. the user that installed oracle). If i try to run sqlplus as a different unix user i get permission denied errors.

The permission denied errors are as a result of the above permissions not allow other users execute permissions. How can i resolve this? Is it safe to just do a
chmod -R 755 on $ORACLE_BASE or is there a better way to fix it?

My other question is i thought that setting umask 022 was the correct setting. Are those the permissions you would expect from a succesffull installation?

Thanks
 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Date formatting in unix shell script
Next Topic: start owb mappings from unix
Goto Forum:
  


Current Time: Fri Apr 26 22:06:09 CDT 2024