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/