Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Sun Solaris 8 - Listener failed to start a dedicated server proce

Sun Solaris 8 - Listener failed to start a dedicated server proce

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Tue, 22 May 2001 10:55:38 -0700
Message-ID: <F001.0030B281.20010522105706@fatcity.com>

On one of our Sun (development) servers, we have 8 databases running for different versions of Oracle (7.3.4, 8.0.6, 8.1.6). I am able to connect with SQL*Plus on the server, but I can't connect from a client. I get the following error

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

The server's listener.log shows the following error:

22-MAY-2001 10:26:25 * service_died * 0
22-MAY-2001 10:27:26 * service_died * 0
22-MAY-2001 10:28:18 * (CONNECT_DATA=(SID=dbname)(CID=(PROGRAM=C:\Oracle\Ora81\BIN\SQLPLUSW.EXE)(HOST=mypc)(USER=Jacques_Kilchoer))) * (ADDRESS=(PROTOCOL=tcp)(HOST=xx.x.xx.xx)(PORT=4949)) * establish * dbname * 12500

TNS-12500: TNS:listener failed to start a dedicated server process
 TNS-12540: TNS:internal limit restriction exceeded
  TNS-12560: TNS:protocol adapter error
   TNS-00510: Internal limit restriction exceeded
    Solaris Error: 12: Not enough space

22-MAY-2001 10:28:28 * service_died * 0

I would think that Solaris Error: 12 corresponds to this error number from /usr/include/sys/errno.h

#define ENOMEM  12      /* Not enough core                      */


The Sun server has 4 processors / 4GB of ram.

ipcs shows that there should be plenty of RAM available (about 680MB being used). swap -s shows that there is plenty of swap space available (4GB). I don't have an X-windows emulator on my machine so I don't think I can run admintool (is that right?)

A search on Metalink find a forum entry with the following suggestions (1 through 5). I tried 1 (increase processes in init.ora) and 4 (disable otrace by deleting .dat files). I don't really want to run MTS so I am discounting option 5 for now. I think the answer lies in 2 (increase Unix kernel parameters).

What can I do? The System Administrator is busy so he gave me the root password and said "have at it."

Received on Tue May 22 2001 - 12:55:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US