Oracle SQL*Plus: The Definitive Guide, 2nd Edition

Name

STARTUP

Synopsis

The STARTUP command starts an Oracle instance and opens a database. Chapter 10 discusses this command. To use STARTUP, you must be connected as SYSDBA, SYSOPER, or INTERNAL.

Syntax

STARTUP {options | upgrade_options}
options ::= [FORCE] [RESTRICT]
              [PFILE=parameter_filename]
              [QUIET] [mount]

 mount ::= { MOUNT [database_name]
          | OPEN [open_options]
          | NOMOUNT}

open_options ::= {READ {ONLY | WRITE [RECOVER]}
                 | RECOVER}

upgrade_options ::= [PFILE=parameter_filename]
                    {UPGRADE | DOWNGRADE}
                    [QUIET]

Parameters

FORCE

Forces the instance to start. If the instance is currently running, then FORCE will cause the equivalent of a SHUTDOWN ABORT to be done first; then the instance will be restarted.

RESTRICT

Opens the database in restricted session mode. Only users with the RESTRICTED SESSION system privilege will be allowed to connect.

PFILE=parameter_filename

Tells SQL*Plus to use the specified parameter file (initialization file) when starting the instance. You may specify a path with the filename.

Tip

SQL*Plus, not the Oracle instance, reads the parameter file. The path to the parameter file must be relative to the machine running SQL*Plus. This matters, for example, if you are using SQL*Plus on a PC and connecting remotely to an instance on a server to start it.

QUIET

Prevents SQL*Plus from displaying details about the allocation of memory for the instance's SGA.

MOUNT [database_name]

Causes the database to be mounted but not opened. The instance will be started, and the control file ...