Re: Listener Hangs - Help!!!

ahall_at_cda.com wrote in article <875932779.8876_at_dejanews.com>...
> We are accessing an Oracle 7.3 database on a SCO Unix Open Server 5
> Server using SQLnet on Windows NT 4.0 clients. Our client application
> is a data entry system written in C++. When we have one or two people
> using the system lightly, everything works well for weeks at a time.
> However, when we get up to about 6 data entry temps, our Listener hangs
> every hour or less.

<snip>

Turn on the listener's tracing option and have a look at the trace files. It should give you some idea to what is wrong.

BTW, the listener forks() client connection in Unix - there is a Unix (kernel?) parameter that specifies how many children can be forked. If this parameter is to low, then the listener can not create a child for a connection. I think the error message is that the listener failed to start a dedicated server process. Does the C++ checks and display all errors? It may be that the listener returns an error but the C++ app ignores it?

When the listener is hanging, attempt a connection using SQL*Plus from a client and see if it returns any errors.

regards,
Billy Received on Mon Oct 06 1997 - 00:00:00 CDT