Date: Tue, 19 Aug 2003 10:03:10 -0400 From: Brian Ledbetter <brian@shadowcom.net> To: Roberto Nunnari <nunnari@die.supsi.ch> Cc: freebsd-database@freebsd.org Subject: Re: Oracle 9i - "Out Of Memory" error? Message-ID: <20030819140310.GA82534@shadowcom.net> In-Reply-To: <3F41D45F.2020608@die.supsi.ch> References: <20030818145638.GA75929@shadowcom.net> <3F41D45F.2020608@die.supsi.ch>
next in thread | previous in thread | raw e-mail | index | archive | help
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 <brian@shadowcom.net> http://www.shadowcom.net/brian/
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20030819140310.GA82534>