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>