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