in reply to Re^2: DBD::Oracle install issues on RHEL 6.5
in thread DBD::Oracle install issues on RHEL 6.5

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.

Replies are listed 'Best First'.
Re^4: DBD::Oracle install issues on RHEL 6.5
by LinuxRSA (Initiate) on May 15, 2015 at 12:13 UTC

    Thanks, iv read the Output, will forward it onto the DBA section as I only do Linux admin - will update soonest

[reply]
Re^4: DBD::Oracle install issues on RHEL 6.5
by LinuxRSA (Initiate) on May 15, 2015 at 12:44 UTC
    I Have a question Is there a way of installing this DBD::Oracle module via Command Line ?
[reply]

      This is covered in the installation documentation, which I previously suggested you read. I could read it to you, but I can't understand it for you.

[reply]

      Hi Guys - So I have set my ORACLE_HOME & LD_LIBRARY_PATH

      Getting a NEW error now, my oracle client is v12.0.1 when installing DBD::Oracle via cpan it gives me the below output, please advise

       [root@tcncgui01 /]# echo $ORACLE_HOME
/usr/lib/oracle/12.1/client64
[root@tcncgui01 /]#
[root@tcncgui01 /]# echo $LD_LIBRARY_PATH
/usr/lib/oracle/12.1/client64/lib
[root@tcncgui01 /]# cpan
Terminal does not support AddHistory.

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

cpan[1]> i /DBD::Oracle/
Going to read '/root/.cpan/Metadata'
  Database was generated on Wed, 20 May 2015 09:53:34 GMT
Module    DBD::Oracle            (PYTHIAN/DBD-Oracle-1.74.tar.gz)
Module    DBD::Oracle::GetInfo   (PYTHIAN/DBD-Oracle-1.74.tar.gz)
Module    DBD::Oracle::Object    (PYTHIAN/DBD-Oracle-1.74.tar.gz)
Module    DBD::Oracle::Troubleshooting (PYTHIAN/DBD-Oracle-1.46.tar.gz
+)
Module    DBD::Oracle::db        (PYTHIAN/DBD-Oracle-1.50.tar.gz)
Module    DBD::Oracle::dr        (PYTHIAN/DBD-Oracle-1.50.tar.gz)
Module    DBD::Oracle::st        (PYTHIAN/DBD-Oracle-1.50.tar.gz)
Module    DBIx::DBSchema::DBD::Oracle (IVAN/DBIx-DBSchema-0.45.tar.gz)
Module    DBIx::Skinny::DBD::Oracle (NEKOKAK/DBIx-Skinny-0.0742.tar.gz
+)
Module    Data::ObjectDriver::Driver::DBD::Oracle (SIXAPART/Data-Objec
+tDriver-0.13.tar.gz)
Module    Data::ObjectDriver::Driver::DBD::Oracle::db (SIXAPART/Data-O
+bjectDriver-0.13.tar.gz)
11 items found

cpan[3]> install DBD::Oracle
Running install for module 'DBD::Oracle'
'YAML' not installed, falling back to Data::Dumper and Storable to rea
+d prefs '/root/.cpan/prefs'
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.

Installing on a linux, Ver#2.6
Using Oracle in /usr/lib/oracle/12.1/client64
Can't find sqlplus. Pity, it would have helped.
I'm having trouble finding your Oracle version number... trying harder

WARNING: I could not determine Oracle client version so I'll just
default to version 8.0.0.0. Some features of DBD::Oracle may not work.
Oracle version based logic in Makefile.PL may produce erroneous result
+s.
You can use "perl Makefile.PL -V X.Y.Z" to specify a your client versi
+on.

Oracle version 8.0.0.0 (8.0)
DBD::Oracle no longer supports Oracle client versions before 9.2
Try a version before 1.25 for 9 and 1.18 for 8! at Makefile.PL line 27
+1.
Warning: No success on command[/usr/bin/perl Makefile.PL INSTALLDIRS=s
+ite]
Warning (usually harmless): 'YAML' not installed, will not store persi
+stent state
  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
Could not read '/root/.cpan/build/DBD-Oracle-1.74-BKzJIH/META.yml'. Fa
+lling back to other methods to determine prerequisites
Failed during this command:
PYTHIAN/DBD-Oracle-1.74.tar.gz               : writemakefile NO '/usr/
+bin/perl Makefile.PL INSTALLDIRS=site' returned status 512

cpan[4]>

      [download]
[reply]
[d/l]
        WARNING: I could not determine Oracle client version so I'll just
default to version 8.0.0.0. Some features of DBD::Oracle may not work.
Oracle version based logic in Makefile.PL may produce erroneous result
+s.
You can use "perl Makefile.PL -V X.Y.Z" to specify a your client versi
+on.

Oracle version 8.0.0.0 (8.0)
DBD::Oracle no longer supports Oracle client versions before 9.2
Try a version before 1.25 for 9 and 1.18 for 8! at Makefile.PL line 27
+1.

        [download]

        As previously discussed, you're going to have to stop ignoring the information displayed. This message is quite clear and the documentation discusses installation in detail.

[reply]
[d/l]
        A reply falls below the community's threshold of quality. You may see it by logging in.

In Section Seekers of Perl Wisdom