RE: Listener stops accepting client requests/connections

Denham,

The listener's job is to
- listen for incomming requests
- validate incomming requests from clients   (SID, service_name, client IP address etc.) - Redirect (by bequeathing or returning an address)   the client requests to an dispatcher or dedicated server. - listen for mere incomming requests.

Thus if the listener stops - intentionally og by error - then the established connections with the database(s) will continue to work.

The difficult part is to figure, why and when the listener brokes. A little hint may be to execute   lsnrctl service
to see if the lisener is alive at all and whether it is establishing or refusing new connections.

Just my DKK 0.02
(That is 2 =F8re in Danish).

Regards
Jesper Haure N=F8rrevang

-----Oprindelig meddelelse-----
Fra: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org] P=E5 vegne af Denham Eva
Sendt: 12. november 2004 13:19
Til: oracle-l_at_freelists.org
Emne: Listener stops accepting client requests/connections

Hello Folks,
=20

Has anyone any idea what this issue could be.

We have two servers a 9.2.0.3 and 8.1.7.4.1 both on Windows 2000 Servers

Both these servers' listeners have started an odd behavior, for no apparent reason they stop receiving/accepting client access.

However if you are connected you remain connected. There is also no specific time base for this behavior. Once the Listener services have been bounced everything appears normal for a day or so, then it happens again.

Strangely if we have had to stop and start the server because of parameter changes/anything the Listener is fine until a day or two thereafter.

=20

I have had the problem with Oracle metalink and passed tons of trace files and logs, with nothing.

This has become very frustrating.

=20

Has anyone else experienced this?

=20

Regards

Denham =20

--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l