Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

DBD::Oracle installation causing error

by rammohan (Acolyte)
on Feb 28, 2014 at 07:19 UTC ( #1076476=perlquestion: print w/replies, xml ) Need Help??

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

I want to connect to Oracle Database through Perl,for this I'm trying to install DBD::Oracle from CPAN by using following command
[root@localhost Admin]# cpan DBD::Oracle
While running above command on my Linux terminal I'm getting following Error
[root@localhost Admin]# cpan DBD::Oracle CPAN: Storable loaded ok (v2.45) Going to read '/root/.cpan/Metadata' Database was generated on Thu, 27 Feb 2014 06:17:02 GMT Running install for module 'DBD::Oracle' CPAN: YAML loaded ok (v0.88) Running make for P/PY/PYTHIAN/DBD-Oracle-1.70.tar.gz CPAN: Digest::SHA loaded ok (v5.47) CPAN: Compress::Zlib loaded ok (v2.063) Checksum for /root/.cpan/sources/authors/id/P/PY/PYTHIAN/DBD-Oracl +e-1.70.tar.gz ok DBD-Oracle-1.70/ DBD-Oracle-1.70/lib/ DBD-Oracle-1.70/lib/DBD/ DBD-Oracle-1.70/lib/DBD/Oracle.pm DBD-Oracle-1.70/lib/DBD/Oracle/ DBD-Oracle-1.70/lib/DBD/Oracle/GetInfo.pm DBD-Oracle-1.70/lib/DBD/Oracle/Troubleshooting/ DBD-Oracle-1.70/lib/DBD/Oracle/Troubleshooting/Win32.pod DBD-Oracle-1.70/lib/DBD/Oracle/Troubleshooting/Vms.pod DBD-Oracle-1.70/lib/DBD/Oracle/Troubleshooting/Hpux.pod DBD-Oracle-1.70/lib/DBD/Oracle/Troubleshooting/Aix.pod DBD-Oracle-1.70/lib/DBD/Oracle/Troubleshooting/Sun.pod DBD-Oracle-1.70/lib/DBD/Oracle/Troubleshooting/Macos.pod DBD-Oracle-1.70/lib/DBD/Oracle/Troubleshooting/Linux.pod DBD-Oracle-1.70/lib/DBD/Oracle/Troubleshooting/Cygwin.pod DBD-Oracle-1.70/lib/DBD/Oracle/Troubleshooting/Win64.pod DBD-Oracle-1.70/lib/DBD/Oracle/Troubleshooting.pod DBD-Oracle-1.70/lib/DBD/Oracle/Object.pm DBD-Oracle-1.70/oci.def DBD-Oracle-1.70/Makefile.PL DBD-Oracle-1.70/MANIFEST DBD-Oracle-1.70/ocitrace.h DBD-Oracle-1.70/Changes DBD-Oracle-1.70/LICENSE DBD-Oracle-1.70/README.help.txt DBD-Oracle-1.70/README.mkdn DBD-Oracle-1.70/INSTALL DBD-Oracle-1.70/Oracle.xs DBD-Oracle-1.70/CONTRIBUTORS DBD-Oracle-1.70/META.json DBD-Oracle-1.70/oci8.c DBD-Oracle-1.70/META.yml DBD-Oracle-1.70/Oracle.h DBD-Oracle-1.70/dbivport.h DBD-Oracle-1.70/typemap DBD-Oracle-1.70/t/ DBD-Oracle-1.70/t/23wide_db_al32utf8.t DBD-Oracle-1.70/t/00versions.t DBD-Oracle-1.70/t/22nchar_al32utf8.t DBD-Oracle-1.70/t/31lob.t DBD-Oracle-1.70/t/lib/ DBD-Oracle-1.70/t/lib/ExecuteArray.pm DBD-Oracle-1.70/t/10general.t DBD-Oracle-1.70/t/28array_bind.t DBD-Oracle-1.70/t/26exe_array.t DBD-Oracle-1.70/t/14threads.t DBD-Oracle-1.70/t/rt74753-utf8-encoded.t DBD-Oracle-1.70/t/23wide_db.t DBD-Oracle-1.70/t/22nchar_utf8.t DBD-Oracle-1.70/t/31lob_extended.t DBD-Oracle-1.70/t/000-report-versions-tiny.t DBD-Oracle-1.70/t/12impdata.t DBD-Oracle-1.70/t/36lob_leak.t DBD-Oracle-1.70/t/24implicit_utf8.t DBD-Oracle-1.70/t/38taf.t DBD-Oracle-1.70/t/21nchar.t DBD-Oracle-1.70/t/70meta.t DBD-Oracle-1.70/t/15nls.t DBD-Oracle-1.70/t/39attr.t DBD-Oracle-1.70/t/rt85886.t DBD-Oracle-1.70/t/34pres_lobs.t DBD-Oracle-1.70/t/56embbeded.t DBD-Oracle-1.70/t/40ph_type.t DBD-Oracle-1.70/t/55nested.t DBD-Oracle-1.70/t/30long.t DBD-Oracle-1.70/t/32xmltype.t DBD-Oracle-1.70/t/58object.t DBD-Oracle-1.70/t/50cursor.t DBD-Oracle-1.70/t/80ora_charset.t DBD-Oracle-1.70/t/51scroll.t DBD-Oracle-1.70/t/01base.t DBD-Oracle-1.70/t/20select.t DBD-Oracle-1.70/t/nchar_test_lib.pl DBD-Oracle-1.70/t/23wide_db_8bit.t DBD-Oracle-1.70/t/60reauth.t DBD-Oracle-1.70/t/rt13865.t DBD-Oracle-1.70/t/25plsql.t DBD-Oracle-1.70/examples/ DBD-Oracle-1.70/examples/japh DBD-Oracle-1.70/examples/oradump.pl DBD-Oracle-1.70/examples/ora_explain.pl DBD-Oracle-1.70/examples/commit.pl DBD-Oracle-1.70/examples/bind.pl DBD-Oracle-1.70/examples/curref.pl DBD-Oracle-1.70/examples/ex.pl DBD-Oracle-1.70/examples/read_long_via_blob_read.pl DBD-Oracle-1.70/examples/tabinfo.pl DBD-Oracle-1.70/examples/proc.pl DBD-Oracle-1.70/examples/sql DBD-Oracle-1.70/examples/mktable.pl DBD-Oracle-1.70/examples/inserting_longs.pl DBD-Oracle-1.70/examples/README DBD-Oracle-1.70/mkta.pl DBD-Oracle-1.70/Todo DBD-Oracle-1.70/dbdimp.h DBD-Oracle-1.70/hints/ DBD-Oracle-1.70/hints/macos_syms.pl DBD-Oracle-1.70/hints/macos_bundle.syms DBD-Oracle-1.70/hints/macos_lib.syms DBD-Oracle-1.70/hints/dgux.pl DBD-Oracle-1.70/hints/svr4.pl DBD-Oracle-1.70/dbdimp.c DBD-Oracle-1.70/README CPAN: File::Temp loaded ok (v0.22) CPAN.pm: Going to build P/PY/PYTHIAN/DBD-Oracle-1.70.tar.gz Using DBI 1.609 (for perl 5.010001 on x86_64-linux-thread-multi) i +nstalled in /usr/lib64/perl5/auto/DBI/ Configuring DBD::Oracle for perl 5.010001 on linux (x86_64-linux-t +hread-multi) Remember to actually *READ* the README file! Especially if you hav +e any problems. Trying to find an ORACLE_HOME Your LD_LIBRARY_PATH env var is set to '' The ORACLE_HOME environment variable is not set and I couldn +'t guess it. It must be set to hold the path to an Oracle installation di +rectory on this machine (or a machine with a compatible architecture +). See the appropriate README file for your OS for more informa +tion. ABORTED! Warning: No success on command[/usr/bin/perl Makefile.PL INSTALLDI +RS=site] PYTHIAN/DBD-Oracle-1.70.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 [root@localhost Admin]#

Currently I'm using LINUX CentOS . In my machine already sqldeveloper to cnnect oracle data base but is don't know the ORACLE_HOME is seted or not because I didn't install that one so.

Did any one face this problem before like me? Please tell me how to resolve this error . Your suggestion will be appropriate.

Replies are listed 'Best First'.
Re: DBD::Oracle installation causing error
by karlgoethebier (Monsignor) on Feb 28, 2014 at 07:44 UTC
    Trying to find an ORACLE_HOME Your LD_LIBRARY_PATH env var is set to '' The ORACLE_HOME environment variable is not set and I couldn't gue +ss it. It must be set to hold the path to an Oracle installation director +y on this machine (or a machine with a compatible architecture). See the appropriate README file for your OS for more information. ABORTED

    See the appropriate README file for your OS!

    I mentioned this already in the CB. Karl

    «The Crux of the Biscuit is the Apostrophe»

Re: DBD::Oracle installation causing error
by mje (Curate) on Feb 28, 2014 at 08:42 UTC

    Installing SQL Developer makes no difference here, it is a java application. You need to install Instant Client and you'll need to download and unzip the sqlplus, sdk and basic zips. You then set LD_LIBRARY_PATH to point to the dir you unzipped those packages in and export LD_LIBRARY_PATH.

    Occassionally Oracle distribute instant client with a symbolic link missing and that stops DBD::Oracle building. If this is the case look in the unzip dir for a lib called something like libclntsh.so.12.1 and create a symbolic link from libclntsh.so to libclntsh.so.12.1 if it does not already exist.

Re: DBD::Oracle installation causing error
by karlgoethebier (Monsignor) on Feb 28, 2014 at 08:52 UTC
Re: DBD::Oracle installation causing error
by McA (Priest) on Feb 28, 2014 at 08:01 UTC

    Hi,

    if you put DBD::Oracle LD_LIBRARY_PATH into Google you will see you're *not* the first one and you'll find many many hints solving this.

    Best regards
    McA

Re: DBD::Oracle installation causing error
by karlgoethebier (Monsignor) on Feb 28, 2014 at 08:34 UTC
Re: DBD::Oracle installation causing error
by rammohan (Acolyte) on Feb 28, 2014 at 12:28 UTC
    I Resolved this error by using
    oracle-instantclient11.2-basic-11.2.0.1.0-1.x86_64.rpm oracle-instantclient11.2-devel-11.2.0.1.0-1.x86_64.rpm oracle-instantclient11.2-sqlplus-11.2.0.1.0-1.x86_64.rpm
    these three RPM's
Re: DBD::Oracle installation causing error
by rammohan (Acolyte) on Feb 28, 2014 at 08:10 UTC
    Where I can see this " README file for your OS!" in my OS??

      Search in the module.

      ======================== | JUMP TO CONCLUSIONS | ------------------------ | ??? | JUMP | STRIKE| | | AGAIN | OUT | | | | | ------------------------ |COULD | LOSE | YES! | | BE | ONE | | | | TURN | | ------------------------ | NO! | ACCEPT| GO | | | IT | WILD | | | | | ------------------------ | ONE | THINK | MOOT! | | STEP | AGAIN | | | BACK | | | ------------------------ | START | ========================

      Karl

      «The Crux of the Biscuit is the Apostrophe»

        May I know what is that???

      This post explains how to find files and other resources associated with a CPAN module.

      -- Ken

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://1076476]
Approved by ww
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (6)
As of 2019-07-18 10:49 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?