Re: General Question - Initialization Parameters

On 9 jan, 16:01, "richard.drouill..._at_gmail.com" <richard.drouill..._at_gmail.com> wrote:
> Good Day All,
>
> I'm slowly making my way through the Oracle Database 10g Server manual
> and have a quick question.
>
> I know that Oracle Database Server uses a spfile to get the
> initialization parameters required for startup. I also know that
> there is an initialization parameter called SPFILE which contains the
> name of spfile being used by the instance.
>
> Question: It doesn't seem possible to me that the SPFILE parameter be
> stored in the spfile since it lists the name of a file to use for
> startup in the startup file.
>
> Or as an analogy: You can pick up the directions to my house at my
> place.
>
> If I am interpreting this correctly, wouldn't that mean that this
> parameter has to be stored in some other file?
>
> Richard Drouillard

The $Oracle_home and $Oracle_sid give the place to search for the parameters. I think the sequence for searching parameters is:

1. parameterfile as defined during startup option
2. spfile<sid>.ora,
3. spfile.ora,
4. init<sid>.ora