Starting an Oracle Database Instance

Learn how to start an instance without mounting a database.

Start an instance without mounting a database.

SQL> STARTUP NOMOUNT

You must not specify the PFILE clause in this example, because the initialization parameter file is stored in the default ___location. At this point, there is no database. Only the System Global Area (SGA) is created and the background processes are started in preparation for the creation of a new database.