Introduction to Oracle9i Server Parameter Files (SPFILE)（Jeff Hunter, January 20, 2006）

Introduction to Oracle9i Server Parameter Files (SPFILE)
by Jeff Hunter, Sr. Database Administrator
Contents
Overview
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
Reference Note for Init.Ora Parameter "SPFILE".
TroubleshootingHow to check if an instance was started using a PFILE or an SPFILE
ORA-32001: write to SPFILE requested but no SPFILE specified at startup
How to manipulate SPFILE's using the EM Console
Which Current Parameter File is Used to Start 9i Instance
ORA-03113: End-of-File on Communication Channel at STARTUP After Creating SPFILE
CREATE PFILE Command Results in ORA-02236 Error
What Happens and What to Do when the SPFILE has been Manually Modified?
Same Parameters Appear in the Init.ora and in the Embedded spfile.ora
How to change static parameters through SPFILE parameter file
SCOPE Clause Description
SCOPE = SPFILE The change is applied in the server parameter file only. The effect is as follows:
For dynamic parameters, the change is effective at the next startup and is persistent.
For static parameters, the behavior is the same as for dynamic parameters. This is the only SCOPE specification allowed for static parameters.
SCOPE = MEMORY The change is applied in memory only. The effect is as follows:
For dynamic parameters, the effect is immediate, but it is not persistent because the server parameter file is not updated.
For static parameters, this specification is not allowed.
SCOPE = BOTH The change is applied in both the server parameter file and memory. The effect is as follows:
For dynamic parameters, the effect is immediate and persistent.
For static parameters, this specification is not allowed.
Method Description
SHOW PARAMETERS This SQL*Plus command displays the currently in use parameter values.
CREATE PFILE This SQL statement creates a text initialization parameter file from the binary server parameter file.
V$PARAMETER This view displays the currently in effect parameter values.
V$PARAMETER2 This view displays the currently in effect parameter values. It is easier to distinguish list parameter values in this view because each list parameter value appears as a row.
V$SPPARAMETER This view displays the current contents of the server parameter file. The view returns NULL values if a server parameter file is not being used by the instance.
Parameter type String
Syntax SPFILE = spfile_name
Default Value $ORACLE_HOME/dbs/spfile.ora
Parameter Class Static (auto-resource)
Range of Values Any valid SPFILE
Oracle9i Real Application Clusters Multiple instances should have the same value
http://www.idevelopment.infois the copyright of Jeffrey M. Hunter and is protected under copyrightlaws of the United States. This document may not be hosted on any othersite without my express, prior, written permission. Application to hostany of the material elsewhere can be made by contacting me atjhunter@idevelopment.info.
I have made every effort and takengreat care in making sure that the material included on my web site istechnically accurate, but I disclaim any and all responsibility for anyloss, damage or destruction of data or any other property which mayarise from relying on it. I will in no case be liable for any monetarydamages arising from such loss, damage or destruction.
Last modified on
Friday, 20-Jan-2006 16:42:48 EST