RE: TNS error12500

Number of process in init ora file = one hundred. Thanks;
Majid Kazemi
Database Architecture Development &Support TERANET LAND INFORMATION SERVICES
655 Bay Street, 5th Floor, Minto Plaza
Toronto, Ontario M5G 2K4
Phone: (416) 326-1322 Ext:4268
Email: mkazemi_at_teranet.on.ca <mailto:mkazemi_at_teranet.on.ca>

Copyright * 2000 Teranet Land Information Services Inc. All rights reserved. No part of this publication may be reproduced, stored in a retrieval system or transmitted, in any form or by any means, electronic, mechanical, photocopying or otherwise, without the express written permission of Teranet Land Information Services Inc

	-----Original Message-----
	From:	Majid Kazemi 
	Sent:	Wednesday, December 13, 2000 11:46 AM
	To:	Ashish Shah; Oracle Guru; Oracle_dba; lazydba
	Subject:	RE: TNS error12500

	Ashish-Thanks for response. I also thought so. The number of process
in init
	ora file is set =100, while the number of connection to database
including
	background process at that time were only 10.
	Thanks;
	Majid Kazemi



		-----Original Message-----
		From:	Ashish Shah [SMTP:ar_shah_at_yahoo.com]
		Sent:	Wednesday, December 13, 2000 11:27 AM
		To:	Majid Kazemi; Oracle Guru; Oracle_dba; lazydba
		Subject:	Re: TNS error12500

		check init.ora parameter processes.
		you can only make so may connections as you specified
		in process parameter.

		most likely you run out of processes.

		Ashish
		--- Majid Kazemi <Mkazemi_at_teranet.on.ca> wrote:


		> Hi again:

		> I have an Oracle 7.3.4 on NT 4.0. It is very stable

		> environment. Last time

		> while an application tried to connect to database,

		> the following error has

		> been displayed: 

		> ORA-12500: TNS:listener failed to start a dedicated

		> server process.  

		> After I killed a session,  everything worked fine

		> again. Is there any

		> limitation on the number of dedicated process in

		> Oracle? Any help will be

		> great.

		> 

		> Thanks;

		> Majid Kazemi

		> 

		> --------

		> Think you know someone who can answer the above

		> question? Forward it to them!

		> to unsubscribe, send a blank email to

		> oracledba-unsubscribe_at_LAZYDBA.com

		> to subscribe send a blank email to

		> oracledba-subscribe_at_LAZYDBA.com 

		> Visit the list archive:

		> http://www.LAZYDBA.com/odbareadmail.pl

		> 



		=====
		Ashish
		Toronto, Canada

		__________________________________________________
		Do You Yahoo!?
		Yahoo! Shopping - Thousands of Stores. Millions of Products.
		http://shopping.yahoo.com/

	--------
	Think you know someone who can answer the above question? Forward it
to them!
	to unsubscribe, send a blank email to
oracledba-unsubscribe_at_LAZYDBA.com
	to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com