From owner-freebsd-database@FreeBSD.ORG Tue Aug 19 07:02:12 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 2D4A716A4BF for ; Tue, 19 Aug 2003 07:02:12 -0700 (PDT) Received: from lakemtao01.cox.net (lakemtao01.cox.net [68.1.17.244]) by mx1.FreeBSD.org (Postfix) with ESMTP id 68D6243F85 for ; Tue, 19 Aug 2003 07:02:10 -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 <20030819140209.RAPL7142.lakemtao01.cox.net@shadowcom.net> for ; Tue, 19 Aug 2003 10:02:09 -0400 Received: (qmail 82795 invoked by uid 500); 19 Aug 2003 14:03:10 -0000 Date: Tue, 19 Aug 2003 10:03:10 -0400 From: Brian Ledbetter To: Roberto Nunnari Message-ID: <20030819140310.GA82534@shadowcom.net> References: <20030818145638.GA75929@shadowcom.net> <3F41D45F.2020608@die.supsi.ch> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3F41D45F.2020608@die.supsi.ch> 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: Tue, 19 Aug 2003 14:02:12 -0000 Thank you very much for your help, gentlemen! My Oracle database boots up and works just fine now! :) For the record, here are the parameters I used in my kernel configuration. I hope they are helpful to other people hoping to play with Oracle 9i on FreeBSD! options SEMMAP=128 options SEMMNI=128 options SEMMNS=32000 options SEMOPM=250 options SEMMSL=250 options SHMMAXPGS=65536 options SHMMAX=1073741824 options SHMMNI=4096 options SHMSEG=4096 options MAXDSIZ="(1024*1024*1024)" options MAXSSIZ="(1024*1024*1024)" options DFLDSIZ="(1024*1024*1024)" SQL> startup ; ORACLE instance started. Total System Global Area 55644260 bytes Fixed Size 450660 bytes Variable Size 29360128 bytes Database Buffers 25165824 bytes Redo Buffers 667648 bytes Database mounted. Database opened. SQL> host uname -a FreeBSD homsar.egovop.us 5.1-RELEASE FreeBSD 5.1-RELEASE #8: Tue Aug 19 08:00:52 EDT 2003 root@homsar.egovop.us:/usr/src/sys/i386/compile/HOMSAR i386 :) On Tue, Aug 19, 2003 at 09:40:15AM +0200, Roberto Nunnari wrote: > Dear Brian, > > I no longer have that 5.0-RELEASE system where I managed to run > Oracle 9i, but here are some hints/links on how I configured the > kernel: > > these are kernel options: > options SHMMAXPGS=65536 > options SHMMNI=100 > options SHMSEG=10 > options SEMMNS=256 > options SEMMNI=100 > options SEMMSL=100 > > and here's my original post telling the success story > and the steps leading to it. > http://www.freebsd.org/cgi/getmsg.cgi?fetch=2143+6531+/usr/local/www/db/text/2003/freebsd-database/20030309.freebsd-database > > Hope this helps. > > Best regards. > -- > Roberto Nunnari -software engineer- > mailto:nunnari@die.supsi.ch > Scuola Universitaria Professionale della Svizzera Italiana > Dipartimento di Informatica e Elettronica > http://www.die.supsi.ch > SUPSI-DIE > Via Cantonale tel: +41-91-6108561 > 6928 Manno """ fax: +41-91-6108570 > Switzerland (o o) > =======================oOO==(_)==OOo======================== > -- Brian C. Ledbetter http://www.shadowcom.net/brian/