Date: Mon, 18 Aug 2003 15:35:29 -0400 From: Brian Ledbetter <brian@shadowcom.net> To: Berend de Boer <berend@pobox.com> Cc: freebsd-database@freebsd.org Subject: Re: Oracle 9i - "Out Of Memory" error? Message-ID: <20030818193529.GA77206@shadowcom.net> In-Reply-To: <871xvikdyl.fsf@dellius.nederware.nl> References: <20030818145638.GA75929@shadowcom.net> <871xvikdyl.fsf@dellius.nederware.nl>
next in thread | previous in thread | raw e-mail | index | archive | help
> The Oracle install guide contains a list of things that must be
> set. *must*. Just take the Linux values, I suppose that should be good
> enough for FreeBSD as well.
I've set the values on my system to match the list as close as I could,
and I still get the error. Here're my current settings - what am I
missing? I assume you configured most of these values in your
/sys/i386/conf/(SYSTEM) file?
# sysctl -a | grep shm
kern.ipc.shmmax: 2147483647
kern.ipc.shmmin: 1
kern.ipc.shmmni: 4096
kern.ipc.shmseg: 4096
kern.ipc.shmall: 8192
kern.ipc.shm_use_phys: 0
shm 4 257K 289K 34 16,32768
# sysctl -a | grep sem
kern.ipc.semmap: 128
kern.ipc.semmni: 128
kern.ipc.semmns: 32000
kern.ipc.semmnu: 30
kern.ipc.semmsl: 250
kern.ipc.semopm: 250
kern.ipc.semume: 10
kern.ipc.semusz: 92
kern.ipc.semvmx: 32767
kern.ipc.semaem: 16384
acpisem 17 3K 3K 17 128
sem 4 396K 396K 4 4096,8192
# grep S.M /sys/i386/conf/HOMSAR | grep -v SYSV
options SEMMAP=128
options SEMMNI=128
options SEMMNS=32000
options SEMOPM=250
options SEMMSL=250
options SHMMAX=1073741824 # A value of 2048*1024*1024 produced a compile error,
# so I set this in /etc/sysctl.conf
options SHMMNI=4096
options SHMSEG=4096
# grep shm /etc/sysctl.conf
kern.ipc.shmmax=2147483647
Thanks for your help! Sorry if I'm bothering you. :)
--
Brian C. Ledbetter <brian@shadowcom.net>
http://www.shadowcom.net/brian/
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20030818193529.GA77206>