[rt-users] Oracle DB connection problem

[Maciak, TJ]

I figured out what the problem was - turns out when I was starting apache as
"sudo /etc/init.d/httpd restart" from my own user that
the user it was running as under sudo did not have the environment variable
set for the oracle library path.
 
I tried this instead:
 
sudo su root
export LD_LIBRARY_PATH=/opt/oracle/OraHome1/lib
/etc/init.d/httpd restart
 
and it resolved all of my problems!  Now RT is running speedily on Oracle at
our site.
 
T.J. Maciak

Internet/Intranet Developer
Department of IT
City of Grand Rapids
P: (616)456-3713
F: (616)456-3448


 

  _____  

From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Maciak, TJ
Sent: Monday, June 13, 2005 2:41 PM
To: rt-users at lists.bestpractical.com
Subject: [rt-users] Oracle DB connection problem


I am getting an error message when I visit my website that has RT running on
it.
 
The logs state:
 
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.5/i386-linux-thread-multi/auto/DBD/Oracle/Orac
le.so' for module DBD::Oracle: libclntsh.so.9.0: cannot open shared object
file: No such file or direc
tory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line
230.\n at /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuild
er/Handle/Oracle.pm line 7\nCompilation failed in require at
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle/Oracle.pm l
ine 7.\nBEGIN failed--compilation aborted at
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle/Oracle.pm line
7.\nCompilat
ion failed in require at (eval 238) line 1.\nBEGIN failed--compilation
aborted at (eval 238) line 1.\nCompilation failed in requi
re at /opt/rt3/lib/RT.pm line 164.\n
 
I have not changed any configuration files since last week, and on
Thursday/Friday I was able to create the initial database
system in my oracle db.  Does anyone have any advice on what I might be able
to check or try to get this to work right?
I do have the DBD::Oracle installed along with working oracle client etc. on
this machine.
 
 
Thanks,
 
TJ
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20050614/b8be3370/attachment.htm>