Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

connect to Oracle with DBI

by fionbarr (Friar)
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

Replies are listed 'Best First'.
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 all is quiet...

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (6)
As of 2016-12-11 09:36 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    On a regular basis, I'm most likely to spy upon:













    Results (169 votes). Check out past polls.