Date: Wed, 1 Oct 2008 14:23:42 -0400
It's different for everybody. In my case I might have 20 databases on each node and the ability to fail each individually between the nodes. If they're all the same Oracle version then your solution would require 20 different oracle homes with all the hassles of patching etc that comes with that. No one solution is perfect. You have to pick one that has the least problems for you. They all have some amount of problems. IMO of course.
On Wed, Oct 1, 2008 at 2:20 PM, Matthew Zito <mzito_at_gridapp.com> wrote:
> Having an Oracle_home on each node is ill-advised in my opinion. It is
> too easy, and I have seen it happen far too many times, that something
> happens to the passive node's ORACLE_HOME that is only discovered when a
> failover event occurs. Having one ORACLE_HOME that is on the SAN and shared
> between nodes is ideal