Re: SQL*NET V1 Hangs!

In article <37hd44$en6_at_nova.sti.nasa.gov>, khuguley_at_sti.nasa.gov (Karen Huguley) says:
>
>I am having a problem with SQL*Net V1 (Version 1.2.7.7.1 to be exact).
>ORASRV appears to hang every 30-45 minutes! When this happens, all client
>applications hang as well. The listener process cannot even be
>terminated using the proper utility (tcpctl stop). I am forced to kill
>the UNIX process and then restart the listener. I think that I may
>have read in this newsgroup that there is a problem with zombie processes.
>Is that what I am experiencing? What can I do to resolve the prob?
>(BTW: I am running V7.0.16 on Solaris 2.3). I would appreciate any
>suggestions!
>
>K. Huguley
>NASA Center for Aerospace Information
>khuguley_at_casi.sti.nasa.gov

We were having a similar problem and found that specifying a timeout for user processes using sql*net helped. The command is:

tcpctl timeout 5

This forces a "hanging" process to timeout. Received on Tue Oct 18 1994 - 18:30:24 CET