topic Re: Configure Kernel Parameters For Oracle in Operating System - HP-UX

Configure Kernel Parameters For Oracle

arakh — Tue, 31 Mar 2009 06:58:23 GMT

Hello all:
I want to install Oracle 10g release2 on my hpux
11.23. Following the instruction of Oracle Documention,i need to tune several kernel parameters,such as "ksi_alloc_max","executable_stack" and so on.
Can somebody tell me how to do this in command line or create a simple shell instead of using sam tools. Thanks!

Re: Configure Kernel Parameters For Oracle

Suraj K Sankari — Tue, 31 Mar 2009 07:11:30 GMT

Hi,
From command line you can change the value like this

kctune for 11.v2
kmtune for 10.2

kctune -s msgseg=32767
kmtune maxswapchunks=16384

-s -> Set the value to a system parameter

Suraj

Re: Configure Kernel Parameters For Oracle

Steven E. Protter — Tue, 31 Mar 2009 07:16:48 GMT

Shalom,

Lots more work to tune for Oracle:

File system tuning
http://www.docs.hp.com/en/10404/ODM_SingleinstanceOracle.pdf

9i Thread, all of which applies to newer versions of Oracle:

http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1115729

10g
http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1175744

Installation issues:
http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1203518

10g Kernel Thread:
http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1043965

This is a FAQ on HP-UX

SEP

Re: Configure Kernel Parameters For Oracle

Johnson Punniyalingam — Tue, 31 Mar 2009 07:17:10 GMT

It all depends on whether the tunable
parameter is dynamic or not. In other words,
you need to check if a change can happen without a reboot.

Let's pick up one of your tunables:

# kctune -v shmmax

The system shows:

Tunable shmmax
Description Maximum size of a shared memory segment (bytes)
Module sysv_shm
Current Value 1073741824 [Default]
Value at Next Boot 1073741824 [Default]
Value at Last Boot 1073741824
Default Value 1073741824
Constraints shmmax >=3D 2048
shmmax <=3D 4398046511104
Can Change Immediately or at Next Boot

Look for "Can Change" row. Therefore,
shmmax can be changed without the reboot.

To change, you can use SAM or SMH interface,
or command-line (I prefer it):

# kctune shmmax=...

Thanks,
Johnson

Re: Configure Kernel Parameters For Oracle

Dennis Handly — Tue, 31 Mar 2009 15:13:43 GMT

For executable_stack:
http://docs.hp.com/en/B2355-60130/executable_stack.5.html

Re: Configure Kernel Parameters For Oracle

arakh — Wed, 01 Apr 2009 00:43:27 GMT

Thanks for your answer!

Re: Configure Kernel Parameters For Oracle

arakh — Wed, 01 Apr 2009 00:44:13 GMT

Thanks