From Rajesh@ohitelecom.com Sun, 18 Nov 2001 22:54:14 -0800 From: Rajesh Dayal Date: Sun, 18 Nov 2001 22:54:14 -0800 Subject: RE: listener failed to start a dedicated server process Message-ID: MIME-Version: 1.0 Content-Type: text/plain Hi, check following issues as well, If you are referring ORACLE_HOME in your tnsnames.ora Value of parameter "PROCESSES" is too low. HTH, Rajesh -----Original Message----- Kurth Sent: Sunday, November 18, 2001 7:30 PM To: Multiple recipients of list ORACLE-L Assuming you are unix... If you are on 7.3.4 it may be caused by not disabling Oracle trace. Otherwise you have probably exceeded a unix limit, like maxuprc. AM PST Please respond to ORACLE-L@fatcity.com Sent by: root@fatcity.com To: "Multiple recipients of list ORACLE-L" cc: Hi, When I tried to start one more session of oracle SQLPLUS I got this error: ERROR: ORA-12500: TNS:listener failed to start a dedicated server process But the other session which was already open is working properly.Could you please tell me what could be the problem and how to make this not occur again? Thanks, E. __________________________________________________ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ehsan sinavalda INET: ehsanoracle@yahoo.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@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike J Kurth INET: Mike.J.Kurth@aexp.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@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: Rajesh@ohitelecom.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@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).