Please provide an example of the code that fails. Better, write a short test script to see if you can connect. Here's one :

#!/usr/bin/perl -w

use strict;
use DBI;
use DBD::Oracle qw(:ora_types);
 
 
use Data::Dumper;
 
my $host="10.1.0.1";
my $sid="ora9i";
my $user="test";
my $passwd="test";

print 'DBI '.$DBI::VERSION."\nDBD ".$DBD::Oracle::VERSION."\n";

my $dbh = DBI->connect("dbi:Oracle:host=$host;sid=$sid", $user, $passw
+d) or die "can't connect : $!";
print "connected as $user to $host \n" if $dbh ;
[download]