connect to Oracle with DBI

fionbarr has asked for the wisdom of the Perl Monks concerning the following question:

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 })
+;
[download]

I am getting the error:

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

Comment on connect to Oracle with DBI Select or Download Code

Replies are listed 'Best First'.
Re: connect to Oracle with DBI by Corion (Patriarch) on Aug 29, 2014 at 19:25 UTC
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)?	[reply] [d/l] [select]
Re^2: connect to Oracle with DBI by fionbarr (Friar) on Aug 29, 2014 at 19:35 UTC
do I have to install DBD::Oracle (windows 7)	[reply]
Re^3: connect to Oracle with DBI by runrig (Abbot) on Aug 29, 2014 at 20:07 UTC
No, you don't have to install it, it's already installed. But yes, DBD::Oracle must be installed.	[reply]