Starting an Oracle instance

Last published : Oct 21, 2026
You can start an Oracle instance in the following ways:
  • Using the default SPFILE spfile SID.ora
  • Using the default init.ora file init SID.ora
  • By specifying an initialization file init.ora
  • By specifying an SPFILE in the initialization file init.ora
When you run the startup command without a PFILE clause, Oracle reads the initialization parameters from the SPFILE. On Linux platforms, the default location for the SPFILE or PFILE is $ORACLE_HOME/dbs.
Oracle locates the initialization parameter file by examining file names in the following order:
  • SPFILE SID.ora
  • SPFILE.ora
  • init SID.ora