Re: init.ora file?

Howard,

What do you mean by "teadious business of exporting it to an init.ora, editing the init.ora ..."?

exporting is just issuing 'create pfile from spfile'. re-exporting is 'create spfile from pfile' Illegal values (if I understand what you mean by this) can come up in init.ora also .. which would need to be fixed also.

Agreed that there is no major advantage in using spfile. I don't know if I agree with your disadvantage, after all I'd consider it a rare instance that an illegal value gets in there.

Anurag

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:pan.2003.02.26.19.32.12.884099_at_yahoo.com.au...
> On Wed, 26 Feb 2003 13:37:05 +0000, Patrice Castet wrote:
>
> > on 9i you should use a binary file,
>
> No you shouldn't. On 9i, you should strive as hard as possible to *avoid*
> using the spfile. It is a royal pain in the butt to work with, and gives
> you precisely no advantages over the good old init.ora -but also gives you
> plenty of disadvantages (such as not being editable, meaning that any
> illegal values that get in there (which it doesn't trap for) can only be
> gotten out of there by the tedious business of exporting it to an
> init.ora, editing the init.ora, and re-exporting back to an spfile).
>
> It was principally designed for use in a RAC environment, where having one
> file to maintain instead of 2, 4, 8, 32 or whatever is indeed a very big
> advantage. Except that you can also use a single boring old init.ora in a RAC
> environment, with the "Dot Notation", do do precisely the same job, so
> even in a RAC there's no need for the spfile.
>
> To our original poster, I'd simply suggest issuing the command 'create
> pfile from spfile', and Lo! You will have an init.ora back again in the
> default location. Delete the spfile afterwards (because that gets used in
> preference to an init.ora), and save yourself a lot of grief.
>
> Regards
> HJR
>
>
> >not editable any longer and
> > dynamically modifiable without (usually ...) restarting the db. It is
> > the "spfile".
> > the init.ora should be used only if you need specific startups not
> > included in the normal spfile, or if you migrate from a 8i db.
> > init.oras can be generated easily with the admin console in "all
> > parameters" section of your instance.
> >
> >
> > On Wed, 26 Feb 2003 13:18:28 +0200, "James" <james_at_nothing.com> wrote:
> >
> >>Hi there
> >>I'm using Oracle 9 on a windows 2k machine.
> >>I can't find the init.ora file!
> >>I can find the init.ora.21200311 file in the f:\oracle\admin\seconddb\pfile
> >>directory. Is this the file that is termed init.ora? If so how does the last
> >>part of the name get made? (the 21200311?)
> >>
> >>Secondly I also have a SPFILESECONDDB.ora file in the
> >>f:\oracle\ora92\database directory
> >>
> >>Hope someone can help
> >>Thanks in Advance
> >>Cheers
> >>James
> >>
> >>
>
Received on Wed Feb 26 2003 - 20:21:49 CST