| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to make SPFILE in sync with INIT.ORA ?
I don't appreciate spfile's much either, except in some cases of test
instances, wheres quite easy to type alter system command followed by
startup force to test effects of some parameters... But it all can be done
old fashioned way as well.
In RAC env I still use normal old-fashioned pfile (where settings for all instances are located) and a small script which is able to copy the init.ora to all instances appropriate directories. Btw, in production environment one shouldn't continuously (manually) modify init.ora parameters anyway, especially in 9i, where even SGA sizing parameters are dynamic..
Tanel.
> And how, exactly?
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, July 15, 2003 7:29 PM
>
>
> > You'll appreciate spfiles if you're using RAC.
> >
> > -----Original Message-----
> > Sent: Tuesday, July 15, 2003 2:09 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > And create pfile from spfile; does a similar job.
> >
> > I'm rapidly beginning to think that spfiles are just not worth it. Now
howtoreversethepolicydecisionhavingmandatedthemfor9iinstallsNiall-----Origin
alMessage-----Fromml-errors_at_fatcity.zl6[mailtoml-errors_at_fatcity.com]OnBehalf
OfArupNandaSent15July20030444ToMultiplerecipientsof list ORACLE-L
> > > Subject: Re: How to make SPFILE in sync with INIT.ORA ?
> > >
> > >
> > > As user sys, issue
> > >
> > > CREATE SPFILE FROM PFILE;
> > >
> > > This will create the spfile. You must have started the
> > > database using the pfile to use this command.
> > >
> > > HTH.
> > >
> > > Arup Nanda
> > > ----- Original Message -----
> > > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > > Sent: Monday, July 14, 2003 10:59 PM
> > >
> > >
> > > > Guys,
> > > >
> > > > i have a 9iR2/win2k test instance.
> > > > i just renamed CONTROL01.CTL once and tried to start the instance.
> > > >
> > > > SQL>startup
> > > > But it gave a ORA-00205 error.
> > > >
> > > > so i removed CONTROL01.CTL from INIT.ORA file and started the
> > > > instance
> > > > SQL>startup pfile='d:\oracle\admin\pe92\pfile\init.ora'
> > > > Now it worked fine.
> > > >
> > > > BUT:
> > > > SQL>startup
> > > > This is not possible because the SPFILE still has
> > > CONTROL01.CTL in it.
> > > >
> > > > How do i make my SPFILE in sync with the INIT.ORA ?
> > > >
> > > > Regards,
> > > > Jp.
> > > >
> > > >
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > > --
> > > > Author: Prem Khanna J
> > > > INET: jprem_at_kssnet.co.jp
> > > >
> > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > > > San Diego, California -- Mailing list and web
> > > hosting services
> > > >
> > > ---------------------------------------------------------------------
> > > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > > the message BODY, include a line containing: UNSUB ORACLE-L (or the
> > > > name of mailing list you want to be removed from). You may
> > > also send
> > > > the HELP command for other information (like subscribing).
> > > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Arup Nanda
> > > INET: orarup_at_hotmail.com
> > >
> > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > > San Diego, California -- Mailing list and web hosting services
> > > ---------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> > > and in the message BODY, include a line containing: UNSUB
> > > ORACLE-L (or the name of mailing list you want to be removed
> > > from). You may also send the HELP command for other
> > > information (like subscribing).
> > >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Niall Litchfield
> > INET: niall.litchfield_at_dial.pipex.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Molina, Gerardo
> > INET: Gerardo.Molina_at_schwab.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Arup Nanda
> INET: orarup_at_hotmail.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
Received on Tue Jul 15 2003 - 18:05:18 CDT
 |
 |