[Linux-cluster] Oracle non-RAC database cluster
lhh at redhat.com
Mon Jul 24 21:00:24 UTC 2006
On Fri, 2006-07-21 at 08:54 -0400, Greg Forte wrote:
> In fact, yes, I have that exact configuration. I assume you intend to
> operate in an active-passive mode, in which case, everything seems to
> work fine (at least, I haven't had any problems since I got it all
> working). Active-active would be a bad idea, for hopefully obvious reasons.
> The biggest stumbling block was that you MUST set the hostname and
> ORACLE_HOSTNAME env var to the name of a "virtual" IP address that will
> always be associated with whichever machine is running oracle at the
> moment. And when starting the listener (though not the database,
> enterprise manager(s), or isqlplus, for some reason), you must
> temporarily change the node's hostname to that name (you can change it
> back as soon as the listener is started). Failure to do this during the
> install will cause you no end of grief later on, and there's no easy way
> to fix it afterwards (at least, I never found one).
There was a bugzilla open about this with a HOWTO and a resource-agent
for doing this. However, I closed it because Oracle 10gR2, as far as I
know, ships with at least active/passive capability built-in.
With 10gR1, that was not the case.
More information about the Linux-cluster