Hi,
Note:340091.1 may be of interest to you concerning listener hanging on
10g.
Regards,
Michael
Date: Tue, 25 Apr 2006 15:19:27 -0600
From: "Reidy, Ron" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED], dbi-users@perl.org
Subject: 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:[EMAIL PROTECTED]
Sent: Tuesday, April 25, 2006 2:28 PM
To: dbi-users@perl.org
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
---//---
"He who learns must suffer. And even in our sleep,
pain that cannot forget, falls drop by drop upon the heart;
and, in our own despair, against our will,
comes wisdom to us by the awful grace of God."
--- Aeschylus
