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

Re^2: Oracle hangs at connect

by clscott (Friar)
on Aug 17, 2004 at 20:25 UTC ( [id://383787]=note: print w/replies, xml ) Need Help??


in reply to Re: Oracle hangs at connect
in thread Oracle hangs at connect

I'm following up to myself because I think someone has discovered the cause.

Unless you specify which port Oracle is listening on it will try port 1526 first, which would explain a long delay in waiting for a response before trying the more standard port of 1521.

my $dbh = DBI->connect("dbi:Oracle:host=$host;sid=$sid;port=$port");

Source: http://use.perl.org/~jdavidb/journal/20440

--
Clayton

Replies are listed 'Best First'.
Re^3: Oracle hangs at connect
by Anonymous Monk on Dec 24, 2008 at 04:29 UTC
    this is realy good answer. its worksfine Thanks

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://383787]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others surveying the Monastery: (3)
As of 2024-04-24 04:14 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found