Perl DB connection with Oracle 10g Express edition using Padre Perl IDE

[Kamalendu]

1. I am using Padre perl IDE
2. I have DBD-Oracle-1.19 installed in my machine.
3. Oracle 10g Express Edition is Installed.

Source code

#!/usr/bin/perl -w
 
use 5.006;
use strict;
use warnings;
use DBI;
 
my $dbh  = 0;
$dbh = DBI->connect("dbi:Oracle:host=myhost.com;sid=ORCL","system","system", 
                      {
                        RaiseError => 1,
                        AutoCommit => 0
                      }  ) || die "Database connection not made: $DBI::errstr";
 
print "Hello\n"; 
 

Error:
DBI connect('host=myhost.com;sid=ORCL','system',...) failed: ORA-12170: TNS:Connect timeout occurred (DBD ERROR: OCIServerAttach) at C:\Users\ekamroy\Documents\Kamalendu\Perl_Er\useDB .pl line 9

=================================================

Can anyone propose any solution?

[numberwhun]

Can you manually connect to the database with the parameters you have provided? It looks like DBI is not able to as that is the error being thrown.

Regards,

Jeff