Operating System - HP-UX
1829148 Members
2619 Online
109986 Solutions
New Discussion

looking for mc service guard / oracle config guide

 
Devin McEntee
Occasional Contributor

looking for mc service guard / oracle config guide

I'm looking for a configuration guide for installing Oracle in a 2 node mc service guard environment.

Not Oracle parallel server - just production db with hot standby

THANKS !!
8 REPLIES 8
Christopher McCray_1
Honored Contributor

Re: looking for mc service guard / oracle config guide

here is the link to the MCSG manual, if you don't already have it:

http://www.docs.hp.com/hpux/pdf/B3936-90053.pdf

otherwise, if you install the Oracle piece from the Enterprise Cluster Master Toolkit (I believe it's on application CD #1), not only is the oracle startup/shutdown script (/opt/cmcluster/toolkit/oracle/ORACLE.sh) self-explanatory, it is accompanied by a README file as well. Use the ORACLE.sh file as it works, it's easy and it's supported by HP. The rest of the package configuration stuff is more or less like any other application.

Hope this helps
It wasn't me!!!!
Christopher McCray_1
Honored Contributor

Re: looking for mc service guard / oracle config guide

After doing some searching, I haven't found anything yet. So, to this point, the only guide for configuring a "run of the mill" oracle package for service guard is the book provided by HP in the class, other than my first response. The manual will be very useful for the package configuration end of it and, like I said, the ORACLE.sh does the rest for you after you fill in the variable values.

Hope this helps
Chris
It wasn't me!!!!
Sanjay_6
Honored Contributor

Re: looking for mc service guard / oracle config guide

Hi Devin,

I don't think you are going to find any installation manual for installing and configuring Oracle on MC/SG. The manual that you can find is oracle installation manual on hp-ux. Installing and configuriong MC/SG. docs on the oracle standard configuration on MC/SG available as toolkit as mentioned above.

The oracle docs are available at http://docs.oracle.com/database_mp.html

The link to MC/SG manual is already given above. The configuration of SG varies from one site to another and depends on the type of configuration you want. We have standard oracle binaries installed on both the nodes and the databases fails over from one node to another in one configuration. In another configuration we have oracle binaries as well as the database failing over from one node to another. In the first case we have multiple instances of oracle databases running on each node and hence we need oracle binaries on each node. In the 2nd case there is only one oracle instance and hence we can do with oracle installation on the shared vg which gets failed over with the database.

So what i'm trying to say is that you have to look at the environment you want and then do the installation and configuration accordingly.

Hope this helps.

Regds
Devin McEntee
Occasional Contributor

Re: looking for mc service guard / oracle config guide

First I want to say thanks to all who replied. This is the first time that I have ever used this forum and it's a very responsive group !

Second, I am a total serviceguard newbie - just found out about it yesterday. So here's a few simple questions:

I have 2 Oracle instances and like everyone else, I am trying to achieve HA. What is the basis for deciding where to locate the Oracle binaries (private vs. share disks)

There was mention of a class manual. Is it available online ?

I don't understand who is providing the high availability. As an example, Oracle can support a standby database on a totally separate machine, or can provide replication to another machine. But I get the feeling that Oracle is unaware of service guard and that all of the work is done by the HP system.

Sorry it got wordy -
Sridhar Bhaskarla
Honored Contributor

Re: looking for mc service guard / oracle config guide

Devin,

Few things to consider.

1. Have a local /oracle file system on each of the server. This should not be part of any of the volume groups that float. This is because you are going to have two different instances and you don't /oracle to be floating.
2. Have different volume groups, logical volumes and file systems for different instances.
3. Create two different packages for these two oracle instances and configure two different floating IPs.
4. Since MC/ServiceGuard is of two nodes, run one instance on one node and the other on the secondary node failing back to each other.

docs.hp.com is a very good site for HP documentation. Check the High Availability section.

-Sri
You may be disappointed if you fail, but you are doomed if you don't try

Re: looking for mc service guard / oracle config guide

This is just my $.02 worth...

If you really don't know serviceguard, and truly want to acheive high availability for your system(s) then simply reading the manuals and posting questions on the forum is simply not going to cut it - you should be looking at:

1) Going on the HP ServiceGuard course(s) (and LVM course if you don't know LVM)

and/or

2) Get a ServiceGuard consultant in to help

I know both of these options = $$$ - but not much compared to the cost of your servers + the disk technology and network infrastructure required to correctly implement SG. There are just too many gotchas and issues around designing a ServiceGuard implementation to leave this stuff to chance - a badly implemented SG system can quite easily lead to a lower availability figure than what a standalone system would provide.

I'm sure some forum folk will disagree with this sentiment, but having worked with MCSG for five years now I still feel I have much more to learn, and only started implementing systems myself in the last 2 years...

HTH

Duncan

I am an HPE Employee
Accept or Kudo
Christopher McCray_1
Honored Contributor

Re: looking for mc service guard / oracle config guide

Basically the same reply as Sridhar, so I'll try to be brief in my explanation:

I have 3 2-node clusters on which I have oracle packages on 2 of them.

I have two instances on each cluster and, hence, two packages. I'll go with my more basic configuration, in which I have two volume groups for each instance on the shared disks and I have the oracle binaries on my private vg00. I do, however, have the entire database application (what was installed from the oracle CD) on the private disk. It has been argued that, while it is fine to have it this way, that all you really need is the binaries on the private and everthing else on the shared. This alleviates duplication of work when maintaining the database, to name an example.

I have in my config both packages on one node and the other as stanby, although I'm trying to change that.

As for the class book, I don't think that you can get it any other way than going to the class, but the publication I gave the link for, along with other pubs at docs.hp.com under high availabity, should be a good starting point.

Good luck
Chris
It wasn't me!!!!
Christopher McCray_1
Honored Contributor

Re: looking for mc service guard / oracle config guide

As an add-on, both of the suggestions that Duncan posted have much merit. You need to convince you supervisor that training and/or onsite consultant support is necessary (because it is). If your applications are truly important enough to protect through an HA solution, then it must be done correctly. Everything about a true HA environment costs money, right down to the training of those expected to maintain it.

Good point, Duncan!!

Now for my apologies for having to use so many posts to get my $0.02; it's probably more like $2.02 now!

Good luck and good night
Chris
It wasn't me!!!!