Perl & Oracle: DynaLoader.pm

I am working with Perl CGI, and I need to acceed to an Oracle database.
Actually, my scripts work when I execute them from a shell, but not via my WEB server:

>install_driver(Oracle) failed: Can't load >'/usr/local/depot/perl5.005_03/lib/site_perl/5.005>/sun4-solaris/auto/DBD/Oracle/Oracle.so' for >module DBD::Oracle: ld.so.1: /usr/local/bin/perl: >fatal: libclntsh.so.8.0: open failed: No such file or >directory at >/usr/local/depot/perl5.005_03/lib/5.00503/sun4->solaris/DynaLoader.pm line 169.

In my script, I have initialized the environment variables for Oracle. I don't understand why my server doesn't find these oracle libraries: they are there.

Did anybody have the same problem?

Thanks a lot for your answers, I really need some help.


vgadbinAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
webdbaConnect With a Mentor Commented:
I had this problem just recently while installing DBD::Oracle.  The problem was a failed library from Sun's Freeware Perl.  Try building perl over again and reinstalling DBI and then DBD for oracle and this should correct THIS problem.  You should be able to find the perl binary you need from www.perl.com
0
 
geotigerCommented:
How did you initializing env. var. for Oralce? Executing the script from a shell is different from browser because your web server may not have all the access that you have in the shell.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.