Can't get DBD:Oracle to work



Hi,

I'm having trouble getting perl to talk to my Oracle database.
I've installed and tested DBI and installed DBD. However, when I try to
run a perl script that accesses the database, I get this error:

**********
install_driver(Oracle) failed: Can't load
'/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so'
for module DBD::Oracle: libclntsh.so.10.1: cannot open shared object
file: No such file or directory at
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
at (eval 82) line 3
**********

I've tried *all* the suggestions on this thread:
http://groups.google.com/group/perl.dbi.users/browse_frm/thread/f597c88d3129cff4/2c16acd9527a7e73?tvc=1&q=Oracle.so#2c16acd9527a7e73

In summary, I've tried:
1. setting the $ORACLE_HOME/lib directory in etc/ld.so.conf and run
ldconfig
2. Added PassEnvParams for the standard Oracle env variables in
httpd.conf
3. set LD_RUN_PATH, LD_LIBRARY_PATH in Makefile.PL and re-built DBD
4. Every combination of the 3 above.

But I've had no success or even insight into what is causing this
problem. Any one out there who could help me out because I've been at
this for the better part of 1 week :(

Thank you!
--Zahid.

.



Relevant Pages

  • Re: Using COM in Perl... Possible?
    ... combines a data export step with a send to an Oracle database step. ... Our non-HTML code is all written in Perl, ... can Perl call COM objects? ... Another approach to the Oracle layer is to use DBI methods, ...
    (comp.lang.perl.misc)
  • Re: how to get datatype of columns of a table in perl script
    ... > which connects to oracle database and selects rows from a table and then ... Programming the Perl DBI: Database programming with Perl ... these titles may be useful too. ...
    (perl.dbi.users)
  • Re: Using COM in Perl... Possible?
    ... I've been tasked where I work to create an HTML interface that ... combines a data export step with a send to an Oracle database step. ... can Perl call COM objects? ... reporting symptoms of congestion ... ...
    (comp.lang.perl.misc)
  • Perl 5.6.0 Compatible With Windows 2003?
    ... We migrated an Oracle database from NT to Windows 2003. ... Perl 5.6.0 (Some of the scripts had some difficulty with later ... running the Perl script can access Win 2003's temp files, ... any other ideas on solving Perl's 'unable to open temporary file ...
    (comp.lang.perl.misc)