Re: "processes" initialization parameter

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 26 Mar 2002 23:23:25 +0100
Message-ID: <ua1tabchcn9o5a@corp.supernews.com>

"Kevin S. Smith" <SpamNoMore_at_EriePlating.com> wrote in message news:ua1no28268krba_at_corp.supernews.com...
> I am installing Enterprise Manager for Oracle 8i. When creating the
> management server, I am getting an error stating that it won't be
supported
> becuase my "processes" init param is set to 150 and the minimum is 200.
(if
> you could explain why it needs to be that high, that would be great too.)
> Anyway, I change the init param, but don't want to wait until the time is
> right (which is no time soon) to bounce the database. Is there a way to
> change this dynamically. Any suggestions would be great.
>
>

The processes parameter is a static parameter, which can be verified from the is_sysmodifiable and is_sesmodifiable columns in the v$parameter view (where name = 'processes')

No other solution than to bounce the instance, I am afraid.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Tue Mar 26 2002 - 16:23:25 CST