Date: Sun, 15 Feb 1998 00:35:40 -0400 (VET) From: dcristini@oplk.com (Daniel Cristini) To: freebsd-questions@FreeBSD.ORG Subject: Oracle on FreeBSD Message-ID: <199802150435.AAA04831@fwb-1.true.net>
next in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?199802150435.AAA04831>