Specifying the SPFILE location in the PFILE

To specify the location of the SPFILE in a PFILE, create a PFILE and specify the following entry in the PFILE:

SPFILE = spfile_location

The variable spfile_location represents the complete path of the SPFILE. For example:

SPFILE = /database/startup/spfileora1.ora

In this case, to start the database use the following command:

startup pfile=location_of_pfile