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

From: Anil Sikri <anil_sikri_at_hotmail.com>
Date: Wed, 30 Aug 2000 23:41:31 CDT
Message-Id: <10604.115928@fatcity.com>

Chan,

     Check your listener.log in $ORACLE_HOME/network/log.
     You might be receiving errors like "TNS: Internal limit exceeded"

     In that case, you might need to tune some Unixware kernel
     parameters. These could be :
     1) maxup / maxuprc ( I am not sure about Unixware ) : This is the
        maximum no. of processes per user on Unix. I am sure this would
        have a default value > 4 , so this might not be a problem.
        I have had to tune this because each server process
        corresponding to a client process connects as user 'oracle' on
        Unix and it exceeded maxuprc a couple of times esp. once when a
        poorly written Java application was opening 300 simultaneous
        connections.
     2) Check the swap space on your Unixware server. I have seen this
        problem being caused due to insufficient swap space.
     3) Also check NFILE ( no. of file descriptors ).

You might also want to check the value of PROCESSES in the init.ora for your database.

Let me know if you need further help/info

Regards,
Anil Sikri

Original Message ---------------------------------

>Hi,
>
>My newly installed 8.1.5 server running on Unixware 7 does not allow more
>than 4 sessions. The following message is displayed:
>
>'ORA-12500: TNS: listener failed to start a dedicated server process.'
>
>What parameter should I change in order to allow more sessions?
>
>Thanks for any solution.
>
>
>Regards,
>
>Chan Siu Ming
>
>--
>Author: Chan Siu Ming
> INET: csm_tec_at_softhome.net
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at Received on Wed Aug 30 2000 - 23:41:31 CDT