4 Replies Latest reply on Jul 23, 2013 1:16 AM by Srini Chavali-Oracle

    Ownership of datafiles after software installed by oracle:oinstall


      I know this has been discussed before, but I looked through those postings I did not see my question answered. My apologies if this topic is redundant to some.


      In installing 11gR2 on a new AIX 7.1 server I followed the guidelines for operating system user and group, so the Oracle software is owned by oracle:oinstall. I am about to create a database. If I leave things as they are the datafiles will be owned by oracle:oinstall. Using the group oinstall seems wrong to me and I am not sure what to do about it. In previous releases of database server the software was owned by oracle:dba, as were the datafiles. I would prefer that my datafiles still be owned by oracle:dba, not by oracle:oinstall. If I switch the primary group of the oracle user from oinstall to dba will it cause problems later when I install patches, or install the next version of Oracle database server? Would I have to switch the primary group back to oinstall before applying the patch? If I had it to do over again I would not have used oinstall and instead stuck with dba.


      Please tell me your experience with this subject.


      Thank you,