topic Re: SG steps in Operating System - HP-UX

SG steps

saqi — Thu, 01 Mar 2007 02:58:32 GMT

Hi All,

I am new to Serviceguard, I need to configure SG with one Oracle database package, Can any one tell me the steps in detail what i need to do? I have seen the PDF docs on docs.hp.com, but they are very lengthy.

Thanks in advance.

Re: SG steps

melvyn burnard — Thu, 01 Mar 2007 04:48:08 GMT

If you follow the managaing Serviceguard manual, it should provide ALL the detaio you need.
Also make sure you have the Oracle Toolkit in the Enterprise Cluster Master Toolkit, and use that for your database, again it details what you need to do.

Also please note, the product underwent a name change 3 years ago, it is no longer called MC/ServiceGuard.
The correct name is just Serviceguard

Re: SG steps

Stephen Doud — Thu, 01 Mar 2007 09:37:28 GMT

If you are not using the Enterprise Cluster Master toolkit, then the steps to implement an Oracle database would indeed be too lengthy to print here!
If you have a license to use the ECM toolkit, and have installed the product, you can locate it in /opt/cmcluster/toolkit/
Check ../oracle/README for instructions on how to implement the scripts.

Basically, you will create a standard package configuration file and control script, then in the customer_defined_... sections, point to the toolkit.sh to start/stop the database by way of the toolkit scripts.

See this site for more details about the product:
http://h20293.www2.hp.com/portal/swdepot/displayProductInfo.do?productNumber=T1909BA

Re: SG steps

A. Clay Stephenson — Thu, 01 Mar 2007 10:22:47 GMT

You are asking for detailed instructions for a very complex process -- that varies with every installation to some degree. There is a reason those documents are lengthy. You are basically asking how to do calculus when you know how to add, subtract, divide, and multlply. The answer is to study.

In any event, you aren't even asking the right question. Setting up ServiceGuard is relatively easy; it's the work you do to get to that point that's much more difficult. You first have to identify and address every single point of failure (power, HVAC, disks, network devices, ... ); only then are you ready for SG.

Re: SG steps

Sundar_7 — Thu, 01 Mar 2007 14:32:35 GMT

Clay is right. There is just too much detail involved to list here. But in a nutshell

1) Connect the power, network (private and public), fibre connections to the server (remember N+1 and no Single Point Of Failures)

2) Install the MC-Serviceguard product on both the machines and reboot

3) Tune your kernel for Oracle

4) Create Volume groups, Lvs and filesystems for Oracle binary and data

5) Install and configure Oracle on one mode in the Share disks

6) Run cmquerycl command and create the cluster ascii file

# cd /etc/cmcluster/
# cmquerycl -v -C cluster.conf -n node1 -n node2

7) Edit the cluster.conf and modify the cluster name at the very least.

8) create package directory ,create package conf and package script

# cd /etc/cmcluster
# mkdir oraclepkg
# cd oraclepkg
# cmmakepkg -p oraclepkg.conf
# cmmakepkg -s oraclepkg.cntl

9)# vi oraclepkg.conf

10) shutdown oracle, unmount filesystens, Deactivate all the volume groups and install the cluster ID

# vgchange -c y /dev/vgname

11) Edit package control script to include the package IP address, Package name, node names, volume group names, LV information

# vi /etc/cmcluster/oraclepkg/oraclepkg.cntl

12) Distribute the package directory to the other node

13) Check and apply the cluster/package conf

# cmcheckconf -v -C cluster.conf -P oraclepkg.conf
# cmapplyconf -v -C cluster.conf -P oraclepkg.conf

14) edit /etc/lvmrc and set AUTO_VG_ACTIVATE=0.

Ofcourse, I know I missed number of other details, like setting up the service or monitor for Oracle.

But this is the longest post I could type :-). If you have any specific questions, ask away

Sundar.

Re: SG steps

Abdul Wahab — Sun, 04 Nov 2007 03:03:05 GMT

Hello,
I am also given the task to install serviceguard for a two node cold cluster of Oracle 10g.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 and study this configuration i need to set up?
Thanks