Re: How to force db to use spfile?

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 11 Jun 2003 09:44:58 -0700
Message-ID: <92eeeff0.0306110844.576a8382@posting.google.com>

Peter <peter_at_nomorenewsspammin.ca> wrote in message news:<gr3kbv84qsekkkbidi30tmnvlbpeptf447_at_4ax.com>...
> 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

Just use startup command without any qualifiers like startup pfile=???. There is no such thing as startup spfile=???. Oracle will use spfile first if it has been created in ORACLE_HOME\database or ORACLE_HOME/dbs respectively for Windows and Unix.

Ofcourse... this is all documented extensively in Oracle 9i docs + answered many times here.

Regards
/Rauf Sarwar Received on Wed Jun 11 2003 - 11:44:58 CDT