Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer

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 = ""; 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?

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

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (6)
As of 2015-07-04 03:10 GMT
Find Nodes?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...

    Results (57 votes), past polls