Unix/Linux Go Back    

Shell Programming and Scripting BSD, Linux, and UNIX shell scripting — Post awk, bash, csh, ksh, perl, php, python, sed, sh, shell scripts, and other shell scripting languages questions here.

Perl Oracle DBI through Apache problem

Shell Programming and Scripting

Thread Tools Search this Thread Display Modes
Old Unix and Linux 01-07-2017   -   Original Discussion by timj123
timj123's Unix or Linux Image
timj123 timj123 is offline
Registered User
Join Date: Jan 2008
Last Activity: 8 December 2017, 2:44 PM EST
Posts: 114
Thanks: 12
Thanked 1 Time in 1 Post
Perl Oracle DBI through Apache problem

I've been struggling with making a Perl Oracle DBI script to work through my Apache webserver.
Mysql DBI scripts work fine, but I'm having issue's with Oracle.
The oracle script works on command line, but I'm getting an
"Internal Server Error" with apache

Sourcing the oracle .bash_profile before running the Oracle CGI script on command line works great, but I can't figure out how to do with apache.

I've set up the %ENV in the perl script to match the %ENV when oracle runs the command via command line.

Here's two command that show what's going on.

[root@server1 DBD]# /u01/app/oracle/product/11.2.0/DB11G/perl/bin/perl -le 'use DBD::Oracle; print $DBD::Oracle::VERSION'
Can't load '/u01/app/oracle/product/11.2.0/DB11G/perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libclntsh.so.11.1: cannot open shared object file: No such file or directory at /u01/app/oracle/product/11.2.0/DB11G/perl/lib/5.10.0/x86_64-linux-thread-multi/DynaLoader.pm line 203.
 at -e line 1
Compilation failed in require at -e line 1.
BEGIN failed--compilation aborted at -e line 1.

[oracle@server1 ~]$ /u01/app/oracle/product/11.2.0/DB11G/perl/bin/perl -le 'use DBD::Oracle; print $DBD::Oracle::VERSION'

Does anyone have any idea what's going on here?

Thanks in advance.
Sponsored Links

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Linux More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Problem with Perl script after moving from a Windows/Apache Server to a UNIX server. BigBobbyB Programming 9 05-02-2012 05:13 PM
Perl connect to remote oracle db without local oracle installation frustrated1 Shell Programming and Scripting 0 08-05-2009 10:09 AM
Apache module & perl problem hjalle UNIX for Advanced & Expert Users 2 03-20-2009 09:56 AM
Apache Perl/CGI CreamHarry UNIX for Dummies Questions & Answers 1 03-14-2002 11:18 AM

All times are GMT -4. The time now is 04:14 AM.