Re: Oracle Issue Report

"Howard J. Rogers" wrote:

> 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
Because they are paid to teach students?

Seriously ... I added it to the curriculum because someone coming from an 8i or earlier background thinks ALTER SYSTEM is temporary and needs to know what to do when they find themselves in an environment where it isn't.

The thing I dislike most about the SPFILE is that there seems to be no way to know which PFILE was used to generate the SPFILE. And this has caused me to waste more than a few hours. There should be some way to go from the SPFILE back to the PFILE including the PFILE's path.

Daniel Morgan Received on Thu Mar 06 2003 - 10:33:09 CST