How to configure Oracle in MCSG

[sinhass]

Can anyone tell me how to configure oracle in m/c service guard v11.14 2 node cluster.Or where I will get the manual. Its not there in the m/c service guard manual provided by docs.hp.com. Thanks a lot in advance.

[Sridhar Bhaskarla]

Hi,

This is one of the many implementations of serviceguard . So, you will not find documentation for it.

But oracle in serviceguard is a very common implementation. Basically you will need to create a package in serviceguard that takes care of actvating|deactivating the volume groups, mounting|unmounting the filesystems, adding|removing the floating IP and starting|stopping oracle processes. Read the serviceguard manual for details on doing so. YOu may have to take a class if this is your first serviceguard experience.

Basically you need to take care of the following in that order.

1. creating the basic cluster including configuring the system names, their network interfaces and the cluster parameters.
2. Add oracle as a package to it. This means adding oracle related volume groups and filesysetms, floating IP and the startup/shutdown scripts for oracle.

There is an example given in serviceguard manual

http://docs.hp.com/hpux/onlinedocs/B3936-90065/B3936-90065.html

If you try following that example, you can understand the theory behind it.

There was a oracle toolkit for Serviceguard sold by HP.

YOu could buy it to make your life easy. But still you require understanding of serviceguard.

http://software.hp.com/portal/swdepot/displayProductInfo.do?productNumber=B5139EA

-Sri

[Stuart Abramson_2]

Sridhar is correct.

Here is a "tip".

Create the basic cluster with shared volume groups and packages.

Install your Oracle on the package name. When Oracle asks you for your "hostname" give him the floating IP address hostname, not either of the two "physical hostnames". Oracle should think he is running on "floating hostname". Set up your references in tnsnames, listener.ora, etc, to point to the "floating hostname".

Set up your clients to on the desktops to point to the "floating hostnames".

[sinhass]

Thanks to Sridhar & Stuart for the reply. Actually I know how to configure MCSG but I was in dark about oracle config. Now its clear to me. Thanks again

[Jeff Schussele]

Hi,

Another common use of MC/SG when running an Oracle pkg is to set up monitoring such that if Oracle goes down or an important Oracle process such as the Listener stops, the monitoring will detect this & restart the process.
This is somewhat harder to properly set up, but can be worth it's weight in gold in a Production env. I believe the toolkit Sri mentions has examples of Oracle monitoring.

Rgds,
Jeff

[sinhass]

Hi Sri, Will it be possible to send the README file provided with that ECM Toolkit. Actually I just want to know more before doing that.

[Stephen Doud · Accepted solution]

The "Enterprise Cluster Master Toolkit" product number B5139DA is available
to help the system administrator implement various databases under control of
Serviceguard.

Acquire a Licent-to-use codeword for the product and swinstall it from the
Application CD Media. The files are placed in /opt/cmcluster/toolkits/. The
/opt/cmcluster/toolkits/oracle/ORACLE.sh template file should be copied to
the package directory. It is called by a Serviceguard package control script
to start, stop or monitor the Oracle application. It must be editted for
your specific Oracle environment. This document does not give specifics on
how to customize the ORACLE.sh template.

The remainder of this document provides a general overview of how to
configure the Oracle package.

1) Create the package template files for an Oracle package:
# mkdir /etc/cmcluster/orapkg
# cd /etc/cmcluster/orapkg

2) Create the package configuration and control templates
# cmmakepkg -p orapkg.config
# cmmakepkg -s orapkg.cntl

3) Edit the package configuration file, customizing it to your needs.

4) Edit the package control script, adding the resources that the Oracle
application will need to access. The following parameters may need to be
configured depending on the database needs.
(Note: some parameters show sample settings)

VG[0]="vg01"
LV[0]="/dev/vg01/lvol1"; FS[0]="/u01/"; FS_MOUNT_OPT[0]="-o rw"
LV[1]="/dev/vg01/lvol2"; FS[1]="/u01/"; FS_MOUNT_OPT[2]="-o rw"
FS_TYPE[0]="vxfs"
FS_TYPE[1]="vxfs"
FS_UMOUNT_COUNT=15
FS_MOUNT_RETRY_COUNT=0
CONCURRENT_VGCHANGE_OPERATIONS=1
CONCURRENT_DISKGROUP_OPERATIONS=1
CONCURRENT_FSCK_OPERATIONS=1
CONCURRENT_MOUNT_AND_UMOUNT_OPERATIONS=1
SERVICE_NAME[0]="oramon"
SERVICE_CMD[0]="/etc/cmcluster/orapkg/ORACLE.sh monitor"
SERVICE_RESTART[0]=""
IP[0]=""
SUBNET[0]=""


5) Edit the control script section labeled "function
customer_defined_run_cmds":

- Call the ORACLE.sh script with a "start" option.
- Add other commands as needed.

6) Likewise, edit the "function customer_defined_halt_cmds" section:
- Call the ORACLE.sh script with a "stop" option.
- Add other commands as needed.

7) Copy the package control script and ORACLE.sh to the adoptive node..

8) Add the package into the cluster:
# cmapplyconf -P orapkg.config

9) Test the package startup
# cmrunpkg orapkg

10) Halt the package and start it on the adoptive server

-sd

[sinhass]

SD thank u very much. I think now I am able to completely understand it. Thanks a lot once again.