RE: listener failed to start a dedicated server process

From: Rajesh Dayal <Rajesh_at_ohitelecom.com>
Date: Sun, 18 Nov 2001 22:54:14 -0800
Message-ID: <F001.003C82DA.20011118223018@fatcity.com>

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_at_fatcity.com

Sent by: root_at_fatcity.com

To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> 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_at_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_at_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_at_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_at_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_at_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_at_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). Received on Mon Nov 19 2001 - 00:54:14 CST