From owner-freebsd-database@FreeBSD.ORG Mon Aug 18 23:20:40 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 08DC616A4BF for ; Mon, 18 Aug 2003 23:20:40 -0700 (PDT) Received: from ns.novakom.com.ua (ns.novakom.com.ua [217.196.173.70]) by mx1.FreeBSD.org (Postfix) with SMTP id 6D96E43F93 for ; Mon, 18 Aug 2003 23:20:36 -0700 (PDT) (envelope-from valera@novakom.dp.ua) Received: (qmail 16959 invoked from network); 19 Aug 2003 06:20:32 -0000 Received: from post.novakom.dp.ua (HELO novakom.dp.ua) (192.168.1.254) by fpost.novakom.dp.ua with SMTP; 19 Aug 2003 06:20:32 -0000 Received: (qmail 31504 invoked from network); 19 Aug 2003 06:20:31 -0000 Received: from goliath.novakom.dp.ua (HELO novakom.dp.ua) (192.168.1.210) by post.novakom.dp.ua with SMTP; 19 Aug 2003 06:20:31 -0000 Message-ID: <3F41C1AF.1080500@novakom.dp.ua> Date: Tue, 19 Aug 2003 09:20:31 +0300 From: "Valery V.Chikalov" User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4b) Gecko/20030328 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Brian Ledbetter References: <20030818145638.GA75929@shadowcom.net> <871xvikdyl.fsf@dellius.nederware.nl> <20030818193529.GA77206@shadowcom.net> In-Reply-To: <20030818193529.GA77206@shadowcom.net> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit 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: Tue, 19 Aug 2003 06:20:40 -0000 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. :) > > >