This discussion is archived
3 Replies Latest reply: Apr 17, 2012 6:07 AM by Doug Utzig RSS

Exadata ORACLE_HOME question

Yoav Newbie
Currently Being Moderated
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 Oracle ACE
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Also, applications that may have different patching requirements should be in separate ORACLE_HOMEs.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points