RE: Oracle on Windows
- From: "Zelli, Brian" <Brian.Zelli@xxxxxxxxxxxxxxx>
- To: <david.best@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 11 Feb 2009 16:44:02 -0500
Yes he was using a spifle so we did as the group suggested and the
change took. Thank you all......
ciao,
Brian
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of dave
Sent: Wednesday, February 11, 2009 2:27 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Oracle on Windows
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
<Brian.Zelli@xxxxxxxxxxxxxxx> wrote:
> 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.
--
//www.freelists.org/webpage/oracle-l
This email message may contain legally privileged and/or confidential
information. If you are not the intended recipient(s), or the employee or
agent responsible for the delivery of this message to the intended
recipient(s), you are hereby notified that any disclosure, copying,
distribution, or use of this email message is prohibited. If you have received
this message in error, please notify the sender immediately by e-mail and
delete this email message from your computer. Thank you.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
