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:[EMAIL PROTECTED]
Sent: Tuesday, February 20, 2007 1:23 PM
To: Garrett, Philip (MAN-Corporate)
Cc: [email protected]
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:[EMAIL PROTECTED]
Sent: Tuesday, February 20, 2007 9:47 PM
To: RaviChandra Chelikam; [email protected]
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.
========================================================================
====================================================
