Re: Oracle Issue Report

On Thu, 06 Mar 2003 08:33:09 +0000, DA Morgan wrote:

> "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

;-) I know what you mean!

>
> 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.

Agreed. That's another beef I have with it. Alter system has meant the same thing for ages: "Lifetime of the instance only". Suddenly, it doesn'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.

Good idea, actually. I'd also like the create spfile command to delete the source init.ora. I've spent a good 40 minutes editing an init.ora, to no effect (and posts here indicate I'm not the only one) because an spfile is in place.

Regards
HJR
>
> Daniel Morgan
Received on Thu Mar 06 2003 - 13:13:31 CST