From owner-freebsd-database@FreeBSD.ORG Mon Aug 18 12:34:33 2003 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 7D3F937B419 for ; Mon, 18 Aug 2003 12:34:33 -0700 (PDT) Received: from lakemtao01.cox.net (lakemtao01.cox.net [68.1.17.244]) by mx1.FreeBSD.org (Postfix) with ESMTP id A9F3243F93 for ; Mon, 18 Aug 2003 12:34:31 -0700 (PDT) (envelope-from brian@shadowcom.net) Received: from shadowcom.net ([68.100.212.237]) by lakemtao01.cox.net (InterMail vM.5.01.04.05 201-253-122-122-105-20011231) with SMTP id <20030818193431.IKXU7142.lakemtao01.cox.net@shadowcom.net> for ; Mon, 18 Aug 2003 15:34:31 -0400 Received: (qmail 77269 invoked by uid 500); 18 Aug 2003 19:35:29 -0000 Date: Mon, 18 Aug 2003 15:35:29 -0400 From: Brian Ledbetter To: Berend de Boer Message-ID: <20030818193529.GA77206@shadowcom.net> References: <20030818145638.GA75929@shadowcom.net> <871xvikdyl.fsf@dellius.nederware.nl> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <871xvikdyl.fsf@dellius.nederware.nl> User-Agent: Mutt/1.4i cc: freebsd-database@freebsd.org Subject: Re: Oracle 9i - "Out Of Memory" error? X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 18 Aug 2003 19:34:33 -0000 > 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 http://www.shadowcom.net/brian/