From owner-freebsd-questions Sun Feb 15 06:02:06 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id GAA08445 for freebsd-questions-outgoing; Sun, 15 Feb 1998 06:02:06 -0800 (PST) (envelope-from owner-freebsd-questions@FreeBSD.ORG) Received: from cam.grad.kiev.ua (grad-UTC-28k8.ukrtel.net [195.5.25.54]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id GAA08417 for ; Sun, 15 Feb 1998 06:02:01 -0800 (PST) (envelope-from Ruslan@Shevchenko.kiev.ua) Received: from Shevchenko.kiev.ua (localhost [127.0.0.1]) by cam.grad.kiev.ua (8.8.8/8.8.5) with ESMTP id RAA26846; Sat, 14 Feb 1998 17:58:05 +0200 (EET) Message-ID: <34E5BF06.B972B32E@Shevchenko.kiev.ua> Date: Sat, 14 Feb 1998 17:57:59 +0200 From: Ruslan Shevchenko Reply-To: rssh@grad.kiev.ua X-Mailer: Mozilla 4.04 [en] (X11; I; FreeBSD 2.2.5-STABLE i386) MIME-Version: 1.0 To: Daniel Cristini CC: freebsd-questions@FreeBSD.ORG Subject: Re: Oracle on FreeBSD References: <199802150435.AAA04831@fwb-1.true.net> Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: 7bit Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Daniel Cristini wrote: > Hello: > > I have been following the mail discussions about running Oracle on > FreeBSD and having the need to do so myself I gave it a try. > > Here are the results I got on trying to make Oracle 7.3.2 for SCO run > on FreeBSD: > > 1) I first tried with Oracle's Workgroup Server (which includes > the 7.3.2 RDBMS, SQL*PLUS, SQL*NET ver 2.0 and the WebServer > among other things), no luck, the installation program > expected an SCO like enviroment (ie. it expected to find > SCO's administrative commands to create users and groups > and the like) > Of course. > 2) Then I installed 7.3.2 (not the Workgroup server Edition) > on an SCO OpenServer 5.04 machine with all the tools I needed, > I did a shutdown on the RDBMS and made a backup of it on tape, > then took the tape to my FreeBSD 2.2.5 system and tried to startup > the RDBMS. (this particular FreeBSD Instalation had already configured > the IBCS2 emulator and the SYSV stuff Oracle uses: Shared Memory and > Semaphores). Unfortunately the RDBMS refused to startup, claiming > it could not allocate shared memory. Oracle includes a program > called 'tstshm' which is used to test the shared memory capabilities > of a given machine, I tried it on my FreeBSD box and discovered that > the program returns a negative number for the amount of shared memory > reserved (that *might* explain why the RDBMS wouldn't start!). I tried > to tweak with the shared memory settings on the Kernel config file > (which unfortunantely seem to be undocumented!) with no luck. > (This is you problem. you nead min 10000000 set as SHMAX (better 20000000) olso you need near 30 semaphores > 3) Finally, I tried to use the client applications (such as SQL*PLUS, > the SQL interpreter) and everytime I started them up they complained > about > not being able to find the file /dev/socksys, this seems (to me > at least!) to point to the fact that SCO's TCP libraries (the > original code was designed by Latchman Associates I think..) implement > socket calls through a pseudo-device called socksys. In any case the > client tools would not connect to the RDBMS working on a remote machine > (despite the fact that the SQL*NET TCP config file was properly set up). > This is in FreeBSD FAQ (Why my SCO app bombs on sockets) > So my attempts to get Oracle running on FreeBSD have not been very > succesful, if anybody got an idea on where I screwed up I would > appreciate a line... > > Thank you > Daniel Cristini > > > To Unsubscribe: send mail to majordomo@FreeBSD.org > with "unsubscribe freebsd-questions" in the body of the message -- @= //RSSH mailto:Ruslan@Shevchenko.Kiev.UA To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message