RE: install_driver(Oracle) failed while connecting to oracle 10.2.0.2

You need to rebuild DBD::Oracle against the new 10g client you
installed. You don't necessarily need to upgrade (which would be a good
idea though), but you DO need to rebuild it.


________________________________

From: RaviChandra Chelikam [mailto:rchelikam@xxxxxxxxxxxxxxxx]
Sent: Tuesday, February 20, 2007 1:23 PM
To: Garrett, Philip (MAN-Corporate)
Cc: dbi-users@xxxxxxxx
Subject: RE: install_driver(Oracle) failed while connecting to
oracle 10.2.0.2



Philip

We have Changed the permissions .

Even after that, I am getting the following error as





install_driver(Oracle) failed: Can't load
'/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBD/Oracle/Oracl
e.so' for module DBD::Oracle: ld.so.1: perl: fatal: libclntsh.so.9.0:
open failed: No such file or directory at
/usr/local/lib/perl5/5.6.1/sun4-solaris/DynaLoader.pm line 206.

at (eval 1) line 3

Compilation failed in require at (eval 1) line 3.

Perhaps a required shared library or dll isn't installed where
expected

at a.pl line 25







Actually it is searching for libclntsh.so.9.0(since the previous
oracle version was 9i) in
/usr/local/opt/oracle/product/10.2.0/lib32/and

Failing to open the file.

But since we migrated to 10g now
/usr/local/opt/oracle/product/10.2.0/lib32/ is having libclntsh.so.10.1



So, what should I do ,to point to libclntsh.so.10.1 instead of
libclntsh.so.9.0







Thanks & Regards
Ravi



-----Original Message-----
From: Garrett, Philip (MAN-Corporate)
[mailto:Philip.Garrett@xxxxxxxxxxx]
Sent: Tuesday, February 20, 2007 9:47 PM
To: RaviChandra Chelikam; dbi-users@xxxxxxxx
Subject: RE: install_driver(Oracle) failed while connecting to
oracle 10.2.0.2



Hi,



RaviChandra Chelikam wrote:

>

> perl: fatal:

> /usr/local/opt/oracle/product/ldcnmd/lib32/libclntsh.so.9.0:

> Permission denied at .....

^^^^^^^^^^^^^^^^^



The permissions on your Oracle installation are not letting Perl
load

the Oracle client library. The library file libclntsh.so.9.0
(or one of

the directories leading to it more likely) is not accessible as
the user

running the Perl script. Fix the permissions and your program
will

probably work ok.



Regards,

Philip

========================================================================
====================================================

Tech Mahindra, formerly Mahindra-British Telecom.

Disclaimer:

This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you may
review at http://www.techmahindra.com/Disclaimer.html externally and
http://tim.techmahindra.com/Disclaimer.html internally within Tech
Mahindra.

========================================================================
====================================================


Relevant Pages