Re: Oracle on Windows
Date: Wed, 11 Feb 2009 14:27:26 -0500
Maybe your using an spfile? Login via sqlplus and type
SQL> show parameter spfile
If it shows a value then your using spfiles. So to change the number of processes you'll need to:
alter system set processes = 100 scope=spfile;
Then bounce your instance.
On Wed, Feb 11, 2009 at 2:21 PM, Zelli, Brian
> We have an 3 instances of 10g on a windows server. I needed to change the
> number of processes. So I edited the init file, changed the processes, saved
> it and then bounced the instance. When I do a v$parameter on processes, I
> still get the old number. What the heck is wrong? Do I have to stop the
> service at all? Restart it before I bring up the database? I did set the
> sid for that instance before I logged in.