LinuxRSA has asked for the wisdom of the Perl Monks concerning the following question:

Hi All I got a request to install DBI::Oracle or DBD::Oracle on my Rhel Server, below is the output when using cpan:

[root@fsncgui01dv ~]# cpan
Terminal does not support AddHistory.

cpan shell -- CPAN exploration and modules installation (v1.9402)
Enter 'h' for help.

cpan[1]> install DBI::ORACLE
Going to read '/root/.cpan/Metadata'
  Database was generated on Thu, 14 May 2015 09:29:02 GMT
Warning: Cannot install DBI::ORACLE, don't know what it is.
Try the command

    i /DBI::ORACLE/
cpan[5]> i /DBI::ORACLE/
Module    Bio::DB::DBI::Oracle   (CJFIELDS/BioPerl-DB-1.006900.tar.gz)
Module  < Bio::DB::GFF::Adaptor::dbi::oracle (CJFIELDS/BioPerl-1.6.924
+.tar.gz)
Module  < Bio::DB::GFF::Adaptor::dbi::oracleace (CJFIELDS/BioPerl-1.6.
+924.tar.gz)
Module    Class::DBI::Oracle     (DANIEL/Class-DBI-Oracle-0.51.tar.gz)
Module    DBIx::Class::Schema::Loader::DBI::Oracle (ILMARI/DBIx-Class-
+Schema-Loader-0.07043.tar.gz)
Module    DBIx::Class::Storage::DBI::Oracle (RIBASUSHI/DBIx-Class-0.08
+2820.tar.gz)
Module    DBIx::Class::Storage::DBI::Oracle::Generic (RIBASUSHI/DBIx-C
+lass-0.082820.tar.gz)
Module    DBIx::Class::Storage::DBI::Oracle::WhereJoins (RIBASUSHI/DBI
+x-Class-0.082820.tar.gz)
Module    Data::Conveyor::Storage::DBI::Oracle (MARCEL/Data-Conveyor-1
+.103130.tar.gz)
Module    Data::Storage::DBI::Oracle (MARCEL/Data-Storage-1.102720.tar
+.gz)
Module    JAF::DBI::Oracle       (GRISHACE/Apache-JAF-0.21.tar.gz)
Module    SPOPS::DBI::Oracle     (CWINTERS/SPOPS-0.87.tar.gz)
Module    SQL::Translator::Parser::DBI::Oracle (ILMARI/SQL-Translator-
+0.11021.tar.gz)
13 items found

cpan[6]> install DBD::ORACLE
Warning: Cannot install DBD::ORACLE, don't know what it is.
Try the command

    i /DBD::ORACLE/

to find objects with matching identifiers.

cpan[7]> i DBD::Oracle
Module id = DBD::Oracle
    CPAN_USERID  PYTHIAN (Pythian Remote DBA <pause-at-pythian.com>)
    CPAN_VERSION 1.74
    CPAN_FILE    P/PY/PYTHIAN/DBD-Oracle-1.74.tar.gz
    UPLOAD_DATE  2014-04-25
    INST_FILE    (not installed)


cpan[8]>

[download]

Replies are listed 'Best First'.
Re: DBD::Oracle install issues on RHEL 6.5
by marto (Cardinal) on May 15, 2015 at 11:46 UTC
[reply]
[d/l]
[select]

      Thanks marto, see output below when using the correct command via cpan, please advise

      cpan[1]> install DBD::Oracle
Going to read '/root/.cpan/Metadata'
  Database was generated on Thu, 14 May 2015 09:29:02 GMT
Running install for module 'DBD::Oracle'
Running make for P/PY/PYTHIAN/DBD-Oracle-1.74.tar.gz
Checksum for /root/.cpan/sources/authors/id/P/PY/PYTHIAN/DBD-Oracle-1.
+74.tar.gz ok
Scanning cache /root/.cpan/build for sizes
......................................................................
+......DONE

  CPAN.pm: Going to build P/PY/PYTHIAN/DBD-Oracle-1.74.tar.gz

Multiple copies of Driver.xst found in: /usr/local/lib64/perl5/auto/DB
+I/ /usr/lib64/perl5/auto/DBI/ at Makefile.PL line 39.
Using DBI 1.633 (for perl 5.010001 on x86_64-linux-thread-multi) insta
+lled in /usr/local/lib64/perl5/auto/DBI/

Configuring DBD::Oracle for perl 5.010001 on linux (x86_64-linux-threa
+d-multi)

Remember to actually *READ* the README file! Especially if you have an
+y problems.

Trying to find an ORACLE_HOME
Your LD_LIBRARY_PATH env var is set to ':/opt/IBM/tivoli/netcool/platf
+orm/solaris2/lib:/opt/IBM/tivoli/netcool/omnibus/platform/solaris2/li
+b:/opt/IBM/tivoli/netcool/platform/solaris2/lib:/opt/IBM/tivoli/netco
+ol/omnibus/platform/solaris2/lib'

      The ORACLE_HOME environment variable is not set and I couldn't g
+uess it.
      It must be set to hold the path to an Oracle installation direct
+ory
      on this machine (or a machine with a compatible architecture).
      See the appropriate README file for your OS for more information
+.
      ABORTED!

Warning: No success on command[/usr/bin/perl Makefile.PL INSTALLDIRS=s
+ite]
  PYTHIAN/DBD-Oracle-1.74.tar.gz
  /usr/bin/perl Makefile.PL INSTALLDIRS=site -- NOT OK
Running make test
  Make had some problems, won't test
Running make install
  Make had some problems, won't install
Failed during this command:
 PYTHIAN/DBD-Oracle-1.74.tar.gz               : writemakefile NO '/usr
+/bin/perl Makefile.PL INSTALLDIRS=site' returned status 512

cpan[2]>

      [download]
[reply]
[d/l]

        Did you read the output?

        Remember to actually *READ* the README file! Especially if you have an
+y problems.

        [download]
        The ORACLE_HOME environment variable is not set and I couldn't guess i
+t.
It must be set to hold the path to an Oracle installation directory
on this machine (or a machine with a compatible architecture).
See the appropriate README file for your OS for more information.
      ABORTED!

        [download]

        If you want to make life easier for yourself, read the documentation for the tools you choose to use.

[reply]
[d/l]
[select]

Back to Seekers of Perl Wisdom