From owner-freebsd-database@FreeBSD.ORG Tue Apr 1 10:01:05 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 A94AB37B401 for ; Tue, 1 Apr 2003 10:01:05 -0800 (PST) Received: from relay2.mecon.ar (relay2.mecon.ar [168.101.16.11]) by mx1.FreeBSD.org (Postfix) with ESMTP id E170243FAF for ; Tue, 1 Apr 2003 10:01:03 -0800 (PST) (envelope-from fernando@mecon.gov.ar) Received: from racing.mecon.ar (racing.mecon.ar [168.101.133.15]) by relay2.mecon.ar (8.12.6/8.12.6) with ESMTP id h31I12o2055230 for ; Tue, 1 Apr 2003 15:01:02 -0300 (ART) (envelope-from fernando@mecon.gov.ar) Received: from racing.mecon.ar (meyosp.mecon.gov.ar [10.11.0.149]) by racing.mecon.ar (8.12.6/8.12.6) with ESMTP id h31I0uwB080971 for ; Tue, 1 Apr 2003 15:00:57 -0300 (ART) (envelope-from fernando@mecon.gov.ar) Received: from bal740r0.mecon.gov.ar (bal740r0.mecon.ar [10.11.1.11]) by racing.mecon.ar (8.12.6/8.12.6) with ESMTP id h31I0uta080967 for ; Tue, 1 Apr 2003 15:00:56 -0300 (ART) (envelope-from fernando@mecon.gov.ar) Received: from bal740r0.mecon.gov.ar (localhost [127.0.0.1]) by bal740r0.mecon.gov.ar (8.12.6/8.12.6) with ESMTP id h31I0ula001102 for ; Tue, 1 Apr 2003 15:00:56 -0300 (ART) (envelope-from fernando@mecon.gov.ar) Received: (from fpscha@localhost) by bal740r0.mecon.gov.ar (8.12.6/8.12.6/Submit) id h31I0uZ3001101 for freebsd-database@freebsd.org; Tue, 1 Apr 2003 15:00:56 -0300 (ART) (envelope-from fernando@mecon.gov.ar) X-Authentication-Warning: bal740r0.mecon.gov.ar: fpscha set sender to fernando@mecon.gov.ar using -f Date: Tue, 1 Apr 2003 15:00:56 -0300 From: Fernando Schapachnik To: freebsd-database@freebsd.org Message-ID: <20030401180056.GH601@bal740r0.mecon.gov.ar> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4.1i X-OS: FreeBSD 4.7 - http://www.freebsd.org Subject: Oracle 9i 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, 01 Apr 2003 18:01:06 -0000 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: 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 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