the oracle install is a real PITA.
Install oracle install client for, I think in your situation, 64 bit perl, and for your platform. Downloadable for free from oracle.com, after nagging you to create an account with user/pw.
Before doing anything with the perl install, verify that you can connect to an oracle db with instantclient.
I did something like this
in reply to Install Module DBD crashes with "Cant find library"
After I verified that I could commit to sqlplus, I cd-ed into the build dir for DBD::Oracle and force-installed.
$ cat oracle-env.sh
#export ORACLE_DSN='mydb2.myhost' # this dien't work
export ORACLE_DSN='dbi:Oracle:host=myhost;sid=mydb2' # necessary to ge
+t make test to work in dbd::oracle
#needed for sqlplus
alias go-dbd-oracle='cd /usr/cpanroot64/.cpan/build/DBD-Oracle-1.18'
#$dbh = DBI->connect("dbi:Oracle:host=myhost.com;sid=ORCL", $user, $pa
alias the-sqlplus='sqlplus firstname.lastname@example.org'