[db07-dc2:~] root% ./dbitest.pl 
install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC (@INC contains: /usr/perl5/5.8.4/lib/sun4-solaris-64int /usr/perl5/5.8.4/lib /usr/perl5/site_perl/5.8.4/sun4-solaris-64int /usr/perl5/site_perl/5.8.4 /usr/perl5/site_perl /usr/perl5/vendor_perl/5.8.4/sun4-solaris-64int /usr/perl5/vendor_perl/5.8.4 /usr/perl5/vendor_perl .) at (eval 3) line 3.
Perhaps the DBD::Oracle perl module hasn't been fully installed,
or perhaps the capitalisation of 'Oracle' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, Proxy, Sponge.
 at ./dbitest.pl line 19

##</code><code>##

#!/usr/bin/perl
use warnings;
use strict;
use DBI;

my $ORACLE_HOME = "/u01/app/oracle/product/10.2.0.4";
my $ORACLE_SID="qaecom1";
my $USER="user";
my $PASS="password";

$ENV{ORACLE_HOME}=$ORACLE_HOME;
$ENV{ORACLE_SID}=$ORACLE_SID;
$ENV{PATH}="$ORACLE_HOME/bin";
$ENV{LD_LIBRARY_PATH}="$ORACLE_HOME/lib";


use strict;
use DBI;
my $dbh = DBI->connect( 'dbi:Oracle:qaecom1',
                        '$USER',
                        '$PASS',
                      ) || die "Database connection not made: $DBI::errstr";
$dbh->disconnect;

##</code><code>##

cpan> install DBD::Oracle
CPAN: Storable loaded ok
Going to read /homedir/.cpan/Metadata
  Database was generated on Thu, 31 May 2012 00:43:03 GMT
DBD::Oracle is up to date.

##</code><code>##

[db07-dc2:~] root% ls -l /usr/perl5/site_perl/5.8.4/sun4-solaris-64int/ | grep DBD
drwxr-xr-x   4 root     root         512 Dec 12 15:50 DBD

##</code><code>##

[db07-dc2:~] root% ls -l /usr/perl5/site_perl/5.8.4/sun4-solaris-64int/DBD
total 396
-r--r--r--   1 root     root       52180 Dec 21  2010 DBM.pm
-r--r--r--   1 root     root       12168 Aug 16  2010 ExampleP.pm
drwxr-xr-x   2 root     root         512 Dec 12 15:50 File
-r--r--r--   1 root     root       44277 Dec 21  2010 File.pm
drwxr-xr-x   4 root     root         512 Dec 12 15:50 Gofer
-r--r--r--   1 root     root       48753 Jul 26  2010 Gofer.pm
-r--r--r--   1 root     root        4065 Dec 21  2010 NullP.pm
-r--r--r--   1 root     root       29044 Jun  8  2010 Proxy.pm
-r--r--r--   1 root     root        7983 Sep 26  2007 Sponge.pm