Operating System - HP-UX
1748219 Members
4686 Online
108759 Solutions
New Discussion юеВ

Installation of oracle on cluster( M/c service guard)

 
naveen_6
Occasional Contributor

Installation of oracle on cluster( M/c service guard)

Hi,

I have want to install oracle 8.1.7 on two node cluster(m/c service guard) on Hp9000 N-class servers on hp-ux11i.I want oracle to switchover to another node once one node in cluster fails.I have fc-60 diskarray(50 disks) under LVM control.
1. Which is best place to install oracle(just software) on clusternode root disk /opt(enough spce)? or in Disk array like /u01 or /u02.My database files are on disk array(/u10, u11, u12..).Where should i kepp oracle statup and shutdown scripts?
Can anyone please give me good solution on this?

Thanks
Naveen

naveen
9 REPLIES 9
Mark van Hassel
Respected Contributor

Re: Installation of oracle on cluster( M/c service guard)

In my opinion it is best to have as much as possible on the shared storage. This way it is easier to manage, especially regarding upgrades, changes in configuration files etc.

Mark
The surest sign that life exists elsewhere in the universe is that none of it has tried to contact us
Printaporn_1
Esteemed Contributor

Re: Installation of oracle on cluster( M/c service guard)

I install in /u01
enjoy any little thing in my life
Vijeesh CTK
Trusted Contributor

Re: Installation of oracle on cluster( M/c service guard)


hi..

The best way is to install oracle in the shared disk.. it will be helpful.

regarding oracle scripts.. in ur package control scripts u can specify that .

Vijeesh CTK
Steve Edmunds_1
New Member

Re: Installation of oracle on cluster( M/c service guard)

I work with Naveen,thanks for the replies. I am no Oracle expert, but we need to run a highly available OLTP application under MC/ServiceGuard (2 nodes)
If we put everything down on shareable storage, how would we be able to perform rolling Oracle upgrades? For that I think we have to have seperate Oracle installs, plus
MC/Serviceguard manuals
say anyway that as much as possible of application data that can be replicated should be installed seperately on each system. (Managing SG, page268)

Also, I assumed with all of the application installed into the root volume but with databases and logs on the
sharable (higher performance) storage, we still would not see any appreciable performance impact - as any heavily used Oracle daemons or execs would be mainly resident - at least in virtual memory.
Is this true?
Any input greatly appreciated
on this point too!

Cheers

Steve
melvyn burnard
Honored Contributor

Re: Installation of oracle on cluster( M/c service guard)

The choice whether to put the actual Oracle binaries onto a shared disc or not is yours, but I always advise people to go for separate installations, as this then allows the rollling upgrades as you say.
In fact, most systems I deal with do NOT use the shared binary installaion method.
I believe Oracle have a few document available regarding these types of subjects on their web pages.
My house is the bank's, my money the wife's, But my opinions belong to me, not HP!
Nagarathinam
Advisor

Re: Installation of oracle on cluster( M/c service guard)

Dear Naveen,
With regard to your queries I have the following suggestions as we are running two node cluster with McServicGuard and shared disk with oracle.

1. If you prefer failover of nodes and load balancing have oracle software on nodes and I do hope you are going to have oracle OPS edition.

2.Keep Your cluster with node A as Primary node and Node B as your configured node with failover to a configured node and failback automatic. If you run OPS then both nodes are available to you.

3. You can keep your oracle startup and shutdown automatic with cluster.

4. Since You are going to run Oracle 8.1.7 it does not require a DLM or GMS.

5. Your McServiceGuard and oracle installation manuals can be starting point.

6. If you are using oracle OPS then, Your Oracle data files will be on raw devices.
Know about raw devices.

Bye

A.Nagarathinam
Justo Exposito
Esteemed Contributor

Re: Installation of oracle on cluster( M/c service guard)

Hi,

I have a two nodes cluster in a two hp 9000 N class with hp/ux 11.00 and Oracle 8.1.6.

And I have installed the Oracle software in the /opt in the internal disks of both boxes, then I have two Oracle installations and then I can have different configurations for Oracle in both nodes.
This kind of installation give me the posibility of maintenance, upgrade the Oracle software without downtime, and give me the chance of have differents configurations in both nodes.

I think that this kind of installation is better than the installation on the shared disk.

Regards,

Justo.
Help is a Beatiful word
Mark van Hassel
Respected Contributor

Re: Installation of oracle on cluster( M/c service guard)

I agree that for rolling upgrades its better to install the Oracle tree locally. However keep in mind that it is more complex to manage changes, ie Oracle patches, changes to configuration files (stored locally) have to be perfromed twice.
The manageability in a small organisation should not be a problem, however in a large organisation with lots of (different) procedures, systems and people it is harder to make sure all changes are done on both systems.

It is always a good idea to perform a test fail over everyone 1 or 2 months, just to check whether everything still works as designed.

Mark
The surest sign that life exists elsewhere in the universe is that none of it has tried to contact us
Sanjay_6
Honored Contributor

Re: Installation of oracle on cluster( M/c service guard)

Hi Naveen,

The location where oracle should be installed is dictated by the sort of installation you are doing. Let me give you some example,

1.) Only one server is going to run oracle at a time - Have oracle installed on the shared device, configure oracle binary files to be failed over with the package. Oracle to be installed on one system only in seperate VG/LV than the system LV/VG. Few oracle files which get copied in /etc and /usr/local/bin be copied from one server to another.

2.) Oracle databases to be run on both servers at the same time, seperate databases on each system, packages configured for failover - Oracle installed on local / shared disk but not configured for failover with the package. Oracle to be installed seperately on both systems.

Hope this helps.

Regds