ulimit for oracle10

[franlo]

Hello,

I have an es45 4Go ram on 5.1b patchkit 6 and we want to install oracle10g.

I want to increase the data limit for oracle10 user, but the command ulimit -d 1024000 sent me "exceeds allowable limit"

I think kernel parametters are ok but i don't understand how can i increase this.


Thank for your help

francois



here the configuration :

>ulimit -a
+ ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 256000
stack(kbytes) 2097152
memory(kbytes) 4068384
coredump(blocks) unlimited
nofiles(descriptors) 4096
vmemory(kbytes) 67108864

>ulimit -Hm
+ ulimit -Hm
4068384

>sysconfig -q ipc
+ sysconfig -q ipc
ipc:
msg_max = 8192
msg_mnb = 16384
msg_mni = 64
msg_tql = 40
shm_max = 4278190080
shm_min = 1
shm_mni = 512
shm_seg = 512
sem_mni = 512
sem_msl = 512
sem_opm = 512
sem_ume = 512
sem_vmx = 32767
sem_aem = 16384
sem_broadcast_wakeup = 0
max_kernel_ports = 56864
ssm_threshold = 8388608
ssm_enable_core_dump = 1
shm_allocate_striped = 1
shm_enable_core_dump = 1
pshared_hash_size = 2048

>sysconfig -q proc
+ sysconfig -q proc
proc:
max_proc_per_user = 1024
max_threads_per_user = 1024
per_proc_stack_size = 2147483648
max_per_proc_stack_size = 2147483648
per_proc_data_size = 68719476736
max_per_proc_data_size = 68719476736
max_per_proc_address_space = 68719476736
per_proc_address_space = 68719476736
executable_stack = 0
autonice = 0
autonice_time = 600
autonice_penalty = 4
open_max_soft = 4096
open_max_hard = 4096
ncallout_alloc_size = 8192
round_robin_switch_rate = 0
sched_min_idle = 0
give_boost = 1
maxusers = 512
num_wait_queues = 512
num_timeout_hash_queues = 512
enhanced_core_name = 0
enhanced_core_max_versions = 16
exec_disable_arg_limit = 1
dump_cores = 1
dump_setugid_cores = 0
executable_data = 0

[Hein van den Heuvel]

Francois,

Your kernel parameters are NOT ok.

They do not follow the requirements as documented by Orace in Ch 2, "Configure Kernel Subsystem Attributes" in the installation guide:

http://www.oracle.com/pls/db102/to_pdf?pathname=install.102%2Fb25300.pdf&remark=portal+%28Getting+Started%29

Specifically, the stack_size setting is silly. Recommended is 32M, max is really 512M, not 2G.

The Address Space settings also appear excessive, but that should be ok.

Be sure to also check out:

http://h71028.www7.hp.com/ERC/downloads/4AA0-9949ENW.pdf

Hope this helps some,
Hein van den Heuvel (at gmail dot com)
HvdH Performance Consulting