topic Re: Cluster Active - Passive in ORACLE 10g R2 Enterprise w/ServiceGuard in Operating System - HP-UX

Cluster Active - Passive in ORACLE 10g R2 Enterprise w/ServiceGuard

Christhian Chamba — Sun, 09 Jan 2011 19:52:53 GMT

Hi,

Is possible to make a cluster Active - Passive for ORACLE 10g R2 only with ServiceGuard or I need something more???...

Greetings,

Re: Cluster Active - Passive in ORACLE 10g R2 Enterprise w/ServiceGuard

Emil Velez — Mon, 10 Jan 2011 01:17:47 GMT

Oracle can work as a failover package in a serviceguard configuration.

HP Has a enterprise cluster master toolkit that has a sample script for oracle packaging and monitoring.

Re: Cluster Active - Passive in ORACLE 10g R2 Enterprise w/ServiceGuard

SoorajCleris — Mon, 10 Jan 2011 02:30:52 GMT

Hi,

It depends on which kinda cluster you want.
For an activ active cluster, you should implement Oracle RAC with help of SGeRAC over SG.

with only service guard , you may configure fail over package (active passive).
This will be normal process like shuting down the package on one node then starting it on other one.

Regards,
Sooraj

Re: Cluster Active - Passive in ORACLE 10g R2 Enterprise w/ServiceGuard

Christhian Chamba — Mon, 10 Jan 2011 04:19:49 GMT

Hi Emil / Sooraj,

I don't need an active - active cluster, I need a failover cluster; in this case only need a SeviceGuard, is correct???...

I install a HP-UX 11i v3, what is the best version of ServiceGuard that I need install for ORACLE 10g R2.

Greetings,
Christhian.

Re: Cluster Active - Passive in ORACLE 10g R2 Enterprise w/ServiceGuard

Viktor Balogh — Mon, 10 Jan 2011 11:48:20 GMT

Hi,

>I install a HP-UX 11i v3, what is the best version of ServiceGuard that I need install for ORACLE 10g R2.

The latest SG version is 11.20, this is the recommended version to install to date.

Regards,
Viktor

Re: Cluster Active - Passive in ORACLE 10g R2 Enterprise w/ServiceGuard

Christhian Chamba — Mon, 10 Jan 2011 18:12:13 GMT

Hi Viktor,

Thanks your four answer, do you have any manual for configuring SG for ORACLE???...

Greetings,
CCH

Re: Cluster Active - Passive in ORACLE 10g R2 Enterprise w/ServiceGuard

Alzhy — Mon, 10 Jan 2011 18:46:44 GMT

Is your OE Mission Critical? You will ned a Mission Critical License to have ServiceGuard.

OR, you can just employ Poor Man's cluster by writing the scripts needed to quickly failover your Oracle Environment to another server.

Re: Cluster Active - Passive in ORACLE 10g R2 Enterprise w/ServiceGuard

Viktor Balogh — Tue, 11 Jan 2011 14:37:10 GMT

>do you have any manual for configuring SG for ORACLE???

obtain the "Serviceguard Enterprise Cluster Master Toolkit", it is a set of scripts helping to create HA-packages. There are some dedicated stuffs for Oracle:

http://h71028.www7.hp.com/enterprise/w1/en/os/hpux11i-serviceguard-toolkits-ecmt.html

here is a doc for setting it up, I hope the BSC link works:

http://h20000.www2.hp.com/bizsupport/TechSupport/CoreRedirect.jsp?redirectReason=DocIndexPDF&prodSeriesId=4162103&targetPage=http%3A%2F%2Fbizsupport2.austin.hp.com%2Fbc%2Fdocs%2Fsupport%2FSupportManual%2Fc02496200%2Fc02496200.pdf

>You will ned a Mission Critical License to have ServiceGuard.

AFAIK Serviceguard can also be licensed separately if you don't have the MCOE, but correct me if I'm wrong.

Re: Cluster Active - Passive in ORACLE 10g R2 Enterprise w/ServiceGuard

Viktor Balogh — Tue, 11 Jan 2011 14:40:47 GMT

oww. the link to the doc was screwed, here's a new one:

http://h20000.www2.hp.com/bizsupport/TechSupport/DocumentIndex.jsp?lang=en&cc=us&taskId=101&prodClassId=10008&contentType=SupportManual&docIndexId=64255&prodTypeId=18964&prodSeriesId=4162103

...and look for the

"Using the Oracle Toolkit in a HP Serviceguard Cluster README Revision: B.06.00, August 2010"

Re: Cluster Active - Passive in ORACLE 10g R2 Enterprise w/ServiceGuard

