/data/u01/app/oracle/product/10.2.0.4/perl/lib/site_perl/5.8.3/sun4-solaris-thread-multi/DBD/Oracle.pm /data/u01/app/oracle/product/10.2.0.4/ccr/engines/SunOS/perl/lib/site_perl/5.8.3/sun4-solaris-thread-multi/DBD/Oracle.pm /data/u01/app/crs/product/10.2.0.4/perl/lib/site_perl/5.8.3/sun4-solaris-thread-multi-64/DBD/Oracle.pm /data/u01/app/crs/product/10.2.0.4/ccr/engines/SunOS/perl/lib/site_perl/5.8.3/sun4-solaris-thread-multi/DBD/Oracle.pm /usr/perl5/site_perl/5.8.4/sun4-solaris-64int/DBD/Oracle.pm /usr/local/lib/perl5/site_perl/5.8.5/sun4-solaris/DBD/Oracle.pm /global/report/u01/app/orarep/product/10.2.0/perl/lib/site_perl/5.8.3/sun4-solaris-thread-multi/DBD/Oracle.pm /global/dwh/u01/app/oradw/product/10.2.0.4/perl/lib/site_perl/5.8.3/sun4-solaris-thread-multi/DBD/Oracle.pm /global/dwh/u01/app/oradw/product/10.2.0.4/ccr/engines/SunOS/perl/lib/site_perl/5.8.3/sun4-solaris-thread-multi/DBD/Oracle.pm /global/wheel/u01/app/orawhs/product/10.2.0/perl/lib/site_perl/5.8.3/sun4-solaris-thread-multi/DBD/Oracle.pm /global/wheel/u01/app/oratest/product/11.2.0.2/perl/lib/site_perl/5.10.0/sun4-solaris-thread-multi-64/DBD/Oracle.pm /global/wheel/u01/app/oratest/product/11.2.0.2/ccr/engines/SunOS/perl/lib/site_perl/5.8.3/sun4-solaris-thread-multi/DBD/Oracle.pm /oracle9/11.2.0.2_Disk/deinstall/perl/lib/site_perl/5.10.0/sun4-solaris-thread-multi-64/DBD/Oracle.pm #### @INC: /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 #### [db07-dc2:~] root% ls -l /usr/perl5/site_perl/5.8.4/sun4-solaris-64int/DBD total 812 -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 -rw-r--r-- 1 root root 198462 May 31 17:40 Oracle.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 #### [db07-dc2:~] root% ./dbitest.pl install_driver(Oracle) failed: Can't locate DBD/Oracle/Object.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 /usr/perl5/site_perl/5.8.4/sun4-solaris-64int/DBD/Oracle.pm line 25. BEGIN failed--compilation aborted at /usr/perl5/site_perl/5.8.4/sun4-solaris-64int/DBD/Oracle.pm line 25. Compilation failed in require at (eval 3) line 3. Perhaps a module that DBD::Oracle requires hasn't been fully installed at ./dbitest.pl line 19 #### my $dbh = DBI->connect( 'dbi:Oracle:qaecom1', #### my $dbh = DBI->connect( 'dbi:Oracle:qaecom1', '$USER', '$PASS', ) || die "Database connection not made: $DBI::errstr"; For easy reference this is the rest of the script #!/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="mlbwatch"; my $PASS="n3x1ch3q"; $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;