3 Replies Latest reply: Apr 17, 2012 8:07 AM by Doug Utzig-Oracle RSS

    Exadata ORACLE_HOME question

    Yoav
      Hi,
      I would like to know if there is a best practice regarding ORACLE_HOME in exadata machine.
      If we are going to have 3 databases on quarter rack machine.
      one databse is going to use as staging database.
      The second is going to use as reporting database
      the thread one is going to be use as repository.

      Question one:
      ============
      I would like to get your advice if i should have only one ORACLE_HOME for all the 3 the rdbms
      or having ORACLE_HOME for each one of them.

      Question Two:
      ============
      Regarding the ASM disk groups , should i have only one disk group named DATA for example , or having for each database its own diskgroup

      Best Regards
        • 1. Re: Exadata ORACLE_HOME question
          andy.colvin
          Unless you have different version requirements (11.2.0.2 vs 11.2.0.3), it's best to keep everything in the same home. Also, I prefer to keep everything together in DATA and RECO. While it is possible to resize the diskgroups after the fact, it's a very time consuming and I/O-intensive process. What would happen if one database outgrew the space allocated to it, or if it was decided to place another database on the machine? These aren't problems if you keep with single DATA and RECO diskgroups.
          • 2. Re: Exadata ORACLE_HOME question
            tychos
            Hi Yoav,
            should I have only one ORACLE_HOME for all the 3 the rdbms
            or having ORACLE_HOME for each one of them?
            Use one ORACLE_HOME for your dbses. Just keep it simple.
            BTW Current Exadata deliveries by ACS have the following oracle homes.
            /u01/app/11.2.0.3/grid
            /u01/app/oracle/product/11.2.0.3/dbhome_1
            ..
            Should i have only one disk group named DATA for example
            or having for each database its own diskgroup?
            By default ACS will create the DATA, RECO and DBFS_DG disk groups just put you datafiles in DATA and use IORM to control resource usage
            between databases.
            Regards
            Tycho
            • 3. Re: Exadata ORACLE_HOME question
              Doug Utzig-Oracle
              Also, applications that may have different patching requirements should be in separate ORACLE_HOMEs.