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.
[reply]

      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

[reply]
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.
[reply]
[reply]

Back to Seekers of Perl Wisdom