Apache/Perl/Oracle9i

[Kevin Moore]

Hi All

I'm attempting to use perl DBI/DBD in a .cgi script to access an oracle 
database. I can run the script using perl file.cgi successfully but when 
I attempt to execute the same cgi script through apache I receive the 
following:

  Software error:

install_driver(Oracle) failed: Can't load 
'/usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBD/Oracle/Oracle.so' for module 
DBD::Oracle: libclntsh.so.8.0: cannot open shared object file: No such file or 
directory at /usr/lib/perl5/5.6.1/i386-linux/DynaLoader.pm line 206.
at (eval 4) line 3
Compilation failed in require at (eval 4) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /home/httpd/cgi-bin/signup.cgi line 32
Are there environment variables I need to set to find the path to this 
file, if so, where can I find a list of these variables. The install of 
DBI and DBD were successful. Also, the oracle files/shared library files 
are indeed where they are supposed to be. Thanks for any help.

Kevin

 

Re: Apache/Perl/Oracle9i

[Andy Hassall]

Kevin Moore wrote:
 I'm attempting to use perl DBI/DBD in a .cgi script to access an
 oracle
 database. I can run the script using perl file.cgi successfully but
 when
 I attempt to execute the same cgi script through apache I receive the
 following:

   Software error:

 install_driver(Oracle) failed: Can't load
 '/usr/lib/perl5/site_perl/5.6.1/i386-linux/auto/DBD/Oracle/Oracle.so'
 for module DBD::Oracle: libclntsh.so.8.0: cannot open shared object
^^^
 It _looks_ like you have a DBD::Oracle compiled against Oracle 8i
libraries, your local environment is set to an 8i ORACLE_HOME (so it works)
but your Apache server either is missing the required paths (ORACLE_HOME,
LD_LIBRARY_PATH) or it's pointing to a 9i home (since you mention 9i in the
subject).

-- 
Andy Hassall ([EMAIL PROTECTED]) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)