Operating System - HP-UX
1752480 Members
5447 Online
108788 Solutions
New Discussion юеВ

Best Practices Paper for EVA 5000 Oracle 9.2.0 HP-UX11.11

 
rccmum
Super Advisor

Best Practices Paper for EVA 5000 Oracle 9.2.0 HP-UX11.11

Hi ,

I am looking for a nice resource of information for all these three entities to put them all in the best possible way.

You can share your practical experience about implementing these platforms here
11 REPLIES 11
morganelan
Trusted Contributor

Re: Best Practices Paper for EVA 5000 Oracle 9.2.0 HP-UX11.11

Steven E. Protter
Exalted Contributor

Re: Best Practices Paper for EVA 5000 Oracle 9.2.0 HP-UX11.11

Let me give you the benefit of some real world experience.

Redo, data and index for oracle need to be raid 1 or raid 10. If you try and do it raid 5, you will get huge bottlenecks during heavy write periods because of how many disks need to be updated at the same time.

If the database is mostly reads, then you can ignore this advice.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Alzhy
Honored Contributor

Re: Best Practices Paper for EVA 5000 Oracle 9.2.0 HP-UX11.11

RCCMUM,

As another real-world user of large Oracle DB (multi-TB, on large rp84xx, SDXX machines) on EVA5000's. We are finding out the same findings as the attached white paper which will also give you tidbits onhow to properly set up Oracle on EVA and the performance behaviour.

It's for 10G but should apply to 9.X as well.

HTH.
Hakuna Matata.
Alzhy
Honored Contributor

Re: Best Practices Paper for EVA 5000 Oracle 9.2.0 HP-UX11.11

But that was months ago... we've sinced decided to move to the more "Enterprise" capable XP12000 array as we were having problems with scalability as well as some serious reliability issues.
Hakuna Matata.
Hein van den Heuvel
Honored Contributor

Re: Best Practices Paper for EVA 5000 Oracle 9.2.0 HP-UX11.11

And here is one more download for a pdf document called:

"Best practices for Oracle 10g and EVA5000"

http://h71028.www7.hp.com/enterprise/downloads/EVA5000%20and%20Oracle%2010g%20best%20practices.pdf

hth,
Hein.
Alzhy
Honored Contributor

Re: Best Practices Paper for EVA 5000 Oracle 9.2.0 HP-UX11.11

Hein... that URL is the same attachment I have.
Hakuna Matata.
Alzhy
Honored Contributor

Re: Best Practices Paper for EVA 5000 Oracle 9.2.0 HP-UX11.11

Oops.. it's different. Gomenasai (sorry)!

;^)
Hakuna Matata.
rccmum
Super Advisor

Re: Best Practices Paper for EVA 5000 Oracle 9.2.0 HP-UX11.11

Thanks to everyone for sharing the quite useful documents.

Syam,
I have few questions in regard to the document you have atttached. Can you give me your email id here to let you know my concerns?

Hein,
Was the performance evalution of Oracle9i on EVA done by HP-Oracle ever?
Does the 10g evalution applies to 9i as well?

Nelson,
What makes you think that performance evaluation of 10g applies to 9i ? I am Curious to know , pls.
What sort of scalability and "serious reliability issues" you have came across using EVA?? It's interesting to know

We decided to have Vraid1 i.e. Raid 0+1 for all Vdisks which will ensure I/O balance for
Oracle.

Sameer_Nirmal
Honored Contributor

Re: Best Practices Paper for EVA 5000 Oracle 9.2.0 HP-UX11.11

Guys ,

Waiting for you replies on my last message