[ale] Oracle DBD-DBI

[James P. Kinney III]

On Mon, 2004-06-21 at 18:24, Armsby John-G16665 wrote:
> This is probably a repeat questions BUT I can find the previous
> answer....
>  
> I am running redhat 9 std install.  I want to connect to a remote
> Oracle 8 machine via Perl.  I have the DBD Oracle 1.5 tar file. 
> Unfortunately it complains about an ORACLE_HOME environmental
> variable.  perl Makefile.PL bombs out....
>  
> From reading the clients.readme file, it appears that I must have
> Oracle files on my machine in order to access Oracle on another
> machine.  I am a bit confused.  My expertise to date is win32::odbc
> with perl and access.  My plan is to move Access to MYSQL but I also
> have to get at a table on a remote Oracle 8 machine.
>  
> Anyone use DBD to get at oracle?  What do I have to install?  

Basically, to use Oracle, you have to install Oracle. (Nearly)
Everything but the actual database itself. It's a real PIA. There are
sites around (sorry, I have deleted them as I NEVER want to install/f**k
with Oracle again!) that have nearly step-by-step instructions for
getting the bloated piece of junk to be usable on Linux. Oracle web site
has some instructions that are not very useful. 

The ORACLE_HOME variable needs to be set to point to the
machine:path/to/oracle/binaries where the real database is installed.
Plus there needs to be privileges added to the server to allow
connections from the remote clients. This is a PIA for remote access
machines on DHCP. Those need user/password access (which can conflict
with the setup for the DB itself).

Currently, the best/easiest way to connect to a remote Oracle database
is to use the java client that comes with Oracle.

The more I had to use Oracle, the more I like flat text files for
n-dimensional storage arrays :-|
>  
>  
> John
>  
> !DSPAM:40d7604976411847317005!
> 
> ______________________________________________________________________
> 
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://www.ale.org/mailman/listinfo/ale
> 
> 
> !DSPAM:40d7604976411847317005!
-- 
James P. Kinney III          \Changing the mobile computing world/
CEO & Director of Engineering \          one Linux user         /
Local Net Solutions,LLC        \           at a time.          /
770-493-8244                    \.___________________________./
http://www.localnetsolutions.com

GPG ID: 829C6CA7 James P. Kinney III (M.S. Physics)
<jkinney at localnetsolutions.com>
Fingerprint = 3C9E 6366 54FC A3FE BA4D 0659 6190 ADC3 829C 6CA7
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part