RE: changing init.ora and spfile

From: <Mayen.Shah_at_lazard.com>
Date: Fri, 31 Jul 2009 14:39:28 -0400
Message-ID: <OF58F2A0F7.8AA4B192-ON85257604.00662F2B-85257604.00667D6C_at_lazard.com>



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] 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
Received on Fri Jul 31 2009 - 13:39:28 CDT

Original text of this message