Re: How to force db to use spfile?

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

Peter, See the DBA Administration manual: Managing Initialization Parameters Using a Server Parameter File Oracle has traditionally stored initialization parameters in a text initialization parameter file. Starting with Oracle9i, you can choose to maintain initialization parameters in a binary server parameter file.

This section introduces the server parameter file, and explains how to manage initialization parameters using either method of storing the parameters. The following topics are contained in this section.

  What is a Server Parameter File?
  Migrating to a Server Parameter File
  Creating a Server Parameter File
  The SPFILE Initialization Parameter
  Using ALTER SYSTEM to Change Initialization Parameter Values   Exporting the Server Parameter File
  Errors and Recovery for the Server Parameter File   Viewing Parameters Settings

All this is covered in detail in the manual.

HTH -- Mark D Powell -- Received on Wed Jun 11 2003 - 09:04:21 CDT