[SOLVED] Can't locate DBD/Oracle.pm error, what to download?

james000 · 08-20-2020, 07:47 PM

Hello,

I have RHEL 7.6 server. Application guys are running some script to install their product and that is giving below message:

Code:

Can't locate DBD/Oracle.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at /tmp/export_cox_v1030.pl line 4.

Some other post was sugesting to install "DBD::Oracle ver 1.44" from CPAN, but this server is not reachable to outside world. So I can't run wget or any other utility to download from outside. Is there any package, which I can download to my laptop and then install on this server, to fix this error?

Please suggest.

Thanks

agillator · 08-20-2020, 08:48 PM

You are dealing with Perl and it needs a module installed (DBD::Oracle). The proper way to do it is to go to CPAN and follow the instructions for installing a new module. You say your computer is 'reachable' from the outside world. I assume that means you have access to the internet. If that is the case try

Code:

sudo cpan -i DBD::Oracle

in a terminal. It should grind away for a while and then it will be installed. If you do not have access to the internet but do from your laptop you can follow the instructions at

Code:

https://www.ibm.com/support/knowledgecenter/en/SSWSR9_11.5.0/com.ibm.pim.ins.doc/pim_tsk_installingperlmodulesothernointernet.html

or google for something like 'perl install module without access to internet' and find instructions you can follow. Note that it is possible to install it on another computer and then copy the pm file. But then you have to find where to put it (one of the directories in the @INC list). That may or may not work and is not a recommended solution. You are talking about a more complicated procedure than can really be listed here. Google for Perl instructions, for example 'perl @inc'. You will find better explanations and instructions.

james000 · 08-20-2020, 09:25 PM

Damn...I missed to type, "server is not reachable from outside world". Sorry about confusion. I edited my statement in OP now.

I downloaded Oracle.pm from https://metacpan.org/release/DBD-Ora.../DBD/Oracle.pm . But I an't information on, how to install this.
Not sure, if below is correct or not, but I tried

Code:

[root@gftrf-db01 tmp]# perl Oracle.pm
Can't locate DBD/Oracle/Object.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at Oracle.pm line 20.
BEGIN failed--compilation aborted at Oracle.pm line 20.
[root@v911x-callcovgcache1 tmp]# cat -n Oracle.pm | more
     1  #   Oracle.pm
     2  #
     3  #   Copyright (c) 1994-2005 Tim Bunce, Ireland
     4  #   Copyright (c) 2006-2008 John Scoles (The Pythian Group), Canada
     5  #
     6  #   See COPYRIGHT section in the documentation below
     7
     8  require 5.006;
     9
    10  my $ORACLE_ENV  = ($^O eq 'VMS') ? 'ORA_ROOT' : 'ORACLE_HOME';
    11
    12  {
    13  package DBD::Oracle;
    14      our $VERSION = '1.80'; # VERSION
    15  # ABSTRACT: Oracle database driver for the DBI module
    16
    17      use DBI ();
    18      use DynaLoader ();
    19      use Exporter ();
    20      use DBD::Oracle::Object();
    21
    22      $DBD::Oracle::VERSION ||= '1.00';
    23

agillator · 08-21-2020, 03:15 AM

You can try putting the pm file in one of the directories listed in @INC. It MAY work - or it may not. As I said, it is certainly not the recommended method. If it doesn't work then you will have to try one of the other methods which involve making a local copy of CPAN (or part of it). I have never done that or even tried but several sites have instructions if you google for it.