Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

connect to Oracle with DBI

by fionbarr (Pilgrim)
on Aug 29, 2014 at 19:09 UTC ( #1099035=perlquestion: print w/ replies, xml ) Need Help??
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 }) +;
I am getting the error:
TNS:listener does not currently know of SID in connect descriptor

Comment on connect to Oracle with DBI
Select or Download Code
Re: connect to Oracle with DBI
by Corion (Pope) 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)?

      do I have to install DBD::Oracle (windows 7)
        No, you don't have to install it, it's already installed. But yes, DBD::Oracle must be installed.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://1099035]
Front-paged by toolic
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (9)
As of 2014-11-26 11:20 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My preferred Perl binaries come from:














    Results (167 votes), past polls