Best Practices Paper for EVA 5000 Oracle 9.2.0 HP-UX11.11 (308 Views)
Reply
Super Advisor
rccmum
Posts: 249
Registered: ‎03-29-2005
Message 1 of 12 (308 Views)

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
Please use plain text.
Trusted Contributor
morganelan
Posts: 283
Registered: ‎02-21-2003
Message 2 of 12 (308 Views)

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

Please use plain text.
Exalted Contributor
Steven E. Protter
Posts: 33,806
Registered: ‎08-15-2002
Message 3 of 12 (308 Views)

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
Please use plain text.
Honored Contributor
Alzhy
Posts: 4,373
Registered: ‎01-22-2002
Message 4 of 12 (308 Views)

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.
Please use plain text.
Honored Contributor
Alzhy
Posts: 4,373
Registered: ‎01-22-2002
Message 5 of 12 (308 Views)

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.
Please use plain text.
Honored Contributor
Hein van den Heuvel
Posts: 6,581
Registered: ‎05-19-2003
Message 6 of 12 (308 Views)

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.
Please use plain text.
Honored Contributor
Alzhy
Posts: 4,373
Registered: ‎01-22-2002
Message 7 of 12 (308 Views)

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.
Please use plain text.
Honored Contributor
Alzhy
Posts: 4,373
Registered: ‎01-22-2002
Message 8 of 12 (308 Views)

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

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

;^)
Hakuna Matata.
Please use plain text.
Super Advisor
rccmum
Posts: 249
Registered: ‎03-29-2005
Message 9 of 12 (308 Views)

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.

Please use plain text.
Honored Contributor
Sameer_Nirmal
Posts: 2,108
Registered: ‎02-21-2004
Message 10 of 12 (305 Views)

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

Guys ,

Waiting for you replies on my last message

Please use plain text.
Super Advisor
rccmum
Posts: 249
Registered: ‎03-29-2005
Message 11 of 12 (305 Views)

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

Wish I could get replies to my queries.

Well , thanks all sharing with me all those docs, appretiated.
Please use plain text.
Honored Contributor
Ranjith_5
Posts: 1,079
Registered: ‎01-29-2004
Message 12 of 12 (305 Views)

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

Hi,

I think your queries are mainly on oracle and the same can be answered best the Oracle CoE of your firm. Else you can post this query in the database section of ITRC. Dont assign pts for this post pls.

Regards,
Syam
Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation