Configure Kernel Parameters For Oracle

[arakh]

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!

[Suraj K Sankari]

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

[Steven E. Protter]

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

[Johnson Punniyalingam · Accepted solution]

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

[Dennis Handly]

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

[arakh]

Thanks for your answer!

[arakh]

Thanks