Re: init.ora file?

hmm .. actually after reading Jonathan's FAQ on spfile, I understand what you mean by "illegal values". That surely is a big disadvantage. Thanks for pointing this out before I started becoming a fan of spfile :) (Just started using it today in development ...)

Anurag

"Anurag Varma" <avdbi_at_hotmail.com> wrote in message news:v5qti6t32sq3aa_at_corp.supernews.com...
> 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:26:52 CST