Oracle Server Parameter File (SPFILE)
The Oracle Server Parameter File (SPFILE) is a new feature available as of Oracle Release 9i. This note describes how to use the SPFILE rather than the Oracle parameter file init<SID>.ora (short: init.ora).
The following designations are used in this note:
- <SID> is the <ORACLE_SID> which is the unique indicator of an Oracle database instance. This is not to be confused with the <SAPSID>, the SAP system ID (unique indicator of an SAP system).
- init.ora is used as a synonym for the known Oracle parameter file init<SID>.ora.
- SPFILE is the short form for Server Parameter File.
Oracle profile file, init<SID>.ora and init.ora (short form) are synonyms for the known Oracle parameter file. Reason and Prerequisites
SPFILE (short form), server-side parameter file, and sometimes also persistent parameter file are used as synonyms for the server parameter file spfile<SID>.ora.
Documentation and migration note for Oracle9i: SPFILE
https://service.sap.com/sap/support/notes/601157 (SAP Service marketplace login required)