I had the same problem, I added $ORACLE_HOME/lib to my ld.so.conf and it
fixed the problem.
Kosta Lekas
Fox River Financial Resources
630.482.7142 - office
630.885.9355 - mobile
630.232.6074 - fax
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Bill
BrownSent: Tuesday, October 03, 2006 11:11 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] RHEL4 Apache, FastCGI or Mod_Perl both return Unable
LoadDBIx::SearchBuilder Handle for ‘Oracle’
Have been working getting RT 3.6.1 running in RHEL4 Apache using
FASTCGI.
Getting the following in /var/log/httpd/error_log
[Unable to load DBIx::SearchBuilder database handle for ‘Oracle’.
Perhaps you’ve picked an invalid database type or spelled it
incorrectly.
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
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle/Oracle.pm line
6
Compilation failed in require at
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle/Oracle.pm line
6.
BEGIN failed–compilation aborted at
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle/Oracle.pm line
6.\nCompilation failed in require at (eval 195) line 1.
BEGIN failed–compilation aborted at (eval 195) line 1.\nCompilation
failed in require at /usr/local/rt/lib/RT.pm line 172.
Have gone over and over http://wiki.bestpractical.com
http://wiki.bestpractical.com/ ,
Carbon60: Cloud Consulting - Services and Solutions , http://www.google.com ,
http://lists.bestpractical.com/cgi-bin/htsearch, cpan forums even bought
the book!
I can successfully:
Make testdeps comes with no issues.
Make initialize-database for oracle. The database schema was added to
the Oracle database without a hitch.
Start the /usr/local/rt/bin/standalone_httpd and go to
http://localmachine http://localmachine/ the rt main screen comes up
and can login with root and password.
I have tried the following:
Adding environment LD_LIBRARY_PATH, ORACLE_HOME, ORACLE_BASE variables
to /usr/sbin/apachectl and /etc/init.d/httpd
Adding environment variables into LD_LIBRARY_PATH, ORACLE_HOME,
ORACLE_BASE /etc/httpd/conf/httpd.conf
Re-installed DBIx::SearchBuilder, DBI, DBD::Oracle
RT 3.6.1 running in RHEL4 Apache using mod_perl 2.0.
Tried setting up mod_perl 2.0 Installed perl-5.8.8-2.el4s1.i386.rpm and
mod_perl-2.1.0.2-4.el4s1.2.i386.rpm to see if that will work.
Getting the following in /var/log/httpd/error_log with mod_perl 2.0
[Tue Oct 03 09:42:18 2006] [error] [client 10.x.x.x] Unable to load
DBIx::SearchBuilder database handle for ‘Oracle’.\nPerhaps you’ve picked
an
invalid database type or spelled it incorrectly.\nCan’t load
‘/usr/lib/perl5/site_perl/5.8.8/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.8/i386-linux-thread-mu
lti/DynaLoader.pm line 230.\n at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle/Oracle.pm line
6\nCompilation failed in require at /usr
/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle/Oracle.pm line
6.\nBEGIN failed–compilation aborted at
/usr/lib/perl5/site_perl/5.8.8/DBIx/
SearchBuilder/Handle/Oracle.pm line 6.\nCompilation failed in require at
(eval 195) line 1.\nBEGIN failed–compilation aborted at (eval 195) line
1.\nCompilation failed in require at /usr/local/rt/lib/RT.pm line
172.\n
Any pointers would be great. I am out of testing ideas.
TIA (Thanks In advance)
Bill