First page Back Continue Last page Graphics
Using SPFILE…
STARTUP command with no parameters
Uses 1st file found in search sequence: $ORACLE_HOME\database:
- Checks for spfile$ORACLE_SID.ora
- Checks for spfile.ora
- Checks for a text file called init$ORACLE_SID.ora
The first file found is used
Notes:
The server parameter file is read at instance startup (specifically, when the instance is mounted).
If the PFILE parameter is not supplied on STARTUP, Oracle goes through a series of checks in the following order to locate the initialization parameters it will use:
Checks for a file called:
$ORACLE_HOME\database\spfile$ORACLE_SID.ora
If found, then Oracle uses this file. If not found, perform the following check.
Checks for a file called $ORACLE_HOME\database\spfile.ora
If found, then Oracle uses this file. If not found, perform the following check.
Checks for a file called:
$ORACLE_HOME\database\pfile\init$ORACLE_SID.ora
If found, then Oracle uses this file. If not found, Oracle generates an error.