#!/usr/bin/perl -I/home/install/perl
$ENV{'ORACLE_HOME'}="/home/root/home/xyzco/oracle/oracle/product/12.1.0/dbHome_1";
$ENV{'LD_LIBRARY_PATH'}="/home/root/home/xyzco/oracle/oracle/product/12.1.0/dbHome_1/lib:/lib:/usr/lib";
use DBI;
print $ENV{'LD_LIBRARY_PATH'};

$dbh = DBI->connect( "dbi:Oracle:host=127.0.0.1;sid=V1011679;port=1521", isx, devpassXD0kei4Eo3W3n9n, { AutoCommit => 1} );

##</code><code>##

site1:/home/install/perl/auto/DBD/Oracle # perl test.pl
AJS Dynaloader -/home/install/perl/auto/DBI/DBI.so-
AJS Dynaloader
AJS Dynaloader -/home/install/perl/auto/DBD/Oracle/Oracle.so-
/home/root/home/xyzco/oracle/oracle/product/12.1.0/dbHome_1/lib:/lib:/usr/libAJS Dynaloader /home/root/home/xyzco/oracle/oracle/product/12.1.0/dbHome_1/lib:/lib:/usr/lib
install_driver(Oracle) failed: Can't load '/home/install/perl/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libclntsh.so.11.1: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/DynaLoader.pm line 205.
 at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
 at test.pl line 7

##</code><code>##

site1:/home/install/perl/auto/DBD/Oracle # declare -x LD_LIBRARY_PATH="/home/root/home/xyzco/oracle/oracle/product/12.1.0/dbHome_1/lib:/lib:/usr/lib"

##</code><code>##

site1:/home/install/perl/auto/DBD/Oracle # perl test.pl
AJS Dynaloader -/home/install/perl/auto/DBI/DBI.so-
AJS Dynaloader /home/root/home/xyzco/oracle/oracle/product/12.1.0/dbHome_1/lib:/lib:/usr/lib
AJS Dynaloader -/home/install/perl/auto/DBD/Oracle/Oracle.so-
/home/root/home/xyzco/oracle/oracle/product/12.1.0/dbHome_1/lib:/lib:/usr/libAJS Dynaloader /home/root/home/xyzco/oracle/oracle/product/12.1.0/dbHome_1/lib:/lib:/usr/lib