From owner-freebsd-questions@FreeBSD.ORG Sun Mar 7 02:56:40 2004 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id F239516A4CE for ; Sun, 7 Mar 2004 02:56:40 -0800 (PST) Received: from sax.sax.de (sax.sax.de [193.175.26.33]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3B14B43D1F for ; Sun, 7 Mar 2004 02:56:40 -0800 (PST) (envelope-from mw@theatre.sax.de) Received: (from uucp@localhost) by sax.sax.de (8.9.3/8.9.3) with UUCP id LAA25224; Sun, 7 Mar 2004 11:56:36 +0100 (CET) Received: from theatre.sax.de (mw@localhost [127.0.0.1]) by sax.de (8.12.10/8.12.10) with ESMTP id i27AshgN009951; Sun, 7 Mar 2004 11:54:43 +0100 (CET) (envelope-from mw@theatre.sax.de) Received: (from mw@localhost) by theatre.sax.de (8.12.10/8.12.9/Submit) id i27AshRK009950; Sun, 7 Mar 2004 11:54:43 +0100 (CET) (envelope-from mw) Date: Sun, 7 Mar 2004 11:54:43 +0100 From: Martin Welk To: freebsd-questions@freebsd.org Message-ID: <20040307105443.GH9521@theatre.sax.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.6i cc: Martin McCormick Subject: Re: Accessing Oracle8i Data on a FreeBSD System X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 07 Mar 2004 10:56:41 -0000 An Fri, Mar 05, 2004 at 04:39:14PM -0600, Martin McCormick wrote: (...) > There is a linux distribution available on the Oracle web > site called linux81701.tar, but it appears to be for those wishing to > run an oracle8I server. > > What we are trying to do is: > Receive data from the oracle data base on the Pinnacle server, process > the data, and be able to set or clear flags on data we send back to > the Pinnacle server. > > My question is what tools do I actually need under FreeBSD > Unix to access the Pinnacle server's oracle8i data? (...) Well, I think the Oracle 8i distribution for Oracle includes an Oracle client. I'm not sure if it is possible to install this stand-alone, but at least you could give it a try. I've never managed to run the Oracle Java installer on FreeBSD, but it's possible to do an installation on a Linux box - than you could just put together the Oracle installation directory and transfer it to your FreeBSD box. You might want to try to install the client only on Linux and transfer it to FreeBSD, and, of course, you need to run the Linux emulator and you probably need a couple of the Linux shared libraries (/usr/ports/emulators/ linux-base) - as Oracle 8i for Linux runs on SuSE Linux 7.3 and RedHat 6.4 and similar, you might have to go with the older linux-base6. Check of the environment of your Oracle user and make sure that your ORACLE_HOME and LD_LIBRARY_PATH and your PATH is set correctly. You can change the ${ORACLE_HOME}/client/network/admin/tnsnames.ora by hand without the Java dbassist or whatever, and if you've done that all correctly, you might be able to connect to your database with the sqlplus command. If you want to use those Oracle client libraries from somewhere else, you will need a Linux application loading the Oracle linux shared libraries. Well, at all, this is something I'd call PITA and of course not supported at all - so although I like FreeBSD very much (I'm using it for almost ten years now at various places), I think that Linux might be the easier way to go, unfortunately... Regards, Martin -- ,,Oh, there's a lot of opportunities, if you're knowing to take them, you know, there's a lot of opportunities, if there aren't you can make them, make or break them!'' (Tennant/Lowe)