Re: one Error in Oracle

From: Paul Drake <paled_at_home.com>
Date: Tue, 28 Aug 2001 06:16:59 GMT
Message-ID: <3B8B371A.A9DF681A@home.com>

Sybrand Bakker wrote:
>
> "Leader" <sohelcsc_at_yahoo.com> wrote in message
> news:b1a93c73.0108262137.3bd7658f_at_posting.google.com...
> > hello everybody,
> > i am facing a problem that is
> > ora-00020 MAXIMUM NUMBER OF PROCESSES(50)EXCEEDED.
> > what does it mean?
> > thanks.
>
> It means what it says:
> you have already 50 processes running and you are trying to start up process
> 51.
> Next question:
> How can I resolve this?
> You need to increase the init<sid>.ora parameter processes and bounce the
> database.
>
> Next time please use a more specific subject line
>
> Hth,
>
> Sybrand Bakker, Senior Oracle DBA

As this is likely a parameter suggested by dbca - you might also want to scale up the init.ora parameter "transactions". Then again, if you don't have enough transactions, it will let you know.

Paul Received on Tue Aug 28 2001 - 01:16:59 CDT