RE: changing init.ora and spfile
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "Mayen.Shah@xxxxxxxxxx" <Mayen.Shah@xxxxxxxxxx>, "TESTAJ3@xxxxxxxxxxxxxx" <TESTAJ3@xxxxxxxxxxxxxx>
- Date: Fri, 31 Jul 2009 15:03:00 -0400
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] 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:
