Search notes:

Oracle: Server parameter file

The server parameter file stores the values of the init parameters in a binary format.

The server parameter file is also referred to as SPFILE.

Creating an SPFILE

create spfile                            from pfile='/u01/app/oracle/product/nn.n.n/dbhome_1/initORACLE_SID.ora';
create spfile '/u01/oracle/dbs/init.ora' from pfile='/u01/app/oracle/product/nn.n.n/dbhome_1/initORACLE_SID.ora';
create spfile                            from memory;

The scope clause in ALTER SYSTEM SET … statements

alter system set <init_param> = 'value' scope=spfile;
alter system set <init_param> = 'value' scope=memory;
alter system set <init_param> = 'value' scope=both;

Resetting an SPFILE

alter system reset scope=spfile;

A parameter with the default value cannot be reset again (ORA-32010: cannot find entry to delete in SPFILE).

Export an SPFILE

create pfile from spfile;

Oracle: Server parameter file

Creating an SPFILE

The scope clause in ALTER SYSTEM SET … statements

Resetting an SPFILE

Export an SPFILE

See also