RE: Oracle connect hangs forever

On Tue, 2006-04-25 at 15:19 -0600, Reidy, Ron wrote:
Get a 10046 trace of the process. This will tell you exactly what the
DB is waiting for.

What makes it worse or harder to track down is it seems to be momentary
problem. While this process hangs, others are connecting
no problem. It's almost as the Listener drops a packet or something to
that effect and the DBI connect is still waiting for it to return. This
is a high traffic DB so it may be easier to work around, unless the
problem worsens. Trace files would be huge.


I have had no issues with the TNS listener to date.l

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----Original Message-----
From: Scott T. Hildreth [mailto:shildreth@xxxxxxxxxxxxxxx]
Sent: Tuesday, April 25, 2006 2:28 PM
To: dbi-users@xxxxxxxx
Subject: Oracle connect hangs forever

I plan on using Sys::SigAction to wrap an alarm around the connect, but
I thought I would post to see if anyone else has seen this problem. I
have
a process that runs in cron every 2 minutes, it processes files that are
ftp'd
into our site. I set a lock file so that if the previous run is still
running
it will not start up and send an email indicating that a previous
process is still
running. Well we moved to this processing was moved to a new server
which is running
Oracle version 10.2.0.1.0. I've been having a problem where this
process is hanging
for serveral hours (occurs over night) until it is killed. I run an
strace on the pid
and it is hanging on a read of fd 6, which is the Oracle tns listener.
I don't believe
any thing has processed, because there are no raised errors. I think
that it has to be
hanging on the connect, since I believe the tns listener accepts a
connection and then
gives the connect process a direct socket to Oracle. As I stated
earlier, I was
wondering if anyone else on the list has problems with 10g tns listener?

Perl : 5.008008 (i686-linux)
OS : linux (2.6.14.6)
DBI : 1.50
DBD::mysql : 3.0002
DBD::Sponge : 11.10
DBD::SQLite : 1.11
DBD::Proxy : 0.2004
DBD::Oracle : 1.16
DBD::Multiplex : 1.98
DBD::File : 0.33
DBD::ExampleP : 11.12
DBD::DBM : 0.03


LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 25-APR-2006
15:27:25


Thanks,
STH

--
Scott T. Hildreth <shildreth@xxxxxxxxxxxxxxx>
.

Relevant Pages

  • [Full-disclosure] Oracle TNS Listener DoS and/or remote memory inspection
    ... Oracle TNS Listener DoS and/or remote memory inspection ... The TNS Listener can be crashed by an attacker causing a Denial of Service; ... Oracle was alerted to this flaw on the 22nd of June 2006. ... The views expressed in this email do not necessarily reflect NGS policy. ...
    (Full-Disclosure)
  • Oracle TNS Listener DoS and/or remote memory inspection
    ... Oracle TNS Listener DoS and/or remote memory inspection ... The TNS Listener can be crashed by an attacker causing a Denial of Service; ... Oracle was alerted to this flaw on the 22nd of June 2006. ... The views expressed in this email do not necessarily reflect NGS policy. ...
    (Bugtraq)
  • RE: Oracle DB Audity
    ... For Oracle you have a few remote options. ... commands (if the default non-existent TNS Listener authentication model is ... techniques from a world-class research group. ...
    (Pen-Test)