From owner-freebsd-questions Sat Feb 14 22:05:12 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id WAA04294 for freebsd-questions-outgoing; Sat, 14 Feb 1998 22:05:12 -0800 (PST) (envelope-from owner-freebsd-questions@FreeBSD.ORG) Received: from True.Net (true.net [200.11.130.10]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id WAA04027 for ; Sat, 14 Feb 1998 22:03:44 -0800 (PST) (envelope-from dcristini@oplk.com) Received: from fwb-1.true.net (fwb-2.true.net [200.11.130.3]) by True.Net (8.8.5/8.6.12) with ESMTP id AAA10403 for ; Sat, 14 Feb 1998 00:35:10 -0400 (AST) Received: from daniel (root@localhost) by fwb-1.true.net (8.8.6/8.6.12) with SMTP id AAA04831 for ; Sun, 15 Feb 1998 00:35:40 -0400 (VET) Date: Sun, 15 Feb 1998 00:35:40 -0400 (VET) Message-Id: <199802150435.AAA04831@fwb-1.true.net> X-BlackMail: daniel.oplk.com, daniel, dcristini@oplk.com, 200.11.254.130 X-Authenticated-Timestamp: 00:35:40(VET) on February 15, 1998 X-Sender: dcristini@pop.true.net X-Mailer: Windows Eudora Version 1.4.4 Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" To: freebsd-questions@FreeBSD.ORG From: dcristini@oplk.com (Daniel Cristini) Subject: Oracle on FreeBSD Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG 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) 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. 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). 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