Date: Tue, 1 Apr 2003 15:00:56 -0300 From: Fernando Schapachnik <fernando@mecon.gov.ar> To: freebsd-database@freebsd.org Subject: Oracle 9i Message-ID: <20030401180056.GH601@bal740r0.mecon.gov.ar>
next in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20030401180056.GH601>