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.

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

I Have a question Is there a way of installing this DBD::Oracle module via Command Line ?

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.

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]