Re: ORA-12500:TNS:Listener failed to start a dedicated server process

Hi,

It should not be the problem with your listener - it is rather the OS limit for oracle user (I had the same problem). Contact your OS administrator in order top raise the resources limit for your DB owner account.

regards,

Adam

Violin wrote:

> Hello,
> Lately I have a trouble Listener problem.
>
> My Database is Oracle 7.3.4 on NT4.0
> In initorcl.ora,the value of processes is 50
> But when I monitor the sessions in Instance Manager
> If there are already some sessions on database(maybe 8~15 sessions or less),
> THE NEXT ONE session which connects to database often has the error message:
>
> ORA-12500:TNS:Listener failed to start a dedicated server process
>
> The total sessions on the database are less then 50,
> BUT just cannot connect to database,
> Maybe somebody knows how to solve the problem.....
Received on Tue Sep 07 1999 - 05:59:00 CDT