Re: changing init.ora and spfile
- From: Stefan Knecht <knecht.stefan@xxxxxxxxx>
- To: Mark.Bobak@xxxxxxxxxxxx
- Date: Fri, 31 Jul 2009 22:45:33 +0200
Hey Mark
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@xxxxxxxx
10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland
Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info@xxxxxxxx
http://www.10046.ch
=========================
On Fri, Jul 31, 2009 at 9:03 PM, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxx>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@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Mayen.Shah@xxxxxxxxxx
> *Sent:* Friday, July 31, 2009 2:39 PM
> *To:* TESTAJ3@xxxxxxxxxxxxxx
> *Cc:* genegurevich@xxxxxxxxxxxx; Joel.Patterson@xxxxxxxxxxx;
> oracle-l@xxxxxxxxxxxxx; oracle-l-bounce@xxxxxxxxxxxxx
>
> *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@xxxxxxxxxxxxxx*
> Sent by: oracle-l-bounce@xxxxxxxxxxxxx
>
> Jul 31 2009 02:29 PM
>
> Please respond to
> TESTAJ3@xxxxxxxxxxxxxx
>
> To
>
> Joel.Patterson@xxxxxxxxxxx
>
> cc
>
> genegurevich@xxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
>
> 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@xxxxxxxxxxx>
>
> To:
>
> <genegurevich@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
>
> Date:
>
> 07/31/2009 01:19 PM
>
> Subject:
>
> RE: changing init.ora and spfile
>
> Sent by:
>
> oracle-l-bounce@xxxxxxxxxxxxx
>
>
>
>
>
>
>
> 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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx>] On
> Behalf Of
> genegurevich@xxxxxxxxxxxx
> Sent: Friday, July 31, 2009 1:09 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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.
>
>
> --*
> *//www.freelists.org/webpage/oracle-l
>
>
> --*
> *//www.freelists.org/webpage/oracle-l
>
>
>
>
Other related posts:
