How to configure Oracle Applications 11i with HP-UX MC service guard ?

[Deepu Chakravarty]

I intend to install oracle applications 11i in the clustering environment. We have servers rp7420 and rp8420 with HP-UX 11.11. HP has installed MC-Service guard for failover.

I need to know how this configuration is done. An urgent help is required.

Thanks in advance.

[Devender Khatana]

Hi,

If oracle is not installed yet and you need to use MC SG for monitoring oracle then MC service guard is not finished yet. MC Service Guard has to be integrated with oracle once it has been installed. So install oracle and then get it integrated.

HTH,
Devender

[Devesh Pant_1]

Deepu,

there is an excellent otacle toolkit available with the MC Serviceguard which you can use to implement Oracle with MC Serviceguard.
Please go to /opt/cmcluster/toolkit/oracle
and read the README and there are pre-canned scripts that you can modify to your requirements.
If you have some specific requirement, that can also be taken care of once you spell it out.

thanks
Devesh

[Devesh Pant_1]

Deepu,

there is an excellent oracle toolkit available with the MC Serviceguard which you can use to implement Oracle with MC Serviceguard.
Please go to /opt/cmcluster/toolkit/oracle
and read the README and there are pre-canned scripts that you can modify to your requirements.
If you have some specific requirement, that can also be taken care of once you spell it out.

thanks
Devesh

[Nguyen Anh Tien]

You need MC-SG Oracle Toolkit, that allow service on pakage config start/shutdown DB when you start/shutdown Cluster.

[Deepu Chakravarty]

I got an impression from various postings in this thread that oracle/oracle apps11i needs to be installed on the primary nodes first and then has to be integrated with MC service guard.

So I installed the oracle apps 11i in the primary node without using virtual host.

Pls let me know that whether I should contact our HP vendor now to configure MC service guard with oracle installed in the primary node (not in the virtual node).

[Steven E. Protter]

You do need to install the oracle applications.

It needs to go on one node.

If you are doing a fresh installation, you can install it on one of the shared volume groups. you can put binaries and data on the shared volume group and use Serviceguard to activate the volume group, start the application and monitor it.

Then you send the SG configuration files over to the second node, make some minor adjustments and test failover.

SEP

[Matthew Ghofrani]

You really don't need to worry about what type of application you are running. With MC ServiceGuard as long as you insert the proper start & stop script in your config files, you should be fine. In my own env, which I have 20 or so servers with combination of virtual and physical servers made up of rp8400s, I have 6 nodes with multiple Oracles failing to each other. The trick I used was to make oracle binaries belong to the server rather the individual packages. I also sync up my own password files and so on...but ultimately the MC could care less what app is it starting, it could be as simple as a "xclock" running.

Matthew from Boston

[Rita C Workman]

Hmm...hope I'm not repeating anyone above.

Installing Oracle is one thing. That is loading software, and working with the DBA.

Now doing it in an MC/SG environment is another thing. Here's a few things to consider.
1. Mountpoints...they must be UNIQUE. So think about where you might fail over TO. Make sure, if your planning on letting this failover server continue to run, that your mountpoints are UNIQUE.
2. Keep every WITHIN the pkg. So you do NOT want to load Oracle in a filesystem/mountpoint that is not part of the cluster.
3. Where will the programmers keep their scripts and 'things they MUST have'. Again keep that within your pkg !!

Do you see the picture.....think,plan, then implement !

Regards,
Rita

[renarios]

Hi Deepu,

On our cluster with Oracle Database 8i & 9i,
we decided to install the Oracle binaries on the local disks and all databases on disk array.
Advantage of that is that both fail-over and load-balancing can be accomplished.

Cheerio,

Renarios

[Deepu Chakravarty]

Thanks to all who were particitaped in this thread.
I have installed oracle applications in a cluster node (primary node) and this node is in a package (virtual node) which will be integrated with service guards. I hope my installation is correct.

I kept file systems unique.

[Faizer Jameel]

Hi there
We did a MCSG cluster for Oracle 11.5.8 with a cold failover using 2 rp7410.
first setup the hardware cluster and configure the package

Login to package
Use the oracle accounts to run

Rapidwiz â servername Package name
Then the files in
$FND_TOP/secure which are linked for the cluster.

ie: the .dbc files ahve to be linked
GSM has to be disabled

Listener file has to be changed.
~
change the start and stop for the application and the database scripts to reflect the PROD name.-
incorporate the start and stop scripts to the package control scripts.
That does the work.
We are running fine with this concept.

Hope this hel

[Deepu Chakravarty]

Hi,
Jameel,
Thanks for the updates.
As you wrote:
"We did a MCSG cluster for Oracle 11.5.8 with a cold failover using 2 rp7410.
first setup the hardware cluster and configure the package"

In my case we ahave lready setup hardware cluster and package too.

"Login to package
Use the oracle accounts to run "

I can login to package but I did not understood "Use the oracle accounts to run". Pls explain. I have to use 'root' account to install because of multi-user installation.

"./Rapidwiz -servername Package name"

If I use this command then rapidwiz is not recognizing the package name and giving error while running the configuration file (config.txt).

Rest are not completed yet.

[Faizer Jameel]

Hi Deepu
may be if you contact me I could provide all the information then it could be posted on the forum.
best regards

[Deepu Chakravarty]

Jameel,
How I should contact you ? Any mobil or office no. pls ?
Thanks.