RE: Oracle on Windows

From: M Rafiq <rafiq9857_at_hotmail.com>
Date: Wed, 11 Feb 2009 15:29:19 -0500
Message-ID: <BAY107-W4598DF5804BBF19CF9030DA1BA0_at_phx.gbl>

Then it may be pointing to some other initSID.orta file. Just login to database througn sqlplus and check for show parameter spfile.  

If output is blank then there is no spfile. Alternately you can check it from registry.  

SQL> show parameter spfile

NAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------spfile                               string      ?/dbs/spfile_at_.ora> Subject: RE: Oracle on Windows> Date: Wed, 11 Feb 2009 14:43:23 -0500> From: Brian.Zelli_at_RoswellPark.org> To: david.best_at_gmail.com; oracle-l_at_freelists.org> > No spfile that I know of. In looking at the startup script, it just has> startup pfile=c:\yadayadayada\init.ora > > ciao,> Brian > > -----Original Message-----> From: oracle-l-bounce@freelists.org> [mailto:oracle-l-bounce@freelists.org] On Behalf Of dave> Sent: Wednesday, February 11, 2009 2:27 PM> To: oracle-l@freelists.org> 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_at_roswellpark.org> 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.> --> http://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.> --> http://www.freelists.org/webpage/oracle-l> > 
_________________________________________________________________

Windows Live™: Keep your life in sync.
http://windowslive.com/howitworks?ocid=TXT_TAGLM_WL_t1_allup_howitworks_022009

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 11 2009 - 14:29:19 CST