This content has been marked as final. Show 3 replies
Unless you have different version requirements (220.127.116.11 vs 18.104.22.168), 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.
should I have only one ORACLE_HOME for all the 3 the rdbmsUse one ORACLE_HOME for your dbses. Just keep it simple.
or having ORACLE_HOME for each one of them?
BTW Current Exadata deliveries by ACS have the following oracle homes.
Should i have only one disk group named DATA for exampleBy 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
or having for each database its own diskgroup?