Simpler Navigation for Servers and Operating Systems
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.
Operating System - Tru64 Unix
cancel
Showing results for 
Search instead for 
Did you mean: 

ulimit setting for Oracle

Binubaby
Frequent Advisor

ulimit setting for Oracle

Hello
I want to set ulimit on an alpha server ES40 Tru64 5.1b PK4 with 2gb of RAM to setup oracle.
Please infom how to configure ulimit for user oracle what are the syntax i can use
It gives me error: limit exeeds
Which shell I can use for oracle?
How can I keep the values permenant

Please help
Thanks
Bins
BB
3 REPLIES
Vladimir Fabecic
Honored Contributor

Re: ulimit setting for Oracle

How to configure ulimit for user oracle?
Give some more details. You got error limit exeeds after what?
Did you look at man pages of ulimit and sys_attrs_proc?
You can use any shell for oracle. I ussualy use ksh.
You can keep values permanent if you put line with ulimit in .profile of oracle user.
In vino veritas, in VMS cluster
Joris Denayer
Respected Contributor

Re: ulimit setting for Oracle

Bins,

I suppose you want to increase the size of the data-segment. This can be incresed if you are superuser. Another user cannot increase the datasegment.

You also cannot go higher than the value defined by the sysconfigtab variable max_per_proc_data_size.

As previously mentioned, these parameters are explained in # man sys_attrs_proc

The parameter values to implement should be described in the installation manual of Oracle.
To err is human, but to really faul things up requires a computer
Binubaby
Frequent Advisor

Re: ulimit setting for Oracle

Hello
Thanks for the help, I have put the ulimit values in the .profile and it worked.
My DBA informed that he is experiencing performance problem
Current : Tru64 5.1b PK4, Oracle 10g OracleAS
Any further performance tuning required or any idea about updating PK5

Thanks
Bins
BB