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


Reply    
 
Thread Tools Search this Thread Display Modes
    #1  
Old Unix and Linux 01-07-2017
timj123 timj123 is offline
Registered User
 
Join Date: Jan 2008
Last Activity: 28 February 2017, 9:09 PM EST
Posts: 102
Thanks: 10
Thanked 1 Time in 1 Post
Perl Oracle DBI through Apache problem

Experts,
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.

Code:
[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.


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

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

Thanks in advance.
Sponsored Links
Reply

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 04:13 PM
Perl connect to remote oracle db without local oracle installation frustrated1 Shell Programming and Scripting 0 08-05-2009 09:09 AM
Apache module & perl problem hjalle UNIX for Advanced & Expert Users 2 03-20-2009 08:56 AM
Apache Perl/CGI CreamHarry UNIX for Dummies Questions & Answers 1 03-14-2002 10:18 AM



All times are GMT -4. The time now is 02:19 PM.