Re: the opposite of DCD (dead connection detection)??

On Jan 11, 1:42 pm, joel garry <joel-ga..._at_home.com> wrote:
> On Jan 10, 10:59 am, Ben <benal..._at_yahoo.com> wrote:
>
>
>
>
>
> > On Jan 9, 11:14 am, bdbafh <bdb..._at_gmail.com> wrote:
>
> > > On Jan 9, 10:52 am, Ben <benal..._at_yahoo.com> wrote:
>
> > > > 10.2.0.2 AIX 5.2 64bit.
>
> > > > Idle connections are getting terminated in databases on one of our
> > > > servers. I've checked profiles and resource plans to see if any have a
> > > > limit on idle time and there are none. It was first noticed in an
> > > > application and I've since been testing scenarios using sqlplus and it
> > > > happens with sqlplus also. I also thought it was limited to
> > > > connections that were coming in from another server but that isn't the
> > > > case either.
>
> > > > Certain things that stand out. It doesn't happen if the connection is
> > > > for the sysdba user. It doesn't happen if the connection is a local
> > > > connection that doesn't have the @sid in the connection string.
>
> > > > Any thoughts?
>
> > > Is there a host-based firewall in use (meaning on the localhost)?
>
> > > Can you test out this for connection on the same subnet (that would
> > > not traverse a router) vs. connections from clients not on the same
> > > subnet?
>
> > > This sure smells like a network issue where (translated) connections
> > > are being timed out.
>
> > > Start working with the network techs to see if they have any ideas.
>
> > > -bdbafh
>
> > Just another little piece of info. I setup a cronjob to see how long
> > the connections stay connected when they are idle, looks like
> > approximately 12 hours
>
> That sounds like a TCP setting.  Seehttp://www.tek-tips.com/viewthread.cfm?qid=1407908&page=12
>
> Found by googling on:
> tcp port timeout aix
>
> I think he was looking at the wrong setting in that post, but I'm not
> on AIX so can't comment further.  But I believe there are more
> settings, including some that timeout the port after a longer time
> than seconds.  Might have time or wait in the name.
>
> This one seems to be saying I'm wrong:http://unix.derkeiler.com/Newsgroups/comp.unix.aix/2006-12/msg00359.html
>
> Maybe there's some resource limit on the AIX side... like the ulimit
> cpu seconds?
>
> jg
> --
> @home.com is bogus.
> "A slipping gear could let your M203 grenade launcher fire when
> you least expect it. That would make you quite unpopular in
> what's left of  your unit." - Army's magazine of preventive
> maintenance.- Hide quoted text -
>
> - Show quoted text -

our aix admin has found a patch for aix that might solve the issue but hasn't had time to install it on our test machine yet. I'll post back with an update if that does solve our issue. Received on Tue Jan 29 2008 - 13:13:09 CST