Re: Help please, "TNS:listener failed to start a dedicated server process"

You may be running into your process limit in the init.ora. Look in your alert.log and see any accompanying error messages. You can also turn on trace in the server's listener.ora and sqlnet.ora as well as the client's sqlnet.ora. You may also be running into a VMS process limit since this error means that a process could not be started on the server side for the connection request.

Phil Cook
Certified Oracle DBA

Gary Lee <gary_lee_at_dofasco.ca> wrote in article <34b41376.2389676_at_news.dofasco.ca>...
> Hi,
>
> We have a PowerBuilder application that successfully connects to an
> Oracle DB. However, when many users are using it at the same time we
> can hit some sort of connection limit and any additional connection
> attempts fail with this Oracle return message "TNS:listener failed to
> start a dedicated server process".
>
> We are using:
>
> PowerBuilder 5 application running in Windows 3.1
> SQLNET 2
> Oracle 7.1 running in VMS 6.1 on a DEC Alpha
>
> Does anyone know how to increase the number of connections limit?
>
> Thanks,
> Gary
>
Received on Fri Jan 16 1998 - 00:00:00 CET