Serviceguard for oracle10g -NO RAC

[Abdul Wahab]

Hello,
I am given the task to install serviceguard for a two node cold cluster of Oracle 10g using serviceguard.Unfortunately i am not able to find any documents which could help me in this direction. There are many docs for 10g RAC. But i want a single instance oracle installation with service guard. Can some one point me where to start (doc url) and study this configuration i need to set up.Installation manual for this?
Thanks

[Steven E. Protter]

Shalom,

http://docs.hp.com/en/T1859-90048/ch02.html

See the master document.

http://docs.hp.com/en/T1859-90048/ch02s30.html
http://www.docs.hp.com/en/T1859-90038/ch02s21.html

Note that newer versions of RAC have their own clustering built in. Serviceguard may not be necessary at all, depending on your needs.

SEP

[Duncan Edmonstone]

I'm going to assume you already know how to configure Serviceguard itself and have a good understanding of Oracle.

Because if you don't then attempting to cluster Oracle yourself without the training/experience is a good way of getting worse availability than you would from not having a cluster at all!

Assuming you know Serviceguard and Oracle already, simply ensure that the Enterprise Cluster Master Toolkit (T1909BA) is installed on your system, then look in the directory /opt/cmcluster/toolkit/oracle - you will find the files you need plus instructions to configure the necessary Serviceguard package for Oracle there.

If you don't know Serviceguard, I'd advise you to either
a) Take a training course -or-
b) Get a consultant to come in and do the clustering work.

If you're really going to insist on doing the work yourself with no training/experience then the *minimum* you should do is read the Serviceguard manual cover-to-cover:

http://docs.hp.com/en/ha.html#Serviceguard

HTH

Duncan

[Abdul Wahab]

Hello Steven,
I have clearly mentioned even in subject that this is no RAC. I would be grate ful if you could link me to similar documents which talk about installing single instance 10g db.

Hello ducan,
I have good understanding of oracle clusterware and i have some on hands on experience on already installed serviceguard with oracle 10g db.
This time i just want to install the whole thing myself. For that i need some step by step documents for installing. Problem is I can only locate docs for installing 10g RAC. but i dont want RAC. I want to install single instance running on one node at a time.
Any guidance?

[Duncan Edmonstone]

ANdul,

then as I said:

"Assuming you know Serviceguard and Oracle already, simply ensure that the Enterprise Cluster Master Toolkit (T1909BA) is installed on your system, then look in the directory /opt/cmcluster/toolkit/oracle - you will find the files you need plus instructions to configure the necessary Serviceguard package for Oracle there."

Everything you need to do is described there

HTH

Duncan

[Abdul Wahab]

DuNcan,
I want to know how to prepare everything before i go for installation. Once i know everything theoretically and know how to proceed then only I will buy required HP products. Is there some place on internet where i can view these instructions u mention which will be available after tool kit installation?
Abdul

[Duncan Edmonstone]

Abdul,

No unfortunately there isn't... I'm loath to post the README here myself as if HP choose not to make it publicly availble to those who haven't purchased the product I don't think I can arbitrarily decide to post it myself.

But the Enterprise Cluster Master Toolkit isn't rocket science - its basically just a set of shell scripts which integrate Oracle into a Serviceguard package.

All you really have to do is add some parameters into a config file (ORACLE__SID, ORACLE_HOME, listener name, etc.)

With Serviceguard, the application integration isn't really the hard bit - as Clay pointed out on the other thread you posted into - it's setting up hosts and infrastructure for HA - and there's no quick cheat sheet for that...


HTH

Duncan

[Duncan Edmonstone]

ACtually what just occurred to me is that the Oracle toolkit follows the same rough format as all the other toolkits, and you can download sample toolkits in the Serviceguard developers toolbox here:

http://h20293.www2.hp.com/portal/swdepot/displayProductInfo.do?productNumber=SGDTOOLBOX

So take a look at that and you'll get an idea of the structure of the Oracle toolkit.

HTH

Duncan

[Abdul Wahab]

As I understand, the tool kit will lay out the instructions of how to configure oracle services within the service guard package.
But what about the planning phase of such installation. I mean how to go about doing oracle installation with SG installed? its disks preperation , how should the logical volumes etc. be created for such installation. where should the oracle binaries go.Things like that.I am sure thats not mentioned in the toolkit files. There must be a hp document which steps you through installing the whole oracle thing with SG, just like we have for oracle10gRAC or SAP.
I need THAT document.

[Steven E. Protter]

Sorry blew the original search.

Much easier without RAC.

http://h41156.www4.hp.com/education/upload/th/en/u8601s.pdf

This is really very simple.

Move your startup sequence/scripts to the serviceguard cluster control scripts.

When a package fails over it needs to activate the volume group the data sits on, the shared storage that SG requires.

SEP

[Abdul Wahab]

Steven,
The link you gave me is just outlining a training course!
by now i have understood the funda behind how thsi works but still need a good document to start working on it..