Re: Error Message: ORA-12500 TNS: listener failed to start a dedicated server process

I'm going to investigate a very similar one tomorrow. This one has a complication: when it happens, some Oracle processes get orphaned and start consuming 100% of CPU. When the instance is stopped, they keep running until you kill them... IBM AIX, Oracle 7.3.3

Alexander Pastuhov
Senior Technical Consultant
CSSL Australia, Melbourne
(041 936 3524)

Kerri Leonard wrote:
>
> Hi,
>
> When users connect to the Oracle Database Server through Windows 3.1,
>
> they are getting the following error messages:
>
> ORA-12500 TNS: listener failed to start a dedicated server process
>
> ORA-01203 TNS, Unable to Connect to Destination
>
> ORA-12223 TNS: Internal limit restriction exceeded
>
> We are also receiving similiar error messages when trying to print,
>
> logging on to TNVT and in our SQLNET.log file.
>
> The number of processes in the init.ora have been increased. There is
>
> appoximately 80 concurrent users logged on when this error message
>
> occurs. Oracle 7.3 is installed on a Unix server version 5.
>
> We need to have approximately 300 concurrent users processes.
>
> Any suggestions to correct this problem?
>
> Thanks,
>
> Kerri
>
> -**** Posted from RemarQ, http://www.remarq.com/?b ****-
> Real Discussions for Real People
Received on Thu May 06 1999 - 06:33:24 CDT