Re: How to force db to use spfile?

If your SPFILE uses the default name, i.e. "spfile<ORACLE_SID>.ora", then it will choose this file on instance startup over a pfile, if both exist in the same directory.

HTH,
Brian

Peter wrote:
>
> Suppose you have a spfile in oracle_home\database.
> How do you force Oracle to use this spfile on startup instead of the
> init file (assuming you have another init file in \<SID>\pfile)?
> Using a SPFILE= line to redirect from the init file is not the same as
> having Oracle using the spfile directly?
>
> Thanks

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"