Hi,

This may not be what your experiencing but when I have Shared Object problems one of the first places I check is /etc/ld.so.conf to ensure that the paths to the .so are present. Might be worth a look.

If you do a locate for libclntsh.so.10.1 and its in /usr/local/lib then you probably need to include that path in the ld.so.conf

Rickp

On 3/3/06, Jim Perrin jperrin@gmail.com wrote:

On 3/3/06, siva m tech.sivam@gmail.com wrote:

...

Hi, I have CentOS 4.2 installed on my PC and I've successfully installed Oracle 10g along with apache web server(httpd) and perl-DBD-Oracle.

 The problem is trying to connect to oracle to oracle from a CGI script.

I defined all of the environment variables(ORACLE_HOME, LD_LIBRARY_PATH, PERL5LIB) in httpd.conf as well as apachectl scripts but I am getting the following error in the logs: ========================================= [Fri Mar 03 00:31:25 2006] [error] [client 192.168.251.6 ] 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. ============================================ Also I disabled SELlinux, defined all of the above mentioned env variables in /etc/profile but now use. One weird thing is that as a standalone perl script I can connect to oracle but not through CGI.

Can any one please suggest what's going wrong or what am I missing?

The httpd env variables are supposed to go in /etc/sysconfig/httpd. Is that what you mean when you refer to apachectl scripts, or are you doing something else?

-- "They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety'' Benjamin Franklin 1775 _______________________________________________ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos

Hi, I've tried using both the ways: I set ORACLE_HOME, LD_PATH_LIBRARY and PERL5LIB paths in /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.

thanks, -siv

On 3/3/06, siva m tech.sivam@gmail.com wrote:

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.

thanks again, -siva

On 3/3/06, Rick Philbrick rickphilbrick@gmail.com wrote:

...

Hi,

This may not be what your experiencing but when I have Shared Object problems one of the first places I check is /etc/ld.so.conf to ensure that the paths to the .so are present. Might be worth a look.

If you do a locate for libclntsh.so.10.1 and its in /usr/local/lib then you probably need to include that path in the ld.so.conf

Rickp

On 3/3/06, Jim Perrin < jperrin@gmail.com> wrote:

...

On 3/3/06, siva m tech.sivam@gmail.com wrote:

...

Hi, I have CentOS 4.2 installed on my PC and I've successfully

installed

...

...

Oracle 10g along with apache web server(httpd) and perl-DBD-Oracle.

 The problem is trying to connect to oracle to oracle from a CGI

script.

...

...

I defined all of the environment variables(ORACLE_HOME,

LD_LIBRARY_PATH,

...

...

PERL5LIB) in httpd.conf as well as apachectl scripts but I am

getting the

...

...

following error in the logs:

[Fri Mar 03 00:31:25 2006] [error] [client 192.168.251.6 ] 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. ============================================ Also I disabled SELlinux, defined all of the above mentioned env

variables

...

...

in /etc/profile but now use. One weird thing is that as a standalone perl script I can connect to

oracle

...

...

but not through CGI.

Can any one please suggest what's going wrong or what am I missing?

The httpd env variables are supposed to go in /etc/sysconfig/httpd. Is that what you mean when you refer to apachectl scripts, or are you doing something else?

-- "They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety'' Benjamin Franklin 1775 _______________________________________________ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos

---

CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos