On 22-Oct-2002 Matthew Lineen wrote:
>> - if you are using an Linux Oracle install, you need to compile
>> a linux perl and use that.
>
> I'd rather not, so I'll go w/ your advice on point #2.
>
>> - if you've installed the Oracle7 client libraries,
> /usr/ports/databases/oracle7,
>> then you can use the FreeBSD native Perl. Make sure you set the
> env var
>> LD_LIBRARY_PATH.
>
> This worked well; thanks so much! Now the big question is why they
> haven't released the Oracle9 client libraries to make the whole thing
> much, much easier to do.
When they release Oracle for FreeBSD, which will not be until 5.? with
smp & kernel threads, if they ever release it. The Oracle7 libraries
were never supported, but they released them. The Oracle7 port is a new
one, so you should update your ports directory. The only way to use oracle
on FreeBSD is to use the linux version. I've been using 8.0.5 for awhile, I
compiled a linux perl and linked it as perll, compiled DBI/DBD::Oracle ...etc.
I did install 8.1.7 at work, but have never tried 9i. You can use DBD::Proxy
with the FreeBSD native Perl for connecting to the Linux Oracle, on the same
server. The Oracle7 clients will give you more freatures than the Proxy. I
think for basic operations you the Oracle7 client is fine. I've just started
using it so I haven't run into any problems yet. Some of the features of DBD::Oracle
are definitely 8 specific, ie the oci libraries offer more functionality. I don't
think you will notice it for common usage. I'm cc'ing the list just in case someone
has more to add, like if I am wrong about something :-)
Let me know If I can help more,
STH
I spent so much time trying to get the
> Oracle installer running under FreeBSD linux emulation knowing that
> all I wanted was some library files anyways. It turns out that
> Oracle7 is no longer part of the ports collection (or at least the
> ports collection that I installed via sysinstall). The port source
> files were available online though, so it was easy enough.
>
> Do you have any experience to relate using the Oracle7 libraries for
> connecting to Oracle 9i with respect to speed and any missing
> functionality? It sounds like you've been down this path already.
>
>
> Thanks again,
> Matthew
>
>
----------------------------------
E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
Date: 23-Oct-2002
Time: 13:20:01
----------------------------------
