topic Re: listener Problem in Operating System - HP-UX

listener Problem

Fernando Jose P de Souz — Wed, 05 Oct 2005 09:37:40 GMT

Hi,

I have a problem with my HP-UX 11.23 Server
Database Oracle 9.2.0.2

The listener catch when a lot of users connect to database.

i try to execute the kill comand, but nothing,
and after timed out, +- 10 minutes,
then i start the listener again.

Where can i set in the hp-ux the port 1521 to 30 seconds(timed out) the conection to the user after the user desconect.

Wait

Fernando.

Re: listener Problem

Jean-Luc Oudart — Wed, 05 Oct 2005 10:35:28 GMT

Fernando

Not to sure I understood your pb.
there is a parameter CONNECT_TIMEOUT_listener_name or
INBOUND_CONNECT_TIMEOUT_ from 9i onwards.

default is 10 seconds

May you could give more details on error messages (anything in the log) ?

Regards
Jean-Luc

Re: listener Problem

Sandman! — Wed, 05 Oct 2005 11:35:56 GMT

Taking a stab at your problem, prefer if you can shed more light on it though? Within Oracle you can enable dead connection detection so that disconnected users have their corresponding server processes removed thereby reducing the listener load.

hope it helps!

Re: listener Problem

Yogeeraj_1 — Wed, 05 Oct 2005 23:12:31 GMT

HI fernando,

have a look at the following url:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/network.htm

you may also wish to define user profiles and configure the following resource parameters:
CONNECT_TIME
CPU_PER_CALL
CPU_PER_SESSION
SESSIONS_PER_USER

hope this helps too!

kind regards
yogeeraj

Re: listener Problem

B. Hulst — Mon, 17 Oct 2005 03:30:22 GMT

A lot of users?

Are there more users trying to connect to the database then you have oracle connections available?

Better check the number of oracle processes too...

Regards,
Bob