Re: Oracle Issue Report

Yeah, why the heck should one modify a configuration file with ALTER SYSTEM commands?!

Since it's possible to use the *. notation in regular parameter files, it's easy to modify only one text file and distribute it to appropriate locations using a very simple script.

Tanel.

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:pan.2003.03.06.10.53.12.914777_at_yahoo.com.au...
> On Wed, 05 Mar 2003 19:09:54 +0000, DA Morgan wrote:
>
> > Pete Sharman wrote:
> >
> >> In article <3E668F05.7C6CFF57_at_exesolutions.com>, DA says...
> >> >
> >> snip
> >> >
> >> >What is critical and has not apparently been previously documented is
> >> >that when using oradim with 9i
> >> >to recreate Windows services ... when it asks for pfile it means the
> >> >initSID.ora ... not the spfile.ora.
> >> >
> >> >Thought some of you might want to know in case you ever need it.
> >> >
> >> >Daniel Morgan
> >> >
> >> >
> >> Whenever it asks for pfile it means initSID.ora. If you want to that
> >> PFILE could simply be the line SPFILE=your_path_and_filename_goes_here
> >> (IIRC; maybe it's an IFILE line instead?). If you leave out the PFILE
> >> altogether, I would have expected it to pick up the default SPFILE. I
> >> don't have 9.2 to test it on, though, so maybe I'm talking through my
> >> hat as usual! :)
> >>
> >> HTH. Additions and corrections welcome.
> >>
> >> Pete
> >>
> >> SELECT standard_disclaimer, witty_remark FROM company_requirements;
> >
> > It didn't work until I specified the initSID.ora.
> >
> > What is interesting, and confirmed by Oracle support staff, is that in
> > almost every document it say something like "use the spfile not the
> > pfile". This is an exception. Pfile truly means the pfile.
>
> Personally, I think anyone who is using the spfile when they haven't got a
> 32-node RAC to manage wants their head examined. I wouldn't touch it with
> a barge pole, and this just confirms it.
>
> Regards
> HJR
>
>
>
>
Received on Thu Mar 06 2003 - 07:19:45 CST