topic Oracle on Itanium in Operating System - HP-UX

Oracle on Itanium

Joshua Scott — Wed, 05 Nov 2003 16:14:49 GMT

I was wondering what kind of experiences people here have had running oracle under HP-UX on Itanium2 CPUs.

We are currently running Oracle on a PA-RISC box, (L2000-440MHz/4way), and are looking to upgrade to a newer/faster server.

I was wondering if HP-UX & oracle are as stable on the Itaniums as the PA-RISC chips.

Any Comments are welcome

Thanks!

-Josh

Re: Oracle on Itanium

Steven E. Protter — Wed, 05 Nov 2003 16:34:44 GMT

Yes,

You can do that.

You do however have a really fast box.

Per HP Bug (Doc ID: KBRC00003627) The default 64bit OS installation does not create a few required X library symbolic links. The following symbolic links need to be created:
cd /usr/lib
ln -s /usr/lib/libX11.3 libX11.sl
ln -s /usr/lib/libXIE.2 libXIE.sl
ln -s /usr/lib/libXext.3 libXext.sl
ln -s /usr/lib/libXhp11.3 libXhp11.sl
ln -s /usr/lib/libXi.3 libXi.sl
ln -s /usr/lib/libXm.4 libXm.sl
ln -s /usr/lib/libXp.2 libXp.sl
ln -s /usr/lib/libXt.3 libXt.sl
ln -s /usr/lib/libXtst.2 libXtst.sl

HP-UX 11.0(64 bit) Operating System Patches:
Sept 2001 Quality Pack
PHCO_23792 s/b PHCO_26960
PHCO_24148 s/b PHCO_25707 s/b PHCO_27608
PHKL_24268 s/b PHKL_27178
PHKL_24729
PHKL_25475 s/b PHKL_27510
PHKL_25525 s/b PHKL_27364
PHNE_24715 s/b PHNE_26771
PHSS_23670 s/b PHSS_26138
PHSS_24301 s/b PHSS_26273
PHSS_24303 s/b PHSS_26559
PHSS_24627
PHSS_22868

HP-UX 11i (64 Bit) Operating System Patches:
Support Plus Bundle 'December 2002 SP-0212' or later
JDK 1.3.1.02
PHNE_27745
PHNE_28568
PHKL_25506
PHSS_26560
PHSS_26946
PHSS_28849
PHSS_26946
PHSS_26560
PHCO_28427
PHCO_24402

HP-UX 11.22 (IA64) Operating System Patches:
PHSS_27284
PHSS_27285
PHSS_27286
PHSS_27287
PHSS_27288
PHSS_27289
PHSS_27290
PHSS_27291
PHSS_27292
PHSS_27293
PHKL_28465

SEP

Re: Oracle on Itanium

Hein van den Heuvel — Wed, 05 Nov 2003 20:27:33 GMT

On the heels of the 1M TPC-C announcement, let's just look at the TPC-C numbers for comparison (www.tpc.org)

Old: Jun 2000, 8 CPU HP PA-RISC 8600 550MHz: 60,000 (102010901)

New: Feb 2003, 4 CPU Intel Itanium2 1 Ghz : 87,000 (102121601)

Newer: Jul 2003, 4 CPU Intel Itanium2 1.5GHz : 131,000 (103073002)

So with the latests CPUs and latest Oracle (10g, not availble yet) the Itanium can do twice the work with half the cpu's. Not bad for a new kid on the block.

Application availability may be an issue, but if you are just running Oracle, the Itanium looks hot!

My own experience is just with benhcmarks (not real applications) in labs. We habitually use 4 CPU Itanium systems, even at 1.0 Ghz instead of 8 CPU PA systems (even if those were at 875Mhz)

fwiw,
Hein.

Re: Oracle on Itanium

lsshiu — Thu, 06 Nov 2003 09:54:41 GMT

Hi,
My experience is also in benchmark too. Itanium2 is really fast, but remember to use HP-UX 11.23 (11.22 is quite slow and there's no VxVM 3.5 for 11.22, at least for my experience). If you're just using Oracle, Itanium2 is a good choice.

David

Re: Oracle on Itanium

Bernhard Mueller — Thu, 06 Nov 2003 11:20:13 GMT

Joshua,

you need to have Oracle 9. Oracle 8 is not supported on Itanium.

Regards,
Bernhard

Re: Oracle on Itanium

George Neill — Sun, 09 Nov 2003 04:08:12 GMT

We got a rx2600 loaner system where we installed Oracle 9i for Itanium. We then setup a copy of our data warehouse and asked to developer to see what he thought. We run the database for about 2 weeks and the developer was quite happy. We are currently working on getting approval to get 6 of Itanium based systems in. One will be the future home of the data warehouse and another will be its development, test and failover system.

Regards,

George