Christhian Chamba — Tue, 11 Jan 2011 15:02:01 GMT

Hi Alzhy,

Yes is a HP-UX 11i v3 High Availability OE,the idea is use a ServiceGuard for make a failover (Cluster Active - Passive) of Oracle 10g R2.

Hi Viktor,

Thanks for the information, I review the PDF "Using the Oracle Toolkit in a HP Serviceguard Cluster" and for now I have a one question, Whats is the better use a LVM or ASM for the Oracle Database???.

Greetings,
Christhian

Re: Cluster Active - Passive in ORACLE 10g R2 Enterprise w/ServiceGuard

Alzhy — Tue, 11 Jan 2011 15:06:44 GMT

If the toolkit now includes ASM in the configuration -- I'd prefer that - that is IF your DBAs are comfortable with it.

Otherwise, Cooked Oracle Storage LVM with 11.31's new DirectIO should be just as kool.

Why I suggested Poor Man' Cluster? Because it simply works, costs NIL and pretty much does what SG can do -- That is if you have good scriptwriters on board.

Re: Cluster Active - Passive in ORACLE 10g R2 Enterprise w/ServiceGuard

Christhian Chamba — Tue, 11 Jan 2011 15:14:37 GMT

Hi Alzhy,

Thanks for your help, in this case I use a ASM because is the recomendation for DBA.

I need use ServiceGuard because this is a migration of the infraestructure, actually the client have a Sysbase with a ServiceGuard in a Cluster Active - Passive.

Greetings,
CCH

Re: Cluster Active - Passive in ORACLE 10g R2 Enterprise w/ServiceGuard

Viktor Balogh — Tue, 11 Jan 2011 15:18:12 GMT

>Whats is the better use a LVM or ASM for the Oracle Database???

I would stick to the good'ol LVM, because ASM is not very known to me. Note that in an ASM filesystem you can't store anything. These two arguments are enough for me to go the LVM way.

In a system with ASM, the followings are

supported:

* Database files
* Control files
* Online redo log files
* Archived redo log files
* Flash recovery area files
* RMAN files (image copy and backup)

NOT supported:

* Installation files (in ORACLE_HOME, CRS_HOME)
* ORACLE_BASE files( including alert log, trace files, etc)
* CRS voting disk and OCR files
* Output data from UTL_FILE
* Any user or application specific files(e.g. XML or Java files)
* Oracle 9i external table files

Re: Cluster Active - Passive in ORACLE 10g R2 Enterprise w/ServiceGuard

Christhian Chamba — Thu, 13 Jan 2011 05:21:30 GMT

Hi Viktor,

Thanks for the recommendations, I talk with the DBA and review the 2 option: use a LVM or DBA but I don't have any problem with Serviceguard with the two options, it's correct???...

Greetings,
Christhian.

Re: Cluster Active - Passive in ORACLE 10g R2 Enterprise w/ServiceGuard

Viktor Balogh — Thu, 13 Jan 2011 14:40:41 GMT

>but I don't have any problem with Serviceguard with the two options, it's correct???...

No, both way is doable, the documentation is the proof of it. I just prefer LVM because I wouldn't assign volume manager tasks to a DBA. Ask your DBAs if they are familiar with ASM.

Re: Cluster Active - Passive in ORACLE 10g R2 Enterprise w/ServiceGuard

Christhian Chamba — Mon, 17 Jan 2011 03:50:33 GMT

Hi Viktor,

Thanks for your replies, I talk with the DBA about the ASM, and if he know about that, the best way is use ASM with the Serviceguard or not???...

Greetings,
Christhian Chamba

Re: Cluster Active - Passive in ORACLE 10g R2 Enterprise w/ServiceGuard

Alzhy — Mon, 17 Jan 2011 05:29:42 GMT

It depends HOW ASM is set up. If ASM is setup to use RAW LVM volumes (which is IDIOTIC imho), then the same facilities to failover LVM can be employed. Otherwise - IF the DB is on cXtYdz or diskNN or better yet (smartly named user defined names) -- then there IS nothing to be done by ServiceGuard as Storage Management is TOTALLY DONE by the package (the ASM Engine) --to seek out all the members. The important thing is to simply ensure the disk members are presented to the nodes -- and recognisable vy ASM_DISKSRTING.

Re: Cluster Active - Passive in ORACLE 10g R2 Enterprise w/ServiceGuard

Christhian Chamba — Mon, 17 Jan 2011 14:52:48 GMT

Hi Alzhy,

Thanks for your reply, I think that I need talk with the DBA because if he know about ASM only need configure the Serviceguard and the Storage Management is reponsability of the DBA.

What do you thing???...

Greetings,
Christhian Chamba