Re: 911-Strange lsnrctl problem

Try this:

During the day after the database has been used for a while, go in to the lsnrctl terminal prompt and type 'sevices'. See how many services are listed. Also, check the 'current:' and 'max:' attributes for the services. The total of all max servers should be nowhere near the parameter in listener.log (prespawn max: see below).

PRESPAWN_ MAX
The maximum number of prespawned dedicated server processes the listener will create. This number must be at least as many as the sum of the pool size for each protocol. For greatest efficiency, Oracle Corporation recommends a large value, so that prespawned dedicated server processes are always available for new connection requests.

Hope this helps.

>The other day the listener stopped. I had to do: lsnrctl start. OK, I
>checked all of the log files to see what the deal was, and the
>listener.log file gave me 4 errors, all of which were related to some
>parameter being reached. i.e. maxusers or max_procs. After checking the
Received on Sat Mar 01 1997 - 00:00:00 CST