Oracle installation possibilities in SG

[Sebastian Viudez Ortega]

We have a cluster composed by two rp5470
and one VA7100 connected to both nodes. We
need tu put in HA with SG three aplications
over Oracle 8.1.7 -two aplications with node A
as native and node B as adoptive and the other
whit the node B as native and the node A as
adoptive-.

We think is clear we need three oracle instances,
-one per application- each one in a diferent VG to
guarantee the application independence at
package SG failover, but we are not sure
how many Oracle products we need to install
and where. At the moment, We have
contemplate three diferents possibilities:

1.- To install the Oracle product only one time
in one LVM VG shared-read from the two nodes. This VG out of SG control. I am not completely
sure if this stage is possible or we would have any problem with it.

2.- To install the Oracle product two times, one
per node, in the internal disk of each node or in two
LVM VG at the VA7100 -one for each node-. These two VG's out of SG control.

3.- To install the Oracle product three times, one
per application, in the same VG that the application.
These three VG's controled by SG. This possibility seems to give us the larger degree of freedom and availability of the applications, perhaps (???) with a major cost in administration.

Any one have any experience with a similar case?

Thank you in advance.

S. Viudez

[melvyn burnard]

Option two is your answer.

Option one is not a good idea, and option 3 is not required, unless you wish to run each instance on a different Oracle version.

[Justo Exposito · Accepted solution]

Hi Sebastian,

We have installed the second option and with this we can have different specifications in both nodes for the pakages and for Oracle. This permits us to change the Oracle version or to apply patches to Oracle without stop it.

I think that this is the best option.

Best Regards,

Justo.