Re: changing init.ora and spfile

Someone must've been quicker than you :-) It's already there ...

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_2013.htm#i2282157

Cheers

Stefan

Stefan P Knecht
CEO & Founder
s_at_10046.ch

10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland

Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info_at_10046.ch
http://www.10046.ch

On Fri, Jul 31, 2009 at 9:03 PM, Bobak, Mark <Mark.Bobak_at_proquest.com>wrote:

> Hmm…it would be a nice enhancement to be able to do something like:
>
> alter system set db_cache_size = 4G scope=both comment=’Updated by M.Bobak
> as per Change Control Request #78512’;
>
>
>
> And have that comment recorded somewhere in the data dictionary, and
> automatically dumped when you did a ‘create pfile from spfile;’.
>
>
>
> Hmm….how do I file an enhancement request?
>
>
>
> -Mark
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Mayen.Shah_at_lazard.com
> *Sent:* Friday, July 31, 2009 2:39 PM
> *To:* TESTAJ3_at_nationwide.com
> *Cc:* genegurevich_at_discover.com; Joel.Patterson_at_crowley.com;
> oracle-l_at_freelists.org; oracle-l-bounce_at_freelists.org
>
> *Subject:* RE: changing init.ora and spfile
>
>
>
>
> For the same reason, I prefer init.ora over spfile. I can put comments for
> reason for specific parameter value, group similar parameters (e.g. all
> memory related parameter together etc).
> Putting comments also satisfy auditors.
>
> Thanks
> Mayen
>
>
>
>
>
> *TESTAJ3_at_nationwide.com*
> Sent by: oracle-l-bounce_at_freelists.org
>
> Jul 31 2009 02:29 PM
>
> Please respond to
> TESTAJ3_at_nationwide.com
>
> To
>
> Joel.Patterson_at_crowley.com
>
> cc
>
> genegurevich_at_discover.com, oracle-l_at_freelists.org
>
> Subject
>
> RE: changing init.ora and spfile
>
>
>
>
> My only problem with creating pfile from spfile is I lose all of the
> internal documentation, why can't oracle keep all of those # lines in the
> spfile, dooohhh.
>
> joe
>
> _______________________________________
> Joe Testa, Oracle Certified Professional
> (Work) 614-677-1668
> (Cell) 614-312-6715
>
> Interested in helping out your marriage?
> Ask me about "Weekend to Remember"
> Dec 11-13, 2009 here in Columbus.
>
> From:
>
> <Joel.Patterson_at_crowley.com>
>
> To:
>
> <genegurevich_at_discover.com>, <oracle-l_at_freelists.org>
>
> Date:
>
> 07/31/2009 01:19 PM
>
> Subject:
>
> RE: changing init.ora and spfile
>
> Sent by:
>
> oracle-l-bounce_at_freelists.org
>
>
>
>
>
>
>
> You can do that. What I usually do is create a pfile from spfile (don't
> overwrite your changes if you have already edited yours. Then I can
> keep a human readable copy around. So do your renaming or whatever, and
> put in place the new init<>.ora file.
>
> Shutdown
> Create spfile from pfile;
> (sometimes I do the reverse also for same reasons as above, create pfile
> from spfile).
> Startup (it will use the spfile you just created). (Works as a test
> also, redundant or not).
>
>
>
> Joel Patterson
> Database Administrator
> 904 727-2546
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org>] On
> Behalf Of
> genegurevich_at_discover.com
> Sent: Friday, July 31, 2009 1:09 PM
> To: oracle-l_at_freelists.org
> Subject: changing init.ora and spfile
>
> Hello:
>
> I want to make sure that I am making this change correctly. I have a
> 10.2.0.3 DB which users spfile and I need to increase the SGA_MAX and
> SGA_TARGET parameters. My plan is to
>
> - modify the init.ora file
> - make a copy of an existing spfile
> - shut down the database
> - restart as startup using pfile=initXXX.ora
> - when database is started execute create spfile from pfile
>
> That should guarantee that these changes are in the spfile and will not
> be
> lost next time the database is bounced. Am I correct?
>
> thank you
>
> Gene Gurevich
>
>
>
>
> Please consider the environment before printing this email.
>
>
> --*
> *http://www.freelists.org/webpage/oracle-l
>
>
> --*
> *http://www.freelists.org/webpage/oracle-l
>
>
>
>

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