Oracle Tips by Burleson

Oracle10g Grid Computing with RAC
Chapter 8 - RAC Administration

Creating Server Parameter File

CREATE SPFILE FROM PFILE='/u01/oracle/product/920/dbs/initRAC1.ora';

Below is another example that illustrates creating a server parameter file and supplying a name:

CREATE SPFILE='/u01/oracle/product/920/dbs/racdb_spfile.ora
FROM PFILE='/u01/oracle/product/920/dbs/init.ora';

Exporting the Server Parameter File

We can export the server parameter file to create a traditional text initialization parameter file.  This would be useful for:

§         Creating backups of the server parameter file.

§         For diagnostic purposes to list all of the parameter values currently used by an instance.

§         Modifying the server parameter file by first exporting it, editing the output file, and then recreating it.

The following example creates a text initialization parameter file from the server parameter file, since no paths are specified the files will be located in $ORACLE_HOME/database or its equivalent on your system: