Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle oinstall / dba membership & datafile permissions

628286Feb 25 2009 — edited Feb 25 2009
Hi,

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 25 2009
Added on Feb 25 2009
1 comment
469 views