[EMAIL PROTECTED] wrote:
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
