RE: changing init.ora and spfile
Date: Fri, 31 Jul 2009 13:18:12 -0400
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.
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).
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of genegurevich_at_discover.com
Sent: Friday, July 31, 2009 1:09 PM
Subject: changing init.ora and spfile
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
lost next time the database is bounced. Am I correct?
Please consider the environment before printing this email.Received on Fri Jul 31 2009 - 12:18:12 CDT