Working with the STARTUP Command

When the STARTUP command is given, it is inferred that, if you do not specify, you intend for the instance to be started, the database to be mounted and opened for operation, or STARUP OPEN. The order of operations is as follows:

  1. The command STARTUP is issued.

  2. The instance opens in the NOMOUNT state.

  3. The database is mounted.

  4. The database is opened for access.

The following are a few examples of variations with the STARTUP command:

  • STARTUP Starts up and opens the database inferred by whatever the SID environment variable is set to with the default SPFILE if available or PFILE.

  • STARTUP mydb1 Starts up and opens the mydb1 database with the default SPFILE if available or PFILE.

  • STARTUP OPEN mydb1 In effect, has the same ...

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