Oracle 9i - "Out Of Memory" error?

Brian Ledbetter brian at shadowcom.net
Mon Aug 18 12:34:33 PDT 2003


> 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 at shadowcom.net>
http://www.shadowcom.net/brian/


More information about the freebsd-database mailing list