Date: Sat, 14 Feb 1998 17:57:59 +0200 From: Ruslan Shevchenko <Ruslan@Shevchenko.kiev.ua> To: Daniel Cristini <dcristini@oplk.com> Cc: freebsd-questions@FreeBSD.ORG Subject: Re: Oracle on FreeBSD Message-ID: <34E5BF06.B972B32E@Shevchenko.kiev.ua> References: <199802150435.AAA04831@fwb-1.true.net>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?34E5BF06.B972B32E>