Re: Oracle Issue Report

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Thu, 06 Mar 2003 21:53:14 +1100
Message-ID: <pan.2003.03.06.10.53.12.914777@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 - 04:53:14 CST