1 Reply Latest reply: Oct 28, 2013 3:13 AM by Manu Alphonse RSS

    Who should own oraInventory when you have role separation (grid and oracle) ?

    GarryB

      Grid Infrastructure version: 11.2.0.4

      Platform : Oracle Linux 6.3

       

      For role separation, we have created grid and oracle users.

       

       

      grid     ----------> to manage Grid Infra which includes ASM

      oracle     ----------> to manage RDBMS

       

      GI will be installed under the mountpoint /grid

      RDBMS will be installed under the mountpoint /u01

       

      Who should be the owner of oraInventory in such a scenario ? grid or oracle user

       

      Where should oraInventory be placed ? Under /grid or /u01 mountpoint ?

        • 1. Re: Who should own oraInventory when you have role separation (grid and oracle) ?
          Manu Alphonse

          Who should be the owner of oraInventory in such a scenario ? grid or oracle user

           

          Better choose grid if you use role separation.

           

          Where should oraInventory be placed ? Under /grid or /u01 mountpoint ?

           

          As long as both oracle and grid users have rwx privilege on the inventory directory, you can place it on a OFA-Compliant or near OFA-Compliant location.

           

          I personally prefer /u01/app/oraInventory

           

          The permission should look like below

          $ ls -l /u01/app/oraInventory

          drwxrwx--- 6 grid oinstall 4096 Aug 13  2012 /u01/app/oraInventory

           

          Its better to se a central inventory for both GRID_HOME and ORACLE_HOME. Its easy for opatch auto to run smoothly with a properly configured central inventory.

           

          Both grid and oracle users must have the Oracle Inventory group oinstall as their primary group,so that each Oracle software installation owner (grid, oracle) can write to the central inventory.