Hello all,
I am trying to run a perl script that from one host has to access a database
running on another host. I am encountering some troubels here, that I have a
workaround for right now, but I'd like to have the opinion of the experts on
the list anyway.
The situation: Host A runs Oracle 9.2.0
Host B hasn't got oracle installed. Host B receives files
that have to be imported into the database. We have a perl script that does
this.
The problem is that originally this script was developped when host A and
host B were one and the same machine...
first problem:
Running a perl -c on the script gave me the following error:
Can't locate loadable object for module DBD::Oracle in @INC (@INC contains:
/sd80dg01/data/tomcat/server_low/webapps/shabforms/WEB-INF/perllib/
/usr/local/lib/perl5/5.8.0/sun4-solaris /usr/local/lib/perl5/5.8.0
/usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris
/usr/local/lib/perl5/site_perl/5.8.0 /usr/local/lib/perl5/site_perl .) at
/sd80dg01/data/perllib/SHAB/Automatisation.pm line 12
Compilation failed in require at
/sd80dg01/data/perllib/SHAB/Automatisation.pm line 12.
BEGIN failed--compilation aborted at
/sd80dg01/data/perllib/SHAB/Automatisation.pm line 12.
Compilation failed in require at script line 10.
BEGIN failed--compilation aborted at script line 10.
I did a truss on perl, and found out that he is looking for Oracle.os in
every dir of the @INC path, but not in the
/usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/auto/DBD/Oracle920 dir
where it actually is. Why doesn't perl find this file? Why is it installed
there if perl ignores it?
I managed to solve the problem by making setting my PERL5LIB to a dir I had
copied Oracle.so in.
Furthemore I found out the Oracle.so needs a couple of libraries from the
Oracle installation. I copied this to that same directory, and added that
one to LD_LIBRARY_PATH.
For now it looks like the scripts compile. Wether they work is another
question...
Can somebody tell me what would be needed to be installed on Host B to
reliable access the DB on Host A. Preferably without having to install
Oracle on Host B
Thanks in advance,
Krist
---
Krist van Besien
Unix Specialist BZBD
Bundesamt f�r Informatik und Telekommunikation BIT
Monbijoustrasse 74, CH-3003 Bern
Tel. +41 31 322 24 46
added interaction www.informatik.admin.ch
