Oracle versions earlier than Oracle9i used an initialization file initSID.ora, a text file, to start database instances. Changes that were applied to instance parameters during a database session were not saved to the file. You had to manually apply them to the initialization file.
When using the Cluster Server agent for Oracle, you can start a database instance by specifying a PFILE. If you do not specify the PFILE, the database instance starts up using the default SPFILE.
The agent attribute Pfile must specify the location of the PFILE. If your configuration uses the SPFILE, the contents of the PFILE must specify the location of the SPFILE, which must be created from the PFILE.
To create the SPFILE from a PFILE
You can run the following command to create the SPFILE:
CREATE SPFILE [= spfile_name] FROM PFILE [= pfile_name ];
If you do not specify the complete path for the SPFILE, this command creates an SPFILE at the default location ($ORACLE_HOME/dbs on AIX).
To specify the SPFILE location 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: