RE: changing init.ora and spfile
Date: Fri, 31 Jul 2009 13:18:12 -0400
Message-ID: <0684DA55864E404F8AD2E2EBDFD557DA031C4592_at_JAXMSG01.crowley.com>
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] 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-lReceived on Fri Jul 31 2009 - 12:18:12 CDT