Re: Listener Hanging

Hi!

I have faced same problem with Oracle 7.3.2.3.1 with NT 4.0 which is still running as Oracle sever in my organisation.
The reason that we figured out for this problem is that Oracle Listner dosent resumes the connection with the client if for once it got no answer from other side. In our server there was a utility which for a millisecond stops the network services to check the system and during this millisecond if some client has send the request to Oracle Listner, Listner will not be able to reply and so client will take it as connection is broken and will not try to connect again.

In my case rondomly one or two people use to get disconnected in a days or so. Then we ran a huge process which takes 2 hours to get over and uses all the resources of server. This program always use to get disconnected. Then we looked at the operating system side and saw that 1 internel process use to take whole of the resources of 1 processor of our server. So when ever that processor was used to connect to clients which is simultaneusly trying to connect to listner then the cleint use to disconnect while the client on other processor was running fine.

• We have Compaq Proliant 6500 with two pentium processors.

I hope this could help you in finding your problem.

Dhiresh Rustogi
rustogid_at_usa.net

Jerry Gitomer wrote:

> Hi Vaughan,
>
> By any chance was your system rebooted just before the problem
> recurred? The reason I ask is that we run 24x7 except for Sunday nights
> when all of our systems are rebooted. Every Monday morning when I come
> in I have to restart something that the operator forgot.
>
> Another thing to look for is "outside interference", for example,
> several years ago the company I was working for installed a system in a
> situation where the computer was in one building and two terminals were
> located across the street. We couldn't run a direct connect and this
> was in the days before economical microwave so we used modems. Every
> morning we would get a call from the customer reporting that they
> couldn't access the system. After much hair pulling it turned out that
> the problem was caused by the switchboard operator disconnecting the
> modem lines when she shut down for the night. Might you have some
> similar external factor that can impact your network connections.
>
> Regards
>
> Jerry
>
> Vaughan Mc Carthy wrote:
> >
> > Hi all
> >
> > I currently have a problem, where our listener on the server hangs
> > unexpectedly once daily. Our database version, is 7.3.2.3. and the version
> > of UNIX, is SINIX 5.43. Oracle recommended that we start the listener, using
> > nohup. The problem seemed to go away for a while, but started re-appearing
> > about a week ago. Does anybody have any ideas??
> > Regards
> > Vaughan
>
> --
> Jerry Gitomer Since I know how to spell DBA I became one.
> jgitomer_at_p3.net
Received on Mon Mar 09 1998 - 00:00:00 CST