[rt-users] Oracle DB connection problem

Drew Barnes barnesaw at ucrwcu.rwc.uc.edu
Tue Jun 14 11:30:41 EDT 2005



Maciak, TJ wrote:

> 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


For future reference, "sudo su - root" would have accomplished the same 
thing.

>  
> 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/Oracle.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
>
>------------------------------------------------------------------------
>
>_______________________________________________
>http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
>Be sure to check out the RT Wiki at http://wiki.bestpractical.com
>

-- 
Drew Barnes
Applications Analyst
Raymond Walters College
University of Cincinnati




More information about the rt-users mailing list