Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

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

stanley khNg
Occasional Contributor

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

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
7 REPLIES
Srikanth Arunachalam
Trusted Contributor

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

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
Acclaimed Contributor

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

>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
Occasional Contributor

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

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
Acclaimed Contributor

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

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

With ulimit you are setting it to 1048576 * 1024 bytes!
stanley khNg
Occasional Contributor

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

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
Acclaimed Contributor

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

>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
Trusted Contributor

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

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