How to configure serviceguard for multiple oracle instance using Enterprise Cluster Master Toolkit

[Aungshuman Paul]

Hi,

I already configure and cluster packages (Legacy) for Oracle using Enterprise Cluster Master Toolkit for the 1st instance. It works fine. But now I have to integrate the remaining 3 ORACLE_SID using service guard. Can you please guide me how can I do it ?

One more information all the ORACLE_SID use the same ORACLE_HOME location ( Only one Oracle Binary for all).

For integrate the Oracle 1st instance ( 1st ORACLE_SID) I changed haoracle.conf file. But how can I do for the remaining?

Appreciate for earlier response.

BR\\ Aungshu

[Turgay Cavdar]

You can create a new package for each instance. And you can also configure some dependency between those packages.

[Aungshuman Paul]

Hi,

I understand that I can create multiple packages. But I want to use same package. How can I use one tookit.sh ( Enterprise Cluster Msater Toolkit) for configure all the instance. Because the ORACLE_HOME is same for all the instance.

I also understand I can copy toolkit.sh as toolkit1.sh, toolkit2.sh etc and can use customer defined function in the package control file. But I dont know is it the standard procedure or not? It is preferable if configure all ORACLE_SID from single toolkit.sh.



Aungshu

[Turgay Cavdar]

Oracle SID value is defined in haoracle.conf file. There are no options in this file for multiple instances.

What i do in my environment:
package 1 - > Mount oracle home, give ip , online db storage (file system or, raw lvm volumes), start db1, start listener1
package 2- > online db storage (if there is any) , start db2, start listener2
package 3- > online db storage (if there is any) , start db3, start listener3

Create dependency for package 2,3 to package1.

[Aungshuman Paul]

Hi,

Thanks for your suggestion. But my plan I will try first rename toolkit.sh as toolkiot1.sh and also rename haoracle.conf etc file as haoracle1.conf and modify toolkit1.sh file for looking haoracle1.conf etc.Then finally add multiple entry of customer defined funtion for execute toolkit1.sh, toolkit2.sh etc.

I guess it will work. If it is not working then I will try with multiple packages.

What is your opinion?

Aungshu

[Turgay Cavdar]

If you edit *.sh scripts of course you can do what you want. But you may me out of support for ECMT as you edit the scripts by yourself. Please ask hp about changing the scripts.