RE: Oracle connect hangs forever

Get a 10046 trace of the process. This will tell you exactly what the
DB is waiting for.

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>

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

.

Relevant Pages

  • Oracle connect hangs forever
    ... Well we moved to this processing was moved to a new server which is running ... Oracle version 10.2.0.1.0. ... and it is hanging on a read of fd 6, which is the Oracle tns listener. ...
    (perl.dbi.users)
  • RE: Oracle connect hangs forever
    ... Note:340091.1 may be of interest to you concerning listener hanging on 10g. ... Subject: Oracle connect hangs forever ... and it is hanging on a read of fd 6, which is the Oracle tns listener. ...
    (perl.dbi.users)
  • [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)