[Linux-cluster] Oracle non-RAC database cluster

[Lon Hohberger]

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.

-- Lon