Database Startup

When starting the database, you have control over the state in which it ultimately starts. There are several different ways to start the database (MOUNT, NOMOUNT, OPEN, RESTRICT), and these are covered in this section.

STARTUP NOMOUNT

The STARTUP NOMOUNT command starts up the instance but does not mount or open the database. This usually is reserved for times when you are creating a database or need to re-create the control files.

When Oracle starts the instance, it reads the initialization file from the default location, unless otherwise specified. It looks for these files in the following order:

  1. spfileSID.ora

  2. spfile.ora

  3. initSID.ora

You can override this default behavior by specifying:

 STARTUP NOMOUNT pfile=<path_to_pfile>/mypfilename.ora ...

Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial