Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2008
    Posts
    14

    Unanswered: Oracle Installation Permissions Problem

    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
    Code:
       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/
    Code:
    2 drwxrwx---   3 oracle   oinstall     512 Jan 23 16:16 10.2.0

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

    ls -ls $ORACLE_BASE/product/10.2.0/db (i.e. $ORACLE_HOME)
    Code:
       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 oracleinstall 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

  2. #2
    Join Date
    Jan 2008
    Posts
    6
    does the unix user belongs to oinstall group???

  3. #3
    Join Date
    Jan 2008
    Posts
    14
    Hi,

    No the UNIX user does not belong to the oinstall group. The only user that belongs to the oinstall group is the oracle user that i used to install oracle.

    The user i would like to connect with is not part of the oinstall or dba groups.

  4. #4
    Join Date
    Jan 2004
    Posts
    370
    You say you get a permission denied error but you don't post the full error stack.

    If you can only run it as the oracle owner then the suid bit probably isn't set on the oracle executable.

    cd $ORACLE_HOME/bin
    chmod 6751 oracle

    .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •