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 <[EMAIL PROTECTED]>
