I've already answered this off-list. Here's the entire thread for posterity:
You need to: 1) Transfer the .tar.gz to the remote machine 2) Unpack it there 3) cd into DBD-Oracle-1.15 4) read the README and follow the instructions. You will need a C compiler on that machine, and you'll need a "full" install of the Oracle client (meaning it has the headers necessary to compile OCI and Pro*C applications). ------------------------------------------------------------------------ -------- From: RaviChandra Chelikam [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 20, 2007 2:11 PM To: Garrett, Philip (MAN-Corporate) Subject: RE: install_driver(Oracle) failed while connecting to oracle 10.2.0.2 Philip I Have downloaded the DBD::Oracle 1.15 from the link u have given and copied to my local machine. Should I compile it first in my local machine and then kept it in the remote machine where the oracle 10g is installed . Else Should I directly copy the whole folder DBD::Oracle 1.15 to remote machine and then compile. Actually the folder structure of DBD::Oracle 1.15 which I downloaded from the cpan link and the one which is already existing in remote machine is different. There is not even Makefile.pl file in the remote machine. Then how could I compile it in the remote machine. Could u plz let me know. Thanks & Regards Ravi ------------------------------------------------------------------------ -------- From: Garrett, Philip (MAN-Corporate) [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 21, 2007 12:29 AM To: RaviChandra Chelikam Subject: RE: install_driver(Oracle) failed while connecting to oracle 10.2.0.2 (2) is probably the safest route (least likely to require code changes). (3) is probably best long-term, but it might also require upgrading Perl and DBI. ------------------------------------------------------------------------ -------- From: RaviChandra Chelikam [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 20, 2007 1:53 PM To: Garrett, Philip (MAN-Corporate) Subject: RE: install_driver(Oracle) failed while connecting to oracle 10.2.0.2 Philip Sorry for disturbing u again. Since I am new to perl , I am getting many doubts. Thanks for ur patience and helping me . 1. Could u plz let me know whether , i should rebuild the existing DBD::Oracle 1.15 which is already existing in my application. If so, could u plz tell me the steps how to rebuild DBD::Oracle against the new 10g client . 2. Else should I download the DBD::Oracle 1.15 from the path u have given and then rebuild against the new 10g client. 3. Else should I download new version of DBD::Oracle and then rebuild against the new 10g client. Thanks & Regards Ravi ------------------------------------------------------------------------ -------- From: Garrett, Philip (MAN-Corporate) [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 20, 2007 11:55 PM To: RaviChandra Chelikam Cc: [email protected] Subject: 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:[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. ======================================================================== ==================================================== ======================================================================== ==================================================== 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. ======================================================================== ==================================================== ======================================================================== ==================================================== 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. ======================================================================== ====================================================
