RE: TNS error12500

Majid:

Wich is the application ? Because I had same problem in a PeopleSoft a= pp.
;
check the logs in the application . I remember that I set process=3D30= 0 ,
but
Vantive repeated the problem two times. Seems like cannot count the re= al
number
 of connections , and fail ( showing ORA-12500 ). I didn=B4t do any ch= ange,
and
the problem dissapear ... I think that somethig in the network affected..., because
was fix without help , and happend in the same day . Good luck

Majid Kazemi <Mkazemi_at_teranet.on.ca>@fatcity.com con fecha 13/12/2000 13:47:10

Por favor, responda a ORACLE-L_at_fatcity.com

Enviado por: root_at_fatcity.com

Destinatarios: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.c= om>
CC:
Asunto: RE: TNS error12500

Ashish-Thanks for response. I also thought so. The number of process in=

init
ora file is set =3D100, while the number of connection to database incl= uding
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

     >



     =3D=3D=3D=3D=3D
     Ashish
     Toronto, Canada

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

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Majid Kazemi
  INET: Mkazemi_at_teranet.on.ca

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