Re: How to edit spfile ?/

  • From: Bob <orcl@xxxxxxxxxxx>
  • Date: Wed, 26 Apr 2006 20:42:26 -0400

HI, my approach is, if its a parameter that cant be set dynamically eg ALTER SYSTEM...

create pfile from spfile
make changes to the pfile
startup pfile=/path/to/pfile...
check the parameters are in effect
create spfile from pfile
shutdown ....
the db will now be using the spfile (by default Oracle looks for the spfile first, then pfile)

for kicks you *can* view the spfile which is mainly text, but you should not edit it and expect it to work

The spfile is very useful as parameters can be set dynamically and if your in a Data guard environment oracle writes and rewrites to the spfile, while performing switchover getting extremely verbose at times... pretty neat stuff

advise,,, get used to using the spfile


"Oracle error messages being what they are, do not
highlight the correct cause of fault, but will identify
some other error located close to where the real fault lies."

Dean Paul wrote:

Without creating pfile from spfile how can we edit  spfile ?

Express yourself instantly with MSN Messenger! Download today - it's FREE!



Other related posts: