Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Login/Connection timeout for DBD::Oracle?

by jfroebe (Parson)
on Jan 16, 2009 at 20:30 UTC ( #736930=perlquestion: print w/ replies, xml ) Need Help??
jfroebe has asked for the wisdom of the Perl Monks concerning the following question:

Hopefully, a simple question:

Does anyone know how to specify a login timeout in DBD::Oracle? The man page doesn't show any method for it. I ask because many of our Oracle servers are behind firewalls.. if the firewall is misconfigured or down, the connection attempt will simply hang.

Jason L. Froebe

Blog, Tech Blog

  • Comment on Login/Connection timeout for DBD::Oracle?

Replies are listed 'Best First'.
Re: Login/Connection timeout for DBD::Oracle?
by kennethk (Abbot) on Jan 16, 2009 at 20:36 UTC
    They discuss this issue, specifically for Oracle, in the DBI documentation. They suggest using signal handling - here's the discussion.

      Thanks! It'll work but I was hoping to avoid such an ugly thing as it may not be caught by Perl. But if I must...

      Jason L. Froebe

      Blog, Tech Blog

Re: Login/Connection timeout for DBD::Oracle?
by frieduck (Hermit) on Jan 17, 2009 at 18:01 UTC
    Maybe what you want is:

    sqlnet.outbound_connect_timeout

    Time in seconds after which a connection attempt will be timed out. ... This parameter should typically be set to +- 3 seconds. If not set, the client connection will block for the default TCP connect timeout duration.

    from http://www.orafaq.com/wiki/Sqlnet.ora, or the official documentation is here.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://736930]
Approved by Corion
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (3)
As of 2016-07-25 09:04 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    What is your favorite alternate name for a (specific) keyboard key?


















    Results (223 votes). Check out past polls.