From owner-freebsd-database@FreeBSD.ORG Mon Aug 18 07:55:43 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 4EB5337B401 for ; Mon, 18 Aug 2003 07:55:43 -0700 (PDT) Received: from lakemtao04.cox.net (lakemtao04.cox.net [68.1.17.241]) by mx1.FreeBSD.org (Postfix) with ESMTP id 44C9243FA3 for ; Mon, 18 Aug 2003 07:55:42 -0700 (PDT) (envelope-from brian@shadowcom.net) Received: from shadowcom.net ([68.100.212.237]) by lakemtao04.cox.net (InterMail vM.5.01.04.05 201-253-122-122-105-20011231) with SMTP id <20030818145542.LZWD13930.lakemtao04.cox.net@shadowcom.net> for ; Mon, 18 Aug 2003 10:55:42 -0400 Received: (qmail 76012 invoked by uid 500); 18 Aug 2003 14:56:38 -0000 Date: Mon, 18 Aug 2003 10:56:38 -0400 From: Brian Ledbetter To: g.w.k@web.de Message-ID: <20030818145638.GA75929@shadowcom.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4i cc: freebsd-database@freebsd.org Subject: 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: Mon, 18 Aug 2003 14:55:43 -0000 Sir, Sorry to bother you. I saw your posting on freebsd-database@ a while back regarding your success with Oracle 9i. My 5.1-R system has your patch applied, but when I try to startup and create the database, this happens: $ sqlplus '/ as sysdba' @CreateDB.sql SQL*Plus: Release 9.2.0.1.0 - Production on Mon Aug 18 10:44:17 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to an idle instance. Connected to an idle instance. SQL> spool /users/brian/Oracle/Home/9.2.0.1.0/assistants/dbca/logs/CreateDB.log SQL> startup nomount pfile="/users/brian/Oracle/Base/admin/ORACLE/scripts/init.ora"; ORA-27102: out of memory Linux Error: 12: Cannot allocate memory SQL> How did you create the Oracle database on your system? Did you require special settings to your SYSVSHM/SYSVSEM configuration, or is there something else (ulimit?) that I am missing? Here is my system's configuration: $ ulimit -n 5194 $ uname -a FreeBSD homsar.egovop.us 5.1-RELEASE FreeBSD 5.1-RELEASE #4: Wed Aug 6 09:25:07 EDT 2003 root@homsar.egovop.us:/usr/src/sys/i386/compile/HOMSAR i386 $ sysctl -a | grep shm kern.ipc.shmmax: 1073741824 kern.ipc.shmmin: 1 kern.ipc.shmmni: 256 kern.ipc.shmseg: 256 kern.ipc.shmall: 8192 kern.ipc.shm_use_phys: 0 shm 2 18K 21K 36 16,2048,16384 $ sysctl -a | grep sem kern.ipc.semmap: 128 kern.ipc.semmni: 128 kern.ipc.semmns: 128 kern.ipc.semmnu: 30 kern.ipc.semmsl: 128 kern.ipc.semopm: 100 kern.ipc.semume: 10 kern.ipc.semusz: 92 kern.ipc.semvmx: 32767 kern.ipc.semaem: 16384 acpisem 17 3K 3K 17 128 sem 4 22K 22K 4 2048,4096,8192 debug.acpi_semaphore_debug: 0 p1003_1b.semaphores: 0 p1003_1b.sem_nsems_max: 0 p1003_1b.sem_value_max: 0 Thanks, in advance! My apologies if I am wasting your time by missing something simple. :) -- Brian C. Ledbetter http://www.shadowcom.net/brian/ From owner-freebsd-database@FreeBSD.ORG Mon Aug 18 11:39:27 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 C418937B401 for ; Mon, 18 Aug 2003 11:39:20 -0700 (PDT) Received: from mta202-rme.xtra.co.nz (mta202-rme.xtra.co.nz [210.86.15.145]) by mx1.FreeBSD.org (Postfix) with ESMTP id 5389243FBD for ; Mon, 18 Aug 2003 11:39:19 -0700 (PDT) (envelope-from berend@pobox.com) Received: from mta3-rme.xtra.co.nz ([210.86.15.142]) by mta202-rme.xtra.co.nz with ESMTP <20030818183918.QZPO1195.mta202-rme.xtra.co.nz@mta3-rme.xtra.co.nz>; Tue, 19 Aug 2003 06:39:18 +1200 Received: from bmach.nederware.nl ([210.86.48.246]) by mta3-rme.xtra.co.nz with ESMTP id <20030818183916.GZKO1238.mta3-rme.xtra.co.nz@bmach.nederware.nl>; Tue, 19 Aug 2003 06:39:16 +1200 Received: from dellius.nederware.nl (dellius.nederware.nl [192.168.33.6]) by bmach.nederware.nl (Postfix) with ESMTP id 2D92722FDB; Tue, 19 Aug 2003 06:39:16 +1200 (NZST) Received: by dellius.nederware.nl (Postfix, from userid 1000) id 87BDE6E2CA; Tue, 19 Aug 2003 06:39:14 +1200 (NZST) To: Brian Ledbetter From: Berend de Boer X-Home-Page: http://www.pobox.com/~berend Date: Tue, 19 Aug 2003 06:39:14 +1200 In-Reply-To: <20030818145638.GA75929@shadowcom.net> (Brian Ledbetter's message of "Mon, 18 Aug 2003 10:56:38 -0400") Message-ID: <871xvikdyl.fsf@dellius.nederware.nl> User-Agent: Gnus/5.090015 (Oort Gnus v0.15) Emacs/21.2 References: <20030818145638.GA75929@shadowcom.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii 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: Mon, 18 Aug 2003 18:39:28 -0000 Brian Ledbetter writes: > How did you create the Oracle database on your system? Did you require > special settings to your SYSVSHM/SYSVSEM configuration, or is there > something else (ulimit?) that I am missing? Here is my system's > configuration: 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. -- Live long and prosper, Berend de Boer From owner-freebsd-database@FreeBSD.ORG Mon Aug 18 12:34:33 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 7D3F937B419 for ; Mon, 18 Aug 2003 12:34:33 -0700 (PDT) Received: from lakemtao01.cox.net (lakemtao01.cox.net [68.1.17.244]) by mx1.FreeBSD.org (Postfix) with ESMTP id A9F3243F93 for ; Mon, 18 Aug 2003 12:34:31 -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 <20030818193431.IKXU7142.lakemtao01.cox.net@shadowcom.net> for ; Mon, 18 Aug 2003 15:34:31 -0400 Received: (qmail 77269 invoked by uid 500); 18 Aug 2003 19:35:29 -0000 Date: Mon, 18 Aug 2003 15:35:29 -0400 From: Brian Ledbetter To: Berend de Boer Message-ID: <20030818193529.GA77206@shadowcom.net> References: <20030818145638.GA75929@shadowcom.net> <871xvikdyl.fsf@dellius.nederware.nl> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <871xvikdyl.fsf@dellius.nederware.nl> 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: Mon, 18 Aug 2003 19:34:33 -0000 > 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. :) -- Brian C. Ledbetter http://www.shadowcom.net/brian/ From owner-freebsd-database@FreeBSD.ORG Mon Aug 18 22:06:49 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 63A0916A4EF for ; Mon, 18 Aug 2003 22:06:47 -0700 (PDT) Received: from mta204-rme.xtra.co.nz (mta204-rme.xtra.co.nz [210.86.15.147]) by mx1.FreeBSD.org (Postfix) with ESMTP id 7A312441FA for ; Mon, 18 Aug 2003 21:42:46 -0700 (PDT) (envelope-from berend@pobox.com) Received: from mta1-rme.xtra.co.nz ([210.86.15.143]) by mta204-rme.xtra.co.nz with ESMTP <20030819044235.VLDJ1211.mta204-rme.xtra.co.nz@mta1-rme.xtra.co.nz>; Tue, 19 Aug 2003 16:42:35 +1200 Received: from bmach.nederware.nl ([210.86.48.246]) by mta1-rme.xtra.co.nz with ESMTP id <20030819044231.IPYI1174.mta1-rme.xtra.co.nz@bmach.nederware.nl>; Tue, 19 Aug 2003 16:42:31 +1200 Received: from dellius.nederware.nl (dellius.nederware.nl [192.168.33.6]) by bmach.nederware.nl (Postfix) with ESMTP id C5B7822FDB; Tue, 19 Aug 2003 16:42:30 +1200 (NZST) Received: by dellius.nederware.nl (Postfix, from userid 1000) id BF8036E2CA; Tue, 19 Aug 2003 16:42:11 +1200 (NZST) To: Brian Ledbetter From: Berend de Boer X-Home-Page: http://www.pobox.com/~berend Date: Tue, 19 Aug 2003 16:42:11 +1200 In-Reply-To: <20030818193529.GA77206@shadowcom.net> (Brian Ledbetter's message of "Mon, 18 Aug 2003 15:35:29 -0400") Message-ID: <87y8xqi7h8.fsf@dellius.nederware.nl> User-Agent: Gnus/5.090015 (Oort Gnus v0.15) Emacs/21.2 References: <20030818145638.GA75929@shadowcom.net> <20030818193529.GA77206@shadowcom.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii 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 05:06:53 -0000 Brian Ledbetter writes: > 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? Sorry, I only have installed it on Linux and I knew I had to set those things. No experience with getting it to work on FreeBSD, sorry. -- Live long and prosper, Berend de Boer 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. :) > > > From owner-freebsd-database@FreeBSD.ORG Tue Aug 19 00:40:58 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 5E5A316A4BF for ; Tue, 19 Aug 2003 00:40:58 -0700 (PDT) Received: from mail.die.supsi.ch (mail.die.supsi.ch [193.5.153.13]) by mx1.FreeBSD.org (Postfix) with ESMTP id 7616243FAF for ; Tue, 19 Aug 2003 00:40:52 -0700 (PDT) (envelope-from nunnari@die.supsi.ch) Received: from die.supsi.ch (pcm2022.die.supsi.ch [193.5.152.22]) by mail.die.supsi.ch (8.11.6/8.11.6) with ESMTP id h7J7eF712969; Tue, 19 Aug 2003 09:40:15 +0200 Message-ID: <3F41D45F.2020608@die.supsi.ch> Date: Tue, 19 Aug 2003 09:40:15 +0200 From: Roberto Nunnari User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.1) Gecko/20020823 Netscape/7.0 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Brian Ledbetter References: <20030818145638.GA75929@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 07:40:58 -0000 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======================== 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/ From owner-freebsd-database@FreeBSD.ORG Tue Aug 19 13:30:32 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 42A5016A4BF for ; Tue, 19 Aug 2003 13:30:32 -0700 (PDT) Received: from smtp.web.de (smtp03.web.de [217.72.192.158]) by mx1.FreeBSD.org (Postfix) with ESMTP id A504A43F85 for ; Tue, 19 Aug 2003 13:30:31 -0700 (PDT) (envelope-from g.w.k@web.de) Received: from [217.232.162.122] (helo=[192.168.0.2]) by smtp.web.de with asmtp (WEB.DE 4.99 #448) id 19pD5f-000555-00; Tue, 19 Aug 2003 22:28:27 +0200 From: "Georg-W. Koltermann" To: Brian Ledbetter In-Reply-To: <20030818193529.GA77206@shadowcom.net> References: <20030818145638.GA75929@shadowcom.net> <871xvikdyl.fsf@dellius.nederware.nl> <20030818193529.GA77206@shadowcom.net> Content-Type: text/plain Message-Id: <1061324905.1498.8.camel@bat.localnet> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.3 Date: 19 Aug 2003 20:28:25 +0000 Content-Transfer-Encoding: 7bit Sender: g.w.k@web.de 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 20:30:32 -0000 On Mo, 2003-08-18 at 19:35, Brian Ledbetter wrote: > 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 Wow that's far more than you need, but won't hurt probably. > kern.ipc.shmmin: 1 > kern.ipc.shmmni: 4096 > kern.ipc.shmseg: 4096 > kern.ipc.shmall: 8192 That (shmall) might be a bit small. According to /usr/src/sys/conf/NOTES this is the max. number of pages for share memory, system wide. With 4kB pages this value would mean 32 MB of shared memory, which, depending on the database parameters, might be too low. My values, which still work in 5.1 unchanged from 5.0, are: # # FreeBSD kernel options for ORACLE # options SHMSEG=4096 options SEMMNI=100 options SEMMNS=256 options SHMMAXPGS=131073 options SHMALL=131073 -- Regards, Georg-W. Koltermann From owner-freebsd-database@FreeBSD.ORG Wed Aug 20 11:54:43 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 EE18F16A4BF for ; Wed, 20 Aug 2003 11:54:43 -0700 (PDT) Received: from lakemtao04.cox.net (lakemtao04.cox.net [68.1.17.241]) by mx1.FreeBSD.org (Postfix) with ESMTP id C616043FA3 for ; Wed, 20 Aug 2003 11:54:42 -0700 (PDT) (envelope-from brian@shadowcom.net) Received: from shadowcom.net ([68.100.212.237]) by lakemtao04.cox.net (InterMail vM.5.01.06.04 201-253-122-130-104-20030726) with SMTP id <20030820185443.MQBW419.lakemtao04.cox.net@shadowcom.net> for ; Wed, 20 Aug 2003 14:54:43 -0400 Received: (qmail 20755 invoked by uid 500); 20 Aug 2003 18:55:56 -0000 Date: Wed, 20 Aug 2003 14:55:56 -0400 From: Brian Ledbetter To: freebsd-database@freebsd.org Message-ID: <20030820185556.GF19233@shadowcom.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4i Subject: RFC: Installation Instructions: Oracle 9i database on FreeBSD 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: Wed, 20 Aug 2003 18:54:44 -0000 Greetings all, Thanks to the gracious help of the freebsd-database list, I was able to finish my step-by-step guide to installing Oracle 9i on FreeBSD. Please check it out and let me know what you think! :) http://www.shadowcom.net/freebsd-oracle9i/ Thanks again to Berend, Valery, Roberto, and Georg! I couldn't have done it without your help! :) -- Brian C. Ledbetter From owner-freebsd-database@FreeBSD.ORG Wed Aug 20 13:38:18 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 46DE616A4BF for ; Wed, 20 Aug 2003 13:38:18 -0700 (PDT) Received: from valu.uninet.ee (valu.uninet.ee [194.204.34.51]) by mx1.FreeBSD.org (Postfix) with ESMTP id 79CC643FB1 for ; Wed, 20 Aug 2003 13:38:17 -0700 (PDT) (envelope-from taavi@uninet.ee) Received: by valu.uninet.ee (Postfix, from userid 1002) id 2BF7436452; Wed, 20 Aug 2003 23:38:16 +0300 (EEST) Received: from localhost (localhost [127.0.0.1]) by valu.uninet.ee (Postfix) with ESMTP id 2A79932619; Wed, 20 Aug 2003 23:38:16 +0300 (EEST) Date: Wed, 20 Aug 2003 23:38:16 +0300 (EEST) From: Taavi Talvik To: Brian Ledbetter In-Reply-To: <20030820185556.GF19233@shadowcom.net> Message-ID: <20030820233610.H85908-100000@valu.uninet.ee> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII cc: freebsd-database@freebsd.org Subject: Re: RFC: Installation Instructions: Oracle 9i database on FreeBSD 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: Wed, 20 Aug 2003 20:38:18 -0000 On Wed, 20 Aug 2003, Brian Ledbetter wrote: > Greetings all, > > Thanks to the gracious help of the freebsd-database list, I was able to > finish my step-by-step guide to installing Oracle 9i on FreeBSD. Please > check it out and let me know what you think! :) > > http://www.shadowcom.net/freebsd-oracle9i/ > > Thanks again to Berend, Valery, Roberto, and Georg! I couldn't have done > it without your help! :) Maybe you can turn installation guide into port;) best regards, taavi From owner-freebsd-database@FreeBSD.ORG Fri Aug 22 12:39:39 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 2888F16A4BF for ; Fri, 22 Aug 2003 12:39:39 -0700 (PDT) Received: from ren.sasknow.com (ren.sasknow.com [207.195.92.131]) by mx1.FreeBSD.org (Postfix) with ESMTP id DC47D43FAF for ; Fri, 22 Aug 2003 12:39:35 -0700 (PDT) (envelope-from glm@cyborgspiders.com) Received: from Mom.cyborgspiders.com (hsdbsk206-163-228-245.sasknet.sk.ca [206.163.228.245]) by ren.sasknow.com (8.12.8p1/8.12.8) with ESMTP id h7MJdWDm003846 for ; Fri, 22 Aug 2003 13:39:33 -0600 (CST) (envelope-from glm@cyborgspiders.com) Message-Id: <5.2.1.1.0.20030822132658.009ff760@mail.sasknow.com> X-Sender: cyborgspiders@mail.sasknow.com X-Mailer: QUALCOMM Windows Eudora Version 5.2.1 Date: Fri, 22 Aug 2003 13:33:12 -0600 To: freebsd-database@freebsd.org From: Greg Magnusson Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed Subject: freebsd_mysql_install 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: Fri, 22 Aug 2003 19:39:39 -0000 re: getting mysql running on FreeBSD 4.7 Hello, I am running FreeBSD 4.7 and mysql-max-3.23.57-unknown-freebsd4.7-i386 on FreeBSD 4.7. I have installed mysql, but I am having problems getting it to run. When I am in the mysql directory, and I enter "./bin/safe_mysqld & I get the message [1] 363 cyborgspiders#chown: mysql: illegal user name Starting mysqld daemon with databases from /usr/local/mysql/mysql-max-3.23.57-unknown-freebsd4.7-i386/data 030822 13:29:57 mysql ended [1] Done ./bin/safe_mysqld Help will be appreciated, Greg Magnusson glm@cyborgspiders.com From owner-freebsd-database@FreeBSD.ORG Fri Aug 22 15:32:01 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 7E44316A4BF for ; Fri, 22 Aug 2003 15:32:01 -0700 (PDT) Received: from ren.sasknow.com (ren.sasknow.com [207.195.92.131]) by mx1.FreeBSD.org (Postfix) with ESMTP id C676B43FE1 for ; Fri, 22 Aug 2003 15:32:00 -0700 (PDT) (envelope-from glm@cyborgspiders.com) Received: from Mom.cyborgspiders.com (hsdbsk206-163-228-245.sasknet.sk.ca [206.163.228.245]) by ren.sasknow.com (8.12.8p1/8.12.8) with ESMTP id h7MMVvDm027848 for ; Fri, 22 Aug 2003 16:31:58 -0600 (CST) (envelope-from glm@cyborgspiders.com) Message-Id: <5.2.1.1.0.20030822162354.00a01590@mail.sasknow.com> X-Sender: cyborgspiders@mail.sasknow.com X-Mailer: QUALCOMM Windows Eudora Version 5.2.1 Date: Fri, 22 Aug 2003 16:25:21 -0600 To: freebsd-database@freebsd.org From: Greg Magnusson Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed Subject: mysql_install 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: Fri, 22 Aug 2003 22:32:01 -0000 re: getting mysql running on FreeBSD 4.7 Hello, I am running FreeBSD 4.7 and mysql-max-3.23.57-unknown-freebsd4.7-i386 on FreeBSD 4.7. I have installed mysql, but I am having problems getting it to run. When I am in the mysql directory, and I enter "./bin/safe_mysqld & I get the message [1] 363 cyborgspiders#chown: mysql: illegal user name Starting mysqld daemon with databases from /usr/local/mysql/mysql-max-3.23.57-unknown-freebsd4.7-i386/data 030822 13:29:57 mysql ended [1] Done ./bin/safe_mysqld Help will be appreciated, Greg Magnusson glm@cyborgspiders.com