To specify the location of the SPFILE in a PFILE, create a PFILE and specify the following entry in the PFILE:
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: