<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1498" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=852592415-14062005>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</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=852592415-14062005>the user it was running as under sudo did not have the
environment variable set for the oracle library path.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=852592415-14062005></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=852592415-14062005>I tried this instead:</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=852592415-14062005></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=852592415-14062005>sudo su root</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=852592415-14062005>export
LD_LIBRARY_PATH=/opt/oracle/OraHome1/lib</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=852592415-14062005>/etc/init.d/httpd restart</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=852592415-14062005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=852592415-14062005>and it
resolved all of my problems! Now RT is running speedily on Oracle at our
site.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV align=left><SPAN style="FONT-FAMILY: times new roman"><FONT face=Arial
size=2>T.J. Maciak</FONT></SPAN></DIV><SPAN
style="FONT-FAMILY: times new roman">
<DIV align=left><FONT face=Arial color=#0000ff size=2></FONT><FONT face=Arial
color=#0000ff size=2></FONT><BR><FONT face=Arial size=2>Internet/Intranet
Developer<BR>Department of IT<BR>City of Grand Rapids<BR>P:
(616)456-3713</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>F:
(616)456-3448<BR><BR></DIV></FONT></SPAN>
<DIV> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] <B>On Behalf Of </B>Maciak,
TJ<BR><B>Sent:</B> Monday, June 13, 2005 2:41 PM<BR><B>To:</B>
rt-users@lists.bestpractical.com<BR><B>Subject:</B> [rt-users] Oracle DB
connection problem<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><SPAN class=913413918-13062005><FONT face=Arial size=2>I am getting an
error message when I visit my website that has RT running on
it.</FONT></SPAN></DIV>
<DIV><SPAN class=913413918-13062005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=913413918-13062005><FONT face=Arial size=2>The logs
state:</FONT></SPAN></DIV>
<DIV><SPAN class=913413918-13062005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=913413918-13062005><FONT face=Arial size=2>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/Oracle.so'
for module DBD::Oracle: libclntsh.so.9.0: cannot open shared object file: No
such file or direc<BR>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<BR>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<BR>ine
7.\nBEGIN failed--compilation aborted at
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle/Oracle.pm line
7.\nCompilat<BR>ion failed in require at (eval 238) line 1.\nBEGIN
failed--compilation aborted at (eval 238) line 1.\nCompilation failed in
requi<BR>re at /opt/rt3/lib/RT.pm line 164.\n</FONT></SPAN></DIV>
<DIV><SPAN class=913413918-13062005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=913413918-13062005><FONT face=Arial size=2>I have not changed
any configuration files since last week, and on Thursday/Friday I was able to
create the initial database</FONT></SPAN></DIV>
<DIV><SPAN class=913413918-13062005><FONT face=Arial size=2>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?</FONT></SPAN></DIV>
<DIV><SPAN class=913413918-13062005><FONT face=Arial size=2>I do have the
DBD::Oracle installed along with working oracle client etc. on this
machine.</FONT></SPAN></DIV>
<DIV><SPAN class=913413918-13062005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=913413918-13062005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=913413918-13062005><FONT face=Arial
size=2>Thanks,</FONT></SPAN></DIV>
<DIV><SPAN class=913413918-13062005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=913413918-13062005><FONT face=Arial
size=2>TJ</FONT></SPAN></DIV></BODY></HTML>