Re: General Question - Initialization Parameters

On Jan 9, 10:01 am, "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

Hi Richard,

Place your spfile in the location recommended in Table 2-5 from the following Oracle 10g documentation link, as well as use the naming convention provided:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/create.htm#CIAJEBBI

Good luck,
Arun Received on Wed Jan 09 2008 - 09:19:36 CST