Re: General Question - Initialization Parameters

From: Arun Mathur <>
Date: Wed, 9 Jan 2008 07:19:36 -0800 (PST)
Message-ID: <>

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

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

Original text of this message