Starting an Oracle instance
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