Oracle 10g installation on HP UX 11.23 - Patches & Kernal Parameters needed

[Sundar G]

Hi All,

I am going to install Oracle 10g Database in a clustered environment. Can you provide me the details for the following?

1. What are all the HP UX OS Patches required for installing oracle 10g database?

2. What are the ideal kernal parameters and selection methods?

Thanks in advance

Regards

Sundar

[Luk Vandenbussche]

Hi Sundar,

Check the release notes here

http://download.oracle.com/docs/cd/B19306_01/relnotes.102/b25292/toc.htm

[Steven E. Protter]

Shalom Sundar,

There are no ideal kernel parameters. You will be fine if you meet Oracle minimums and take them from another Oracle System.

Service Guard Extension for RAC
PHSS_32659 - s700_800 11.23 Serviceguard Extension for RAC 11.16.00
Release Date: Sun Apr 17 7:15:21 EDT 2005

* open(2);file descriptor;fcntl(2)
PHKL_32747 - s700_800 11.23 open(2);file descriptor;fcntl(2)
Release Date: Sun Mar 13 7:15:30 EST 2005

* NFS cumulative patch
PHNE_32055 - s700_800 11.23 NFS cumulative patch
Release Date: Sun Mar 13 7:15:30 EST 2005

* HP C Compiler
PHSS_34046 - s700_800 11.23 HP C Compiler (A.06.06)
Release Date: 2005/11/30

* aC++ Compiler
PHSS_34047 - s700_800 11.23 aC++ Compiler (A.06.06)
Release Date: 2005/12/05

* mmap(2) Data Corruption Fix
PHKL_33049 - s700_800 11.23 mmap(2) Data Corruption Fix
Release Date: Sun Aug 14 7:15:29 EDT 2005

* libc cumulative patch
PHCO_33173 - s700_800 11.23 libc cumulative patch
Release Date: Sun Oct 9 7:15:15 EDT 2005

* pthread library cumulative patch
PHCO_32489 - s700_800 11.23 pthread library cumulative patch
Release Date: Sun Oct 30 7:15:25 EST 2005

If you don't run Serviceguard, skip that patch.

10.2 10g



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:

Java Patches

http://h18012.www1.hp.com/java/patches/index.html

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



10.1 10g

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

Same link as above for java patches.

Java 1.4.2 or higher required.

Kernel Settings

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)

All I have to say is, dude, you need metalink access to bring this off.

SEP

[Oviwan]

Hey

If you have a metalink account check this two articles:

Oracle Database on AIX,HP-UX,Linux,MacOSX,Solaris,Tru64 Operating Systems Installation and Configuration Requirements Quick Reference (8.0.5 to 10.2)
Note:169706.1

and

Pre-Install checks for 10gR2 RDBMS (10.2.x) - HPUX PA-RISC and Itanium Platforms
Note:334563.1

Regards

[paolo barila]

I had to install Oracle patch 4516865 on client side to setup correct filesystem permissions

[Juan_20]

Hi
Why don´t install ALL the patchs ??
It´s very easy. Go to:
http://www8.itrc.hp.com/service/patch/assessSystemsPage.do?BC=main|
run swinv script and dowload all the patches that are not installed into your system.
Easy.

[Anshumali]

Pre-Install check
If you are ok with time, all patches missing with use of CPM, swainv->Inventory.xml->Required patches.->UAT
But this will not advise for the kernel parameters, so stick with Pre-Install check.