HPUX requirements for oracle

[lawrenzo_1]

Hi guys,

We have an rx4640 running HPUX11i-v2 and are going to install oracle database onto the server.

can someone tell me what system requirments, patches and filesystem's that are required ?

checklist etc.

cheers.

Lawrenzo

[Darrel Louis · Accepted solution]

Lawrenco,

Please read the following two threads started today aswell:

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=1037435
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=1037434

Darrel

[Steven E. Protter]

Shalom Lawrenzo,

I'd recommend the March 2006 QPK for the OS.

In addition, the following requirements come from metalink.oracle.com

The actual requirements vary greatly by what version of Oracle you are choosing.

10.2

GOLDQPK11i, December 2004 or later
If GOLDQPK is not installed then these two patchkits need to be installed:
GOLDAPPS11i, December 2004 or later
GOLDBASE11i, December 2004 or later

11.11 required patches:
o PHNE_31097 s/b PHNE_32477 s/b PHNE_33498
o PHSS_31221 s/b PHSS_33263
For JDK, refer to HP Java for latest patches:
o PHSS_30970 s/b PHSS_33033
For PL/SQL/ProC,OCI,OCCI,XDK:
o PHSS_32508 s/b PHSS_34411
o PHSS_32509 s/b PHSS_34412
o PHSS_32510 s/b PHSS_34413

11.23 (PA-RISC) required patches:
o PHSS_31849
o PHSS_31852
For PL/SQL/ProC,OCI,OCCI,XDK:
o PHSS_32511
o PHSS_32512
o PHSS_32513

11.23 (Itanium) required patches:
The following operating system patches:
o BUNDLE11i B.11.23.0409.3: Patch Bundle for HP-UX 11i V2
Note: You must have the August 2004 version of BUNDLE11i B.11.23.0408.1 for HP-UX 11i v2 on your system prior to updating to the HP-UX 11i v2 September 2004 or later release.
o PHCO_32426
o PHKL_32646
o PHKL_32632 s/b PHKL_33656 s/b PHKL_33807
o PHKL_32645
o PHKL_33552 s/b PHKL_33563
o PHSS_31850 s/b PHSS_34040
o PHSS_31851 s/b PHSS_34043
o PHSS_31854 s/b PHSS_33357 s/b PHSS_34045
o PHSS_31855 s/b PHSS_33350 s/b PHSS_34041
o PHSS_33275 s/b PHSS_33349 s/b PHSS_34040
o PHSS_33276 s/b PHSS_34042

For PL/SQL native compilation and installation of Pro*C/C++, Oracle Call Interface, Oracle C++ Call Interface, or Oracle XML Developer's Kit (XDK) , the following patches are required:
o PHSS_33278
o PHSS_33277

The following JDK patches:
o PHCO_31553 s/b PHCO_33675
o PHKL_31500
o PHSS_32213 s/b PHSS_32502 s/b PHSS_34201
Note: Refer to the following Web site for information about additional patches that may be required by JDK 1.4.2:
HP Java Patches

Kernel Settings
KSI_ALLOC_MAX (NPROC*8)
EXECUTABLE_STACK=0
MAX_THREAD_PROC 1024
MAXDSIZ 1073741824 bytes
MAXDSIZ_64BIT 2147483648 bytes
MAXSSIZ 134217728 bytes
MAXSSIZ_64BIT 1073741824
MAXSWAPCHUNKS 16384*
MAXUPRC ((NPROC*9)/10)
MSGMAP (MSGTQL+2)
MSGMNI NPROC
MSGSEG 32767
MSGTQL 4096
NCSIZE (NINODE+1024)*
NFILE (15*NPROC+2048)
NFLOCKS 4096
NINODE (8*NPROC+2048)
NKTHREAD (((NPROC*7)/4)+16)
NPROC 4096
SEMMAP (SEMMNI+2)*
SEMMNI 4096
SEMMNS (SEMMNI*2)
SEMMNU (NPROC - 4)
SEMVMX 32767
SHMMAX AvailMem
SHMMNI 512
SHMSEG 120
VPS_CEILING 64

