I am at the end of my rope. I have created many perl scripts that draw data out of an Oracle Database. I can run these Scripts just fine on a Windows NT server running IIS and activestate perl. I also have a couple of RedHat Linux servers. These servers are going to be our web servers. I can get my scripts to run correctly and they run faster than on the NT server, but out of the blue it loses the Oracle.so or the libclntsh.so.8.0 files. At this point I can not do anything to fix it. I will try reinstalling the DBD::Oracle and DBI without any luck. I have shut down the Apache server and restarted it after different periods of time. I have also rebooted the machines(this is what we are trying to avoid with Linux) without any luck. The Error I am getting is:

Software error:
Can't load '/usr/lib/perl5/site_perl/5.6.0/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.0/i386-linux/DynaLoader.pm line 200. at (eval 13) line 3
For help, please send mail to the webmaster (root@localhost <mailto:root@localhost>), giving this error message and the time and date of the error.

Software error:
at /usr/lib/perl5/5.6.0/CGI/Carp.pm line 346. Compilation failed in require at /usr/lib/perl5/5.6.0/Carp.pm line 119. For help, please send mail to the webmaster (root@localhost <mailto:root@localhost>), giving this error message and the time and date of the error.
I am doing this on a Dell Optiplex with RH7 installed. I also used cpan to upgrade everything. This error is being thrown from the connect string. All my database portions of my scripts are almost exactly out of the Programming the Perl DBI book. 

#!/usr/bin/perl

use CGI;
use DBI;
use strict;
use CGI::Carp qw(fatalsToBrowser);
my $q = new CGI;
print $q->header;

my $dbh = DBI->connect("DBI:Oracle:host=myhost;sid=mysid", 'username',
+ 'password') or die "Connecting : $DBI::errstr\n";
#get the page settings
my $sth = $dbh->prepare("Select SYSDATE from dual");
$sth->execute;
print $sth->fetchrow_array;

[download]
I know this probably isn't a full Perl only question but I have exhausted all other means of looking for the answer.

Thanks

--BigJoe

Learn patience, you must.
Young PerlMonk, craves Not these things.
Use the source Luke.

In reply to Perl, DBI, Oracle, Apache by BigJoe

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.