HPE Community read-only access December 15, 2018
This is a maintenance upgrade. You will be able to read articles and posts, but not post or reply.
Hours:
Dec 15, 4:00 am to 10:00 am UTC
Dec 14, 10:00 pm CST to Dec 15, 4:00 am CST
Dec 14, 8:00 pm PST to Dec 15, 2:00 am PST
System Administration
cancel
Showing results for 
Search instead for 
Did you mean: 

Is APA configure mendatory for oracle RAC

 
Taifur
Respected Contributor

Is APA configure mendatory for oracle RAC

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

3 REPLIES
Kapil Jha
Honored Contributor

Re: Is APA configure mendatory for oracle RAC

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+
I am in this small bowl, I wane see the real world......
Viveki
Trusted Contributor

Re: Is APA configure mendatory for oracle RAC

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
Hein van den Heuvel
Honored Contributor

Re: Is APA configure mendatory for oracle RAC

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.