Oracle/ulimit

From: Paul Kitwin <PAUKIT_at_HBSI.COM>
Date: Tue, 10 Jun 1997 09:46:44 -0700

ANY ASSISTANCE IS APPRECIATED

I have an 8400 w/ 4 Gb of RAM running (or trying to run) an oracle
database.

We are having trouble getting the ulimit (max filesize and max sh mem)
to work.

Here is my sysconfigtab:

vm:
  ubc-minpercent=1
  ubc-maxpercent=2
  vm-maxvas=4294967296
  vm-mapentries=400

ipc:
  sem-mni=200
  sem-msl=200
  sem-opm=200
  sem-ume=200
  sem-aem=16384
  sem-vmx=32767
  shm-mni=512
  num-of-sems=200
  msg-mni=1024
  msg-tql=4096
  shm-max=2118123520
  shm-seg=32
  msg-max=8192
  msg-mnb=16384

proc:
  max-per-proc-address-space=4294967296
  max-proc-per-user=1024
  max-threads-per-user=1024

And ulimit from root as well as oracle

ROOT
(arthur)# ulimit
cputime unlimited
filesize unlimited
datasize 131072 kbytes
stacksize 2048 kbytes
coredumpsize unlimited
memory 4118880 kbytes
descriptors 4096 files
addressspace 1048576 kbytes

ORACLE
arthur:oracle> ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 4194304
stack(kbytes) 32768
memory(kbytes) 4118000
coredump(blocks) unlimited
nofiles(descriptors) 4096
vmemory(kbytes) 4194304

When my DBA starts up the database, he is getting an error saying "not
enough space"


>From the computer of

Paul "Danger" Kitwin
International Man of Mystery!
Received on Tue Jun 10 1997 - 19:02:17 NZST

This archive was generated by hypermail 2.4.0 : Wed Nov 08 2023 - 11:53:36 NZDT