Re: Non-default spfile location

From: Jerome Vitalis <vitalismanN05P4M_at_gmail.com.invalid>
Date: 12 Oct 2007 12:07:21 GMT
Message-ID: <470f6379$0$8845$79c14f64@nan-newsreader-06.noos.net>

On Thu, 11 Oct 2007 18:33:59 -0700, hjr.pythian wrote:

> On Oct 10, 6:49 am, joel garry <joel-ga..._at_home.com> wrote:

>> On Oct 9, 1:31 am, "astalavista" <nob..._at_nowhere.com> wrote:
>>
>> > hi,
>>
>> > How can I specify a non-default location for a spfile ? I can only do
>> > that through a pfile ... pity am I right or I miss something ?
>>
>> > Why I cannot specify
>> > startup spfile=.... ?
>>
>> > Thanks in advance
>>
>> > 10.2.0.3 on Windows
>>
>> All you need is a single line pfile pointing at the spfile, is that
>> really so hard? 
>> http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/

statem...

>>
>> jg
>> --
>> @home.com is bogus.
>> "I'm the poor man's Alan Greenspan." - Merle Haggard

>
> I think he knows this, which is why he talked about "I can only do that
> through a pfile"
>
> His real question, however, is, "Why I cannot specify startup
> spfile=.... ? "
>
> To which the only rational reply is: why can't Oracle make me a cup of
> tea in the morning?
>
> Ah, OK. That'll be because it's *coded* that way.
>
> In short, the OP has a wishlist item. The reason why wishlist items are
> wishlist items and not product features is because they haven't got that
> far yet...

...

> In fact, I look
> forward to the day the pfile is abolished and the spfile is the only way
> to do it, and "startup", no parameter file arguments allowed, is the
> only way to start your instance.

You have a wishlist item. The reason why wishlist items are wishlist items and not product features is because they haven't got that far yet...

Or perhaps they never will: there are reasons they... etc. ;-)

Thanks for sharing your thoughts though. Received on Fri Oct 12 2007 - 07:07:21 CDT