Oracle connect hangs forever
- From: shildreth@xxxxxxxxxxxxxxx (Scott T. Hildreth)
- Date: Tue, 25 Apr 2006 15:28:15 -0500
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>
.
- Prev by Date: DBD-Oracle.ppd
- Next by Date: RE: Oracle connect hangs forever
- Previous by thread: DBD-Oracle.ppd
- Next by thread: RE: Oracle connect hangs forever
- Index(es):
Relevant Pages
|
