First page Back Continue Last page Graphics
Creating an SPFILE
Created with the CREATE SPFILE command
- Input is text parameter file
- Output is binary SPFILE
Notes:
A server parameter file is created with the CREATE SPFILE command. The input to the CREATE SPFILE command is a text parameter file; thus the need for the text file does not go away. The database must be shutdown to recreate an SPFILE; otherwise a “already used by instance” error is returned.
In the example above (CREATE SPFILE), the default location and name is used for the SPFILE and PFILE. The default is:
$ORACLE_HOME\database\spfile$ORACLE_SID.ora
The default name and location can be overridden by:
CREATE SPFILE = ‘e:\oracle\admin\prod\pfile\spfileprod.ora’
FROM PFILE = ‘e:\oracle\admin\prod\pfile\initprod.ora’;
Note that it is also possible to create a text parameter file from the SPFILE with the CREATE PFILE command.
Supplemental Notes
Parameter file comment-only lines are ignored. Parameter lines with comments on the same line as parameter values are retained in the SPFILE.
The Database Configuration Assistant also supports the creation of the SPFILE.