Oracle 9i - "Out Of Memory" error?
Valery V.Chikalov
valera at novakom.dp.ua
Mon Aug 18 23:20:40 PDT 2003
i'm happy with Oracle9i, FreeBSD 5.1R
and this values in kernel config file as well
options MAXDSIZ="(1024*1024*1024)"
options DFLDSIZ="(1024*1024*1024)"
look at http://www.opennet.ru/docs/RUS/oracle_freebsd/index.html (in russian)
Brian Ledbetter wrote:
>>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. :)
>
>
>
More information about the freebsd-database
mailing list