connect to Oracle with DBI

[fionbarr]

use strict; use warnings; apologies if this is duplicate

use DBI;

my $host        = "yyy.xxx.com";
my $user        = "user";
my $password    = "password";

my $dbh = DBI->connect("dbi:Oracle:host=$host;sid=orcl;port=7010",
               $user, $password, { RaiseError => 1, AutoCommit => 0 })
+;

I am getting the error:

TNS:listener does not currently know of SID in connect descriptor

[Corion]

Have you consulted with your database administrator whether the sid=orcl is the correct SID to use?

Most likely, you want to inspect your TNSNAMES.ORA to find out whether that SID is listed there.

Have you looked at the ::Troubleshooting files in DBD::Oracle for your operating system(s)?

[fionbarr]

do I have to install DBD::Oracle (windows 7)

[runrig]

No, you don't have to install it, it's already installed. But yes, DBD::Oracle must be installed.