In this post, we are going to understand various groups and users that should be created when Configuring Oracle GRID and Oracle Database with different users.

Create separate users for the Grid Home(gi_home) and Oracle Database Home (db_home) binaries
  • The gi_home user (ex: grid) has as its Primary Group the 'oinstall' group.Other essential OS groups assigned to it are: asmadmin (OSASM) and asmdba (OSDBA).Can also be part of the asmoper (OSOPER) group, but is not mandatory.           Example: uid=501(grid) gid=501(oinstall) groups=501(oinstall),502(dba),504(asmadmin),506(asmdba),507(asmoper)

  • The db_home user (ex: oracle) has as its Primary Group the 'oinstall' group also. Other essential OS groups assigned to it are: asmdba (OSDBA) and dba (OSDBA for the database). Can also be part of the oper (OSOPER) group, but is not mandatory.   Example: uid=502(oracle) gid=501(oinstall) groups=502(dba),506(asmdba)

  • The Oracle binary for the gi_home (gi_home/bin/oracle) must be owned by the gi_home software owner and be part of the 'oinstall' OS group. Also its permissions should be 6751 (-rwsr-s--x)
   Example:  -rwsr-s--x   1 grid     oinstall 220419496 Apr 14 15:22 /grid/app/11.2.0.3/grid/bin/oracle
  • The Oracle binary for the db_home (db_home/bin/oracle) must be owned by the db_home software owner and be part of the 'asmadmin' (OSASM) OS group. 

   Also its permissions should be 6751 (-rwsr-s--x)
   Example:  -rwsr-s--x   1 oracle   asmadmin 249144896 Apr 17 14:11 /orahome/app/oracle/11.2.0.3/db_1/bin/oracle
  • The ASM disks must be owned by the gi_home software owner and be part of the 'asmadmin' OS group. 

   Also their permissions must be 660 (rw-rw----)