Re: Listener not listening

Hi,

I saw similar problem in different versions (7.2.2, 7.3.2). There were errors when trying to create new connections to a server. Server was under heavy load - a large number of connect/query/disconnect requests (report processing). In many cases there was no any respond on connection request. Client process was simply frozen on connect.

I developed utility to generate a large number of connect/ disconnect pairs. It is interesting that 7.3.3 under NT4 SP3 was quite slow performing this test, but it was most stable and solid version. I ran test for 12 hours. It was up to 100 parallel connections (average was 50). There were no errors.

What error message did you recieve?

Andrew Protasov

In article <01be5b49$36c3e2a0$c76464c0_at_mickc.hmp-parc>,   "Mick Cooke" <bridgend-it_at_pavilion.co.uk> wrote:
> Oracle Workgroup Server 7.3.3.0.0
> NT Server 4.0 SP3
>
> The listener will be working fine and users are happily working away then
> it will decide it is not going to allow new connections to the database.
> Those already in are ok. This problem has occured a number of time (not
> regulary) and there is no indication that there is a problem in alrtlogs,
> trc files or in the NT event viewer.
>
> Has anyone experienced this phenominon? if so did they identify a solution
> as at prresent the only way I can get it to work is to shut the database
> down and restart the Server. (shutting the service and restarting, or
> issuing the net stop/start command have no effect.
>
> Thanks in Advance
> MickC
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Feb 19 1999 - 00:14:15 CST