Planning
cancel
Showing results for 
Search instead for 
Did you mean: 

Running Oracle on Lseries HP-UX 11i

SOLVED
Go to solution
K.C. Chan
Trusted Contributor

Running Oracle on Lseries HP-UX 11i

Team,
I have not work with HP-UX since 10.X. Our company just bought a low end HP-UX series model L3000-6x with HP storage array. We intend to use it to run oracle9i. This Lseries have 2 36Gbytes. The ram is 8Gbytes. My questions are, what is proper size for swap, does old school still apply, double the mem? What size should the file system /stand, /var, /opt, and /home be, any guidelines on that or docs? Thanks.
Reputation of a thousand years can be determined by the conduct of an hour
13 REPLIES
Jim Mallett
Honored Contributor

Re: Running Oracle on Lseries HP-UX 11i

I have an L2000 running 4 Oracle instances, one being Financials. Here is how this system is set up:
L2000
2 x 440Mhz Processors
4G Ram
4G Swap (I'm only using 1X for swap, it is rarely hit for me. The SGAs only total up to about 2G.)
OS is on 18G mirrored.
Data is on an EMC array.

VG00:
# bdf |grep vg00
/dev/vg00/lvol3 1048576 43541 942282 4% /
/dev/vg00/lvol1 119637 48516 59157 45% /stand
/dev/vg00/lvol8 2097152 838949 1180093 42% /var
/dev/vg00/lvol7 2097152 1146439 891435 56% /usr
/dev/vg00/lvol6 1048576 3204 981697 0% /tmp
/dev/vg00/lvol5 2097152 1092860 941566 54% /opt
/dev/vg00/lvol4 1048576 217210 779467 22% /home

What you see for used space is for the most part OS, I also have OmniBack installed which is eating up a little. /home and /tmp are probably oversized, I'm not concerned because I had the space.

Hope this gives you some ideas. Others may have some better suggestions though.

Jim
Hindsight is 20/20
Steven E. Protter
Exalted Contributor

Re: Running Oracle on Lseries HP-UX 11i

I three systems very similar to what you are running there.

I'm a member of the A Clay Stevenson school of swap management.

For 8 GB of Ram, I'd set up two swap areas.

One would be 4 GB, which is the minimum you need to take a memory dump.

That one would be primary.

The next one is variable, depending on what kind of load you are running. I generally set the secondary swap area 1.0 to 1.5 times RAM.

For those boxes, I'd have secondary swap set to 8 GB.

Summary:

swap

4 GB priority 1
8 GB priority 2

I set /stand on the big side, around 512 GB. Thats personal, lets me collect lots of kernels, but there is almost no chance you'll run out of space with that.

I set /opt to 2 GB, because I install a lot of security software, a few browsers and the Gnome environment.

/home depends on how you use it.

On my D320 at home being used as a web server, all the site directories are in /home so I set it big.

On my L class boxes at work I set /home to 2 GB. A few of the programmers are junk collectors, but we don't use it for anything except the programmers scripts. Set the size based on how you using it.

I'm not going to refer you to any docs' these are my recommendations, based on a few years of running Oracle on L class boxes.

Once you have it up and running, you'll want to collect some performance data and make kernel adjustments based on actual run performance. I'm attaching a script for that purpoase. Let me know if I can be any more help.

You'll like HP-UX 11i.

Oh. Make sure you install the June 2003 patch set and all of Oracle's reommended patches for your release.

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
twang
Honored Contributor

Re: Running Oracle on Lseries HP-UX 11i

We have Oracle running on rp5430(L-1500) with the following sizing:
oradb@ora_wh(prod)$ bdf |grep vg00
/dev/vg00/lvol3 204800 95705 102306 48% /
/dev/vg00/lvol1 299157 53499 215742 20% /stand
/dev/vg00/lvol8 3657728 744079 2732064 21% /var
/dev/vg00/lvol7 1196032 926077 253102 79% /usr
/dev/vg00/lvol4 204800 18831 175808 10% /tmp
/dev/vg00/lvol6 929792 726235 190858 79% /opt
/dev/vg00/lvol5 20480 2914 16512 15% /home

Today, I just applied June 2003 patch set:
oradb@ora_wh(prod)$ swlist -l bundle
# Initializing...
# Contacting target "wmo_erp"...
#
# Target: wmo_erp:/
#

B2491BA B.11.11 MirrorDisk/UX
B3701AA_TRY C.03.55.00 Trial HP GlancePlus/UX Pak for s800 11i
B5725AA B.3.6.82 HP-UX Installation Utilities (Ignite-UX)
BUNDLE11i B.11.11.0306.1 Required Patch Bundle for HP-UX 11i, June 2003
Base-VXVM B.03.20.1 Base VERITAS Volume Manager 3.2 for HP-UX
CDE-English B.11.11 English CDE Environment
CMDVIEWSDM A.1.04.00 hp command view sdm
FDDI-00 B.11.11.02 PCI FDDI;Supptd HW=A3739A/A3739B;SW=J3626AA
FibrChanl-00 B.11.11.09 PCI/HSC FibreChannel;Supptd HW=A6684A,A6685A,A5158A,A6795A
GOLDAPPS11i B.11.11.0306.4 Gold Applications Patches for HP-UX 11i, June 2003
GOLDBASE11i B.11.11.0306.4 Gold Base Patches for HP-UX 11i, June 2003
GigEther-00 B.11.11.14 PCI/HSC GigEther;Supptd HW=A4926A/A4929A/A4924A/A4925A;SW=J1642AA
GigEther-01 B.11.11.02 PCI/PCI-X GigEther;Supptd HW=A6794A
HPUX11i-OE B.11.11.0203 HP-UX 11i Operating Environment Component
HPUXBase64 B.11.11 HP-UX 64-bit Base OS
HPUXBaseAux B.11.11.0203 HP-UX Base OS Auxiliary
HWEnable11i B.11.11.0306.4 Hardware Enablement Patches for HP-UX 11i, June 2003
ITOSEEng A.05.57 ITO Special Edition, English
Ignite-UX-11-11 B.3.6.82 HP-UX Installation Utilities for Installing 11.11 Systems
J4189-11001C E.10.34 Hewlett-Packard JetDirect Printer Installer for Unix
OnlineDiag B.11.11.06.09 HPUX 11.11 Support Tools Bundle, Mar 2002
RAID-00 B.11.11.01 PCI RAID; Supptd HW=A5856A
Sendmail-811 B.11.11.01.005 Sendmail-8.11.1 special release upgrade
T1471AA A.03.10.001 HP-UX Secure Shell
perl B.5.6.1.C Perl Programming Language
doug mielke
Respected Contributor

Re: Running Oracle on Lseries HP-UX 11i

try to make your standard OS filesystems much larger than the default.
/var
/home
/usr
/opt
( on my L class, Oracle 8, each is 1 gig, on 9 gig useable drive, and I'd have more if I could)

can be a real pain to enlarge once the system and apps are running,
var and opt are seem to be defaults for many add on packages.
K.C. Chan
Trusted Contributor

Re: Running Oracle on Lseries HP-UX 11i

Team,
since I have two 36 Gbytes, I decided on the following file system layout:
/swap 4Gbytes
/tmp 1Gbytes
/home 200Mbytes
/stand 1Gbytes
/ 4Gbytes - don't want to change this later on
/usr 3Gbytes
/opt 6bytes
/var 5Gbytes

This leaves me a few Gbytes for expansion later on. Any comment is welcome. Thanks.
Reputation of a thousand years can be determined by the conduct of an hour
Steven E. Protter
Exalted Contributor
Solution

Re: Running Oracle on Lseries HP-UX 11i

Root is a waste of space. I keep it at a 1 GB and that is a waste of space. There really should not be any files on the root filesystem(Bill Hassell).

Otherwise I think you are in good shape if you follow the advice above.

It is customary to awared points to those that help you. If we have been helpful, please let us know.

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
Tim D Fulford
Honored Contributor

Re: Running Oracle on Lseries HP-UX 11i

Hi

/stand is a bit generous
/ is VERY generous. i know you just want to ensure that it is big enough for the future, but Ignite-UX has solved that particular problem.

My personal preference is to make /var & /usr, /opt quite large. I like /var to be about 1GB (or so) bigger than so any savecrashes/crashdumps will easily fit.

stricktly speaking should be >= RAM+kernel size. With 8GB RAM I would have swap of about 9GB swap, so 10GB for /var. So putting this on your figures is...

/stand 1 Gbytes
9 Gbytes (> RAM)
/ 1 Gbytes
/home 200 Mbytes
/tmp 1 Gbytes
/usr 3 Gbytes
/opt 6 Gbytes
/var 10 Gbytes (swap+ 1GB)

Regards

Tim
-
Ken Hubnik_2
Honored Contributor

Re: Running Oracle on Lseries HP-UX 11i

Everything looks good but I agree with SEP. / is way to big. It should never grow that big 500 mg is plenty for / and that is even overkill.
A. Clay Stephenson
Acclaimed Contributor

Re: Running Oracle on Lseries HP-UX 11i

If / needs to be more than 256MB (and that is very, very generous -- something is seriusly wrong. I would reduce / to no more than 256MB and limit /stand to no more than 256MB -- and again those are generous and will allow for OS upgrades quite easily.
If it ain't broke, I can fix that.
K.C. Chan
Trusted Contributor

Re: Running Oracle on Lseries HP-UX 11i

Team thanks for your help. I will award points later when I am done with this. OK, Now I'm confused about the size of swap, does the old shool rule of thumb still stands, swap should be at least 2xsize of memory. From this thread, I get one guy saying 4Gbytes of swap is the min. for taking an OS core dump. I have another guy saying 9Gbytes (which I think somewhat aggreeable). Any input is welcome. Thanks.
Reputation of a thousand years can be determined by the conduct of an hour
K.C. Chan
Trusted Contributor

Re: Running Oracle on Lseries HP-UX 11i

Team,
if I plan to use the 2nd 36Gbytes disk as the mirror can I interleave swap? Instead of having one swap the size of 9Gbytes, is it possible to have 5Gbytes on each disk (giving a total of 10)? How would this affect my ability to take OS Core dump, considering the system have 8Gbytes of memory? Thanks.
Reputation of a thousand years can be determined by the conduct of an hour
K.C. Chan
Trusted Contributor

Re: Running Oracle on Lseries HP-UX 11i

OK, I noticed the default installs for file system /stand is still hfs type. I thought HP had moved this to Vxfs as well. Could someone shed some lights onto this? Thanks.
Reputation of a thousand years can be determined by the conduct of an hour
Tim D Fulford
Honored Contributor

Re: Running Oracle on Lseries HP-UX 11i

in 11i I believe it does support vxfs as /stand, but I do not know if you need to purchase anything special to get this.

regards

Tim
-