[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freebsd-database
Subject:    Re: Oracle 9i - "Out Of Memory" error?
From:       Brian Ledbetter <brian () shadowcom ! net>
Date:       2003-08-19 14:03:10
[Download RAW message or body]

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/


[prev in list] [next in list] [prev in thread] [next in thread]