Re: Perl modules and Oracle 10g Client on RHEL 4

[Matthias Saou <thias spam spam spam spam spam spam spam egg and spam freshrpms net>]

Seems like your Oracle libs aren't found.

Maybe you'd like to try this, it might help (clean and working) :

http://freshrpms.net/docs/oracle/

I'm using the perl module through CGI for oracletool.

Matthias

Diana Shepard wrote :

> 	A Perl CGI that connects to an Oracle database via DBI,
> 	DBD::Oracle works at the command line but not via a browser. 
> 	It is like it is looking for Perl modules in a location
> different 
> 	than that at the command line.
> 
> 	Environment:
> 	 
> 	RHEL 4 AS
> 	Oracle Client 10.2.0
> 	Apache 2.0.52 (without mod_perl)
> 	Perl 5.8.5
> 	Perl DBI version 1.50
> 	Perl DBD::Oracle version 1.16
> 
> 	The Perl script executes a DBD::Oracle connection to a database.
> The script 
> 	executes fine from the command line, but execution within a
> browser 
> 	yields the following:
> 
> 	"install_driver(Oracle) failed: Can't load
> '/usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/auto/DBD/Ora
> cle/Oracle.so' for module DBD::Oracle: libclntsh.so.10.1: cannot open
> shared object file: No such file or directory at
> /usr/lib64/perl5/5.8.5/x86_64-linux-thread-multi/DynaLoader.pm line 230.
> 	Compilation failed in require at (eval 9) line 3. Perhaps a
> required shared library or dll isn't installed where expected at
> /web/dwhse/gl/gl_status.cgi line 84"
> 	I tried to add the following to the Perl script; made no
> difference:
> 	use CGI qw/:standard/;  # CGI helper functions
> 	use Time::Local;        # for time calculations
> 	use DBI;
> 	use CGI::Carp qw(fatalsToBrowser);
> 	use lib "/usr/lib64/perl5/site_perl/5.8.5";
> 	use lib "/u01/app/oracle/oracle/10.2.0/lib";
> 	$ENV{'LD_LIBRARY_PATH'} = "/u01/app/oracle/product/10.2.0/lib";
> 	$ENV{'ORACLE_HOME'}     = "/u01/app/oracle/product/10.2.0";
> 	$ENV{'ORACLE_SID'}      = "prod";
> 
> 
> Diana Shepard
> University of Colorado, Boulder
>  


-- 
Clean custom Red Hat Linux rpm packages : http://freshrpms.net/
Fedora Core release 5 (Bordeaux) - Linux kernel 2.6.16-1.2069_FC5
Load : 0.52 0.63 0.56