Oracle 9i

[Fernando Schapachnik]

Hi,
	I've managed to install Oracle 9 on FreeBSD 4.7 using the kernel patch
posted to the list, but can't get past the 'startup' command:

bash$ sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Tue Apr 1 13:31:53 2003

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL>
SQL> CONNECT SYS/PASSWORD AS SYSDBA
Connected to an idle instance.
SQL> startup nomount pfile=/u01/app/oracle/admin/COIN/initCOIN.ora
ORA-03113: end-of-file on communication channel
SQL>

	In the logs I find:

Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
ORACLE_HOME = /u01/app/oracle/product/9.0.1
System name:    Linux
Node name:      <skiped>
Release:        2.4.2
Version:        FreeBSD 4.7-RELEASE-p9 #0: Fri Mar 28 17:44:53 ART 2003
    root
Machine:        i386
Instance name: COIN
Redo thread mounted by this instance: 0 <none>
Oracle process number: 0
7828

skgm error 27121: errno = 22, info = 1, 262144, 0, 0
OPIRIP: Uncaught error 1034. Error stack:
ORA-01034: ORACLE not available
ORA-27121: unable to determine size of shared memory segment
Linux Error: 22: Invalid argument

	I sized SYSV settings in the kernel, but I must have missed something:

options         SHMMAXPGS=65536 # max amount of shared memory pages (4k on i386)
options         SHMMNI=120      # max number of shared memory identifiers
options         SHMSEG=4096     # max shared memory segments per process
options         SEMMNI=70       # number of semaphore identifiers in the system
options         SEMMNS=256      # number of semaphores in the system
options         SEMOPM=101      # max number of operations per semop call
options         SEMMSL=100      # max number of semaphores per id
options         SEMMNU=120      # number of undo structures in the system
options         SEMUME=40       # max number of undo entries per process
options         SHMMIN=1        # min shared memory segment size (bytes)
options         SHMMNI=100      # max number of shared memory identifiers

	Any ideas? Maybe a working kernel config?

	Thanks in advance.



Fernando Schapachnik