Oracle 9i - "Out Of Memory" error?

[Brian Ledbetter]

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