Oracle 9i - "Out Of Memory" error?

[Brian Ledbetter]

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 at 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 at 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 at shadowcom.net>
http://www.shadowcom.net/brian/