topic Is APA configure mendatory for oracle RAC in Operating System - HP-UX

Is APA configure mendatory for oracle RAC

Taifur — Mon, 26 Oct 2009 02:41:18 GMT

Hi,
One of our server which Brand:HP Model:rx6600
os:HP-UX 11.23,there oracle RAC is running. My query is APA (Auto Port Aggregation ) is mendatory or recomended for oracle RAC ?

Regards//
Taifur

Re: Is APA configure mendatory for oracle RAC

Kapil Jha — Mon, 26 Oct 2009 03:01:58 GMT

It can not be mandatory because its just a way to enhance network performance.
You can have various configuration with APA add 2 NIC to have one NIC etc

http://docs.hp.com/en/9831/SGeRAC_BestPractices.pdf

Its better to have APA :)

BR,
Kapil+

Re: Is APA configure mendatory for oracle RAC

Viveki — Mon, 26 Oct 2009 03:08:20 GMT

Hi Taifur,

It is not mandatory to have APA configured for Oracle RAC.

The preferred choice for VIP is Serviceguard local LAN failover and not APA.

As suggested by Kapil above, please refer
http://docs.hp.com/en/9831/SGeRAC_BestPractices.pdf

Re: Is APA configure mendatory for oracle RAC

Hein van den Heuvel — Mon, 26 Oct 2009 03:12:25 GMT

Mandatory for performance or for availability?

Do you have ServiceGuard?
This looks like a useful document:
http://docs.hp.com/en/12732/SGeRAC_11g_Sample_Config.pdf
"Serviceguard monitors the redundant network and additional APA software is not required."

From the performance perspective I'd say NO and NO until you have some numbers to support the need

Why do you think it might be mandatory?
Do you have some official Oracle document to refer to?

Why do you think it might be recommended?
Do you have some white-paper, best-practices, to refer to?
Here are some non-official comments:
http://oracleha.blogspot.com/2008/01/oracle-recommended-rac-architecture.html
http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1194695

And exactly for what Oracle RAC usage would you want to put it in place?
The cluster interconnect? The VIP's?

The most critical attribute for the RAC cluster interconnect typically is the latency for lock messages. APA will not help for that. When lots of block shipping is happening, then the bandwidth may become a concern and APA may be desirable.
Are you currently using 100mb? gb? 10gb? Infiniband?

What is the load (expectation) to the best of your understanding?

I would recommend using both Oracle and network tools to monitor the load, notably the bandwidth every now and then to make sure the usage is in the comfort zone of the hardware.

fwiw,
Hein.