Oracle oinstall / dba membership & datafile permissions
628286Feb 25 2009 — edited Feb 25 2009Hi,
I've a query regarding filesystem privileges.
Per new Oracle setups, oinstall is the primary group membership - primarily for oracle inventory / installation files (e.g. Installation Guide for HP-UX Itanium 10.2):
/usr/sbin/useradd -g oinstall -G dba[,oper] oracle
Traditionally I would have always had oracle datafiles created under the DBA group (typically under the Oracle O/S user). Given the above group permissions, is it not implicitly assumed that all objects created under the oracle user will have the oinstall permissions (so all datafiles, logfiles, redologs), however having datafiles owned by a software installation group doesn't really make sense.
I don't see a usermod -u oracle -g dba post install of Oracle software, so thus all datafiles on new installs are oracle:oinstall. How come they are no longer oracle:dba (accepting that software itself should be owned by the oinstall group).
Thanks,
Conor.