Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Sun Solaris 8 - Listener failed to start a dedicated server p
Jacques,
I am not sure, but are you running out of semaphores? (possible as your default limit may be too low for the 8 databases you serve). Look at /etc/system together with the UIG - add us all the 'processes' in all init.oras - they should be lesser than 'SEMMNS' (Number of semaphores). Changes to /etc/system will need a server restart to become effective.
John Kanagaraj
-----Original Message-----
Sent: Tuesday, May 22, 2001 11:57 AM
To: Multiple recipients of list ORACLE-L
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 *
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."
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: john.kanagaraj_at_hds.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Tue May 22 2001 - 13:57:14 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
![]() |
![]() |