Hi,<br>
I've tried using both the ways: I set ORACLE_HOME, LD_PATH_LIBRARY and PERL5LIB paths in <br>/etc/sysconfig/httpd
and restarted the server. But it didn't work and also tried including
the ORACLE_HOME/lib inside ld.so.sonf but even that too didn't work.
Please suggest if anything I am missing out.<br>
<br>
thanks,<br>
-siv<br>
<br>
<br>
<br><div><span class="gmail_quote">On 3/3/06, <b class="gmail_sendername">siva m</b> <<a href="mailto:tech.sivam@gmail.com">tech.sivam@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div style="direction: ltr;">I'll try both the ways(include library
path in /etc/ld.so.conf and env variables in /etc/sysconfig/httpd).
I'll let you know the results.<br><br>thanks again,<br></div><div style="direction: ltr;"><span class="sg">-siva</span></div><div style="direction: ltr;"><span class="e" id="q_109c2308bf9e309a_2"><br><br><div><span class="gmail_quote">
On 3/3/06, <b class="gmail_sendername">
Rick Philbrick</b> <<a href="mailto:rickphilbrick@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">rickphilbrick@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi,<br><br>This may not be what your experiencing but when I have Shared Object<br>problems one of the first places I check is /etc/ld.so.conf to ensure<br>that the paths to the .so are present. Might be worth a look.<br>
<br>If you do a locate for libclntsh.so.10.1 and its in /usr/local/lib<br>then you probably need to include that path in the ld.so.conf<br><br><br>Rickp<br><br>On 3/3/06, Jim Perrin <<a href="mailto:jperrin@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
jperrin@gmail.com</a>> wrote:<br>> On 3/3/06, siva m <<a href="mailto:tech.sivam@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">tech.sivam@gmail.com</a>> wrote:<br>> > Hi,
<br>> > I have CentOS 4.2 installed on my PC and I've successfully installed
<br>> > Oracle 10g along with apache web server(httpd) and perl-DBD-Oracle.<br>> ><br>> > The problem is trying to connect to oracle to oracle from a CGI script.<br>> > I defined all of the environment variables(ORACLE_HOME, LD_LIBRARY_PATH,
<br>> > PERL5LIB) in httpd.conf as well as apachectl scripts but I am getting the<br>> > following error in the logs:<br>> > =========================================<br>> > [Fri Mar 03 00:31:25 2006] [error] [client
<a href="http://192.168.251.6" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">192.168.251.6</a> ] Can't load<br>> > '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so'
<br>> > for module DBD::Oracle: libclntsh.so.10.1: cannot open shared object file:
<br>> > No such file or directory at<br>> > /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm<br>> > line 230.<br>> > ============================================<br>> > Also I disabled SELlinux, defined all of the above mentioned env variables
<br>> > in /etc/profile but now use.<br>> > One weird thing is that as a standalone perl script I can connect to oracle<br>> > but not through CGI.<br>> ><br>> > Can any one please suggest what's going wrong or what am I missing?
<br>><br>> The httpd env variables are supposed to go in /etc/sysconfig/httpd. Is<br>> that what you mean when you refer to apachectl scripts, or are you<br>> doing something else?<br>><br>><br>> --<br>
> "They that can give up essential liberty to obtain a little temporary<br>> safety deserve neither liberty nor safety''<br>> Benjamin Franklin 1775<br>> _______________________________________________<br>
> CentOS mailing list<br>> <a href="mailto:CentOS@centos.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">CentOS@centos.org</a><br>> <a href="http://lists.centos.org/mailman/listinfo/centos" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://lists.centos.org/mailman/listinfo/centos</a><br>><br>_______________________________________________
<br>CentOS mailing list<br><a href="mailto:CentOS@centos.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">CentOS@centos.org</a><br><a href="http://lists.centos.org/mailman/listinfo/centos" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://lists.centos.org/mailman/listinfo/centos</a><br></blockquote></div><br>
</span></div></blockquote></div><br>