ServiceGurad Cluster for Linux

[Earng]

Can I install Oracle 9i in 2 node before installation and configuration ServiceGurad Cluster? I heard that if do like this maybe oracle data file and control file will be corrupt.

[Steven E. Protter]

Shalom,

You can install Oracle software prior to installing Serviceguard. You just need a plan to properly set up the data that is on shared storage so its not overwritten.

The Oracle control files need to be on shared storage, and should not be located in the /etc/cmcluster folder.

If anyone has gotten data corruption or control file loss, its due to not thinking prior to laying out the structure of the shared storage.

You should complete san surfer and driver upgrades and storae setup before installing Oracle or Serviceguar for Linux.

SEP

[A. Clay Stephenson]

You can do it in either order and that would have no effect on whether or not your data will be corrupted.

One of the big decisions you should make is if your Oracle binaries will be installed on both nodes and only the data will be shared or if the binaries and data will be tied to your package. Most people install the binaries on both nodes but I prefer to have a dedicated set of binaries associated with each package, a dedicated listener, and, of course, the Oracle instance itself.

[Earng]

If it 2 nodes can see share storage data already. Can I install oracle server ?
I didn't use oracle RAC.
I would like to make sure me can install oracle9i server before install ServiceGuard Cluster for Linux.
Please give me any suggestion.

Thank you.

[A. Clay Stephenson]

The whole idea behind MC/SG is that either node can access the shared data although generally the access is confined to one node at any one time. It really make no difference whether of not you install Oracle first or MC/SG first; that is entirely up to you. However, it actually makes more sense to install MC/SG first because consider the case of adding a 2nd, 3rd, 4th, ... package to an existing cluster. In that case, the MC/SG installation would have been done long ago so that any application would then be installed after MC/SG. To my way of thinking, if you go ahead and install MC/SG then the first install of Oracle will be just like any others that may follow. In short, the code (inside your head) will not have to branch on the condition MC/SG installed yet or not.

[Serviceguard for Linux]

If you are going to install Oracle before installing Serviceguard, I'd suggest that you download the Serviceguard documentation (go to http://docs.hp.com/en/ha.html#Serviceguard%20for%20Linux look for the latest versions of the release notes and the "managing" manual) and read of the section on setting up the shared storage and the logical volumes. This setup instructions does not require SGLX but will greatly simplify things when you do bring up the cluster. This would be true for anyone who wanted to first install and application but be "SGLX ready".

You can also look over the Oracle toolkit release notes (http://docs.hp.com/en/ha.html#Serviceguard%20for%20Linux%20Toolkits) to see if there are any other suggestions there.

[Thomas J. Harrold]

Setup MC/SG, and your package, as well as your quorum server. Test your failover with an empty package first! Make sure that everything works as you expect it to.

Then add your applications to the cluster.

As to when you load the Oracle binaries: It doesn't matter.

-tjh