Home » Infrastructure » Unix » Oracle Installation Permissions Problem (10GR2)
Oracle Installation Permissions Problem [message #295820] Wed, 23 January 2008 10:42 Go to next 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
Re: Oracle Installation Permissions Problem [message #295847 is a reply to message #295820] Wed, 23 January 2008 13:53 Go to previous messageGo to next message
umakishore
Messages: 5
Registered: January 2008
Junior Member
cd $ORACLE_HOME/install
Run changePerm.sh to change Permissions for Other users.
Umask should be set to 022 before Installation.
If you don't want to change Permissions, You can install Oracle Client in different oracle_home and use client Home to connect to Database.
Re: Oracle Installation Permissions Problem [message #295849 is a reply to message #295847] Wed, 23 January 2008 13:56 Go to previous messageGo to next message
ziggy25
Messages: 206
Registered: July 2005
Senior Member
Hi,

Thanks for your response. I did set umask to 022 before installation. I even closed the terminal and re-opened it for that change to take effect.

What exactly will that file do? what permissions will it set?

Thanks

ps. The database is 10G
Re: Oracle Installation Permissions Problem [message #295850 is a reply to message #295820] Wed, 23 January 2008 14:00 Go to previous messageGo to next message
umakishore
Messages: 5
Registered: January 2008
Junior Member
Look at RELAX_DIR_ALL and RELAX_FILE_PERM_LIST parameters in the changePerm.sh file
Re: Oracle Installation Permissions Problem [message #295852 is a reply to message #295850] Wed, 23 January 2008 14:08 Go to previous message
ziggy25
Messages: 206
Registered: July 2005
Senior Member
Hi,

It looks like i dont have that file in $ORACLE_HOME/install.

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


Current Time: Fri Mar 29 09:40:24 CDT 2024