[HELP] Problem in installation oracle 10 about kernel parm and ulimit

[stanley khNg]

Hi oracle experts,

OS :HPUX 11.23
Server: RP3440
Product: Oracle Collaboration Suite Product Version: 10.1.2.0.0

In setting up the oracle, I need to run ulimit to change some OS setting.

# ulimit -aH
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 4292870144
stack(kbytes) 392192
memory(kbytes) unlimited
coredump(blocks) unlimited
# ulimit -s 1048576
ksh: ulimit: exceeds allowable limit

Why I cannot set the ulimit -s
Is it already in max value?
Is it necessary to set so large?

Any supporting reference during installation of oracle?

I need to finish this step in order to keep installing the oracle.

Thanks!!!!

Stanley

[Srikanth Arunachalam]

Hi,

I have configured several databases in HP-UX 11.23 and I bet that you do not need to set the ulimit size.

It is sufficient that you increase the kernel parameter maxssiz, maxdsiz, maxsiz_64

A user can decrease ulimit but cannot increase it. Also, the ulimits cannot exceed the hard limits set by the kernel tunables.

The following are the standard parameter I used to set for Oracle installation on hp-ux 11.23 server.

kctune -s vps_ceiling=64
kctune -s shmmni=512
kctune -s semmnu=4092
kctune -s semmns=8192
kctune -s semmni=4096
kctune -u -s semmap=4098
kctune -s ninode=34816
kctune -s ncsize=34816
kctune -s msgtql=4096
kctune -s msgseg=32767
kctune -s msgmni=4096
kctune -s msgmap=4098
kctune -s max_thread_proc=1024
kctune -s maxuprc=3687
kctune -s ncsize=35840
kctune -s maxssiz=134217728
kctune -s maxssiz_64bit=1073741824
kctune -s -u maxswapchunks=16384
kctune -s dbc_min_pct=5
kctune -s dbc_max_pct=5

Thanks,
Srikanth

[Dennis Handly]

>Why I cannot set the ulimit -s? Is it already in max value?

Your hardlimit is 392192 Kb. Setting maxssiz that big will not let you execute any 32 bit apps! maxssiz takes away from maxdsiz.

Also you should be looking at kctune for the raw kernel values:
$ /usr/sbin/kctune | grep max.siz

[stanley khNg]

Hi Srikanth,

Is there any doc. supporting there is no need to use ulimit -s to change the setting?

I asked the Oracle support. The said it is on OS side problem. Need to increase the stack size by ulimit -s.

I also checked some reference, the ulimit will take the min value of maxssiz and maxssiz_64bit.

Thus, it is impossible to set the stack size to 1048576, right?

Any kernel or OS setting need to tune and take care during installation of oracle?

[Dennis Handly]

>it is impossible to set the stack size to 1048576, right?

With ulimit you are setting it to 1048576 * 1024 bytes!

[stanley khNg]

Hi all,

You guys are so nice and helpful.

maxssiz 401604608
maxssiz_64bit 1073741824

stack(kbytes) 392192 is all I can tune in the OS.

But the Oracle support said I need to tune it to 1048576.

How can I do it? Or I really no need to tune it to that large?

Many Thanks!
Stanley

[Dennis Handly]

>maxssiz 401604608
>maxssiz_64bit 1073741824
>But the Oracle support said I need to tune it to 1048576.

You already have maxssiz_64bit at ~ 1 Gb.
Just ignore what ulimit gives since it doesn't handle the 32 vs 64 bit values.

>Or I really no need to tune it to that large?

I would say that having a stack that big is overkill. You do need data (heap) that big or even bigger.

I would suggest you now let Oracle's installation scripts check what you have.

[Srikanth Arunachalam]

Hi Stan,

Plz find the attachment containing the recent pre-installation checks. If you still have problem with ulimit, you can always set it as

#> "ulimit unlimited"

but, to my knowledge I never have changed this parameter for installation of Oracle.

Thanks,
Srikanth