2 Replies Latest reply: Jan 11, 2013 4:25 PM by 984420 RSS

    Can I have one ORACLE_BASE for GI and RDBMS home ?

    Kavanagh
      GI and RDBMS Version: 11.2.0.3
      Platform : OEL 6.3 (64 Bit)

      For role separation, I am creating grid and oracle users

      I am planning my Grid Infra home to be
      /u01/app/11.2.0.3/grid
      and RDBMS home to be
      /u01/app/oracle/product/11.2.0.3/dbhome_1
      During GI installation , I have to specify an ORACLE_BASE. I am thinking of specifying that to be
      /u01/app
      Can I use this same ORACLE_BASE for RDBMS home installation as well ?
        • 1. Re: Can I have one ORACLE_BASE for GI and RDBMS home ?
          Sebastian Solbach -Dba Community-Oracle
          Hi,

          if you plan for role seperation, you should specify different ORACLE_BASE for rdbms and GI installation.
          One of the reasons is that ADR will save files under ORACLE_BASE/diag with the user rights of the corresponding owner.
          If they are different, there may be access/write problems under this tree.

          Furthermore ORACLE_BASE should not be in the path of the GI installation.
          GI installation will change the path to GI_HOME to root user priviledges.
          You neither want to have ORACLE_BASE only accessible by root or have a directory higher up the pass with less priviledges than root, because this poses a security risc.

          Regards
          Sebastian
          • 2. Re: Can I have one ORACLE_BASE for GI and RDBMS home ?
            984420
            It's better to have separate ORACLE_BASE for GI and RDBMS installation. Also, please make sure that RDBMS shouldn't contain GI base in it's path. In one of the installation we had situation and we had lot's of permission issue.
            For example ORACLE_BASE for:
                GI Home: /u01/app/grid
                RDBMS Home: /u01/app/oracle
            Edited by: Oracle.DBA on Jan 11, 2013 2:18 PM