* MAXSWAPCHUNKS, SEMMAP, and VX_NCSIZE are obsolete on 11.23 PA-RISC and IPF and no longer need to be set
Set NCSIZE = (NINODE+1024)

10.1

Patching
Per HP Bug (Doc ID: KBRC00003627)
NOTE: This bug is not applicable to 11.23 The default 64bit OS installation does not create a few required X library symbolic links. The following symbolic links need to be created:
(NOTE: These task is required only if the Motif 2.1 Development Environment Package ( X11MotifDevKit.MOTIF21-PRG ) is not installed ).
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

GOLDQPK11i, June 2003 or later
If GOLDQPK is not installed then these two patchkits need to be installed:
GOLDAPPS11i, June 2003 or later
GOLDBASE11i, June 2003 or later
Jun03GQPK11i_Aux_Patch (Does not exist, see Bug 3512068)

X11MotifDevKit (spatial only)
o PHCO_28123 s/b PHCO_31314 s/b PHCO_32397
o PHKL_29198 s/b PHKL_32603
o PHNE_28476 s/b PHNE_29825 s/b PHNE_30367 s/b PHNE_31091 s/b PHNE_33729
o PHNE_28923 s/b PHSS_30049 s/b PHNE_32396 s/b PHNE_33704
o PHSS_28871 s/b PHSS_33033
o PHSS_28880 s/b PHSS_32573 s/b PHSS_33263
o PHCO_26331 s/b PHCO_27958 s/b PHCO_33205
o PHCO_29109 s/b PHCO_29960 s/b PHCO_30544
o PHKL_25468 s/b PHKL_30542
o PHKL_25842 s/b PHKL_30288 s/b PHKL_34311
o PHKL_25993
o PHKL_25994 s/b PHKL_32061 s/b PHKL_34309
o PHKL_25995 s/b PHKL_30541 s/b PHKL_32457 s/b PHKL_34024
o PHKL_26468 s/b PHKL_27316 s/b PHKL_30837
o PHKL_28489

HP-UX 11.23 (IA64) Operating System Patches:
o PHSS_29658 s/b PHSS_30015 s/b PHSS_30237
o PHSS_29660

Java SDK 1.4.2 latest patches

Ensure that unzip version is 5.5 or higher ($ unzip -v) [reference Note 263692.1], if not it can be downloaded here

Kernel
KSI_ALLOC_MAX (NPROC*8)
MAX_THREAD_PROC 256
MAXDSIZ 1073741824 bytes
MAXDSIZ_64BIT 2147483648 bytes
MAXSSIZ 134217728 bytes
MAXSSIZ_64BIT 1073741824
MAXSWAPCHUNKS 16384*
MAXUPRC ((NPROC*9)/10)
MSGMAP (2+MSGMNI)
MSGMNI NPROC
MSGSEG 32767
MSGTQL 4096
NCSIZE (NINODE+VX_NCSIZE)*
NFILE (15*NPROC+2048)
NFLOCKS 4096
NINODE (8*NPROC+2048)
NKTHREAD (((NPROC*7)/4)+16)
NPROC 4096
SEMMAP (SEMMNI+2)*
SEMMNI 4096
SEMMNS (SEMMNI*2)
SEMMNU (NPROC - 4)
SEMVMX 32768
SHMMAX AvailMem
SHMMNI 512
SHMSEG 120
VPS_CEILING 64

* MAXSWAPCHUNKS, SEMMAP, and VX_NCSIZE are obsolete on 11.23 PA-RISC and IPF and no longer need to be set
Set NCSIZE = (NINODE+1024)


Oracle 9.2
HP-UX 11.0(64 bit) Operating System Patches:
Sept 2001 Quality Pack
o PHCO_23792 s/b PHCO_26960
o PHCO_24148 s/b PHCO_25707 s/b PHCO_27608 s/b PHCO_28425 s/b PHCO_32448
o PHKL_24268 s/b PHKL_27178 (has been recalled by HP may destroy logical volumes on PVGs - more info s/b PHKL_32920
o PHKL_24729 s/b PHKL_29256
o PHKL_25475 s/b PHKL_27510 s/b PHKL_30553
o PHKL_25525 s/b PHKL_27364 s/b PHKL_28766 s/b PHKL_31867
o PHNE_24715 s/b PHNE_26771 s/b PHNE_29473 s/b PHNE_32041 s/b PHNE_33395
o PHSS_23670 s/b PHSS_26138 s/b PHSS_27858
o PHSS_24301 s/b PHSS_26273 s/b PHSS_28433 (only needed for C++ compiler and Pro*C++)
o PHSS_24303 s/b PHSS_26559 s/b PHSS_30965
o PHSS_24627 s/b PHSS_26945 s/b PHSS_32574
o PHSS_22868 (only needed for C++ compiler and Pro*C++)

Ensure that unzip version is 5.5 or higher ($ unzip -v) [reference Note 263692.1], if not it can be downloaded here

HP-UX 11i (64 Bit) Operating System Patches:
Support Plus Bundle 'December 2002 SP-0212' or later
JDK 1.3.1.02
o PHCO_24402 s/b PHCO_25569 s/b PHCO_31923
o PHCO_28427 s/b PHCO_29029 s/b PHCO_31903 s/b PHCO_33533
o PHKL_25506 s/b PHKL_33457
o PHNE_27144 s/b PHNE_27745 s/b PHNE_30580 (For RAC systems)
o PHNE_28568 s/b PHNE_30378 s/b PHNE_32477 s/b PHNE_33315
o PHSS_26263 s/b PHSS_26560 s/b PHSS_33033
o PHSS_24638 s/b PHSS_26946 s/b PHSS_30966 s/b PHSS_33263
o PHSS_26774 s/b PHSS_28849 s/b PHSS_30742 (For ServiceGuard 11.13 systems)

HP-UX 11.22 (IA64) Operating System Patches:
o PHSS_27284 s/b PHSS_28977
o PHSS_27285 s/b PHSS_28970
o PHSS_27286 s/b PHSS_28978
o PHSS_27287 s/b PHSS_29652
o PHSS_27288 s/b PHSS_28971
o PHSS_27289 s/b PHSS_29653
o PHSS_27290 s/b PHSS_28973
o PHSS_27291 s/b PHSS_28969
o PHSS_27292 s/b PHSS_29654
o PHSS_27293 s/b PHSS_28975
o PHKL_28465

Kernel

KSI_ALLOC_MAX (NPROC*8)
MAX_THREAD_PROC 256
MAXDSIZ 1073741824 bytes
MAXDSIZ_64BIT 2147483648 bytes
MAXSSIZ 134217728 bytes
MAXSSIZ_64BIT 1073741824
MAXSWAPCHUNKS 16384*
MAXUPRC ((NPROC*9)/10)
MSGMAP (MSGTQL+2)
MSGMNI NPROC
MSGSEG 32767
MSGTQL NPROC
NCALLOUT (NKTHREAD+16)*
NCSIZE ((8*NPROC+2048)+VX_NCSIZE)*
NFILE (15*NPROC+2048)
NFLOCKS 4096
NINODE (8*NPROC+2048)
NKTHREAD (((NPROC*7)/4)+16)
NPROC 4096
SEMMAP (SEMMNI+2)*
SEMMNI 4096
SEMMNS (SEMMNI*2)
SEMMNU (NPROC - 4)
SEMVMX 32768
SHMMAX AvailMem
SHMMIN 1
SHMMNI 512
SHMSEG 32
VPS_CEILING 64

* MAXSWAPCHUNKS, SEMMAP, NCALLOUT, and VX_NCSIZE are obsolete on 11.23 PA-RISC and IPF and no longer need to be set
Set NCSIZE = (NINODE+1024)

Hope I've covered it here. Next time, please be a bit more specific.

SEP

[lawrenzo_1]

Thanks guys,

and wow cheers Steve - that's greatly appreciated, not sure what level of Oracle is yet.

I changed job not so long ago and am working at an IBM house now however we have purchasing some HP kit which is great and my role has changed to 3rd line.


Muchas Gracias!

Chris.

[Darrel Louis]

Lawrenzo,

Te nada.
GoodLuck with your new role.

Steve well done
Hasta la bista

Darrel

[lawrenzo_1]

ty guys