| STARTUP |
STARTUP [FORCE] [RESTRICT]
[PFILE=filename]
{MOUNT | OPEN [database_name] | NOMOUNT}
[EXCLUSIVE | {PARALLEL | SHARED} [RETRY]]
|
Starts an Oracle instance. This command is intended for DBAs.
Keywords
FORCE
Specifies that the instance is to be forced to start. If the instance is already running, this keyword forces a SHUTDOWN ABORT, followed by the specified STARTUP.
RESTRICT
Specifies that the database is to be opened in restricted mode, which allows only users with the RESTRICTED SESSION privilege to connect.
PFILE
Specifies that the instance should be started using parameters contained in the file provided by pfilename. This file must be available on the machine running SQL*Plus.
MOUNT
Specifies that the instance is to be started and the database is to be mounted, but not opened.
OPEN
Specifies that the instance is to be started and the database is to be mounted and opened. This option is the default.
database_name
Specifies the name of the database and overrides the value of the parameter DB_NAME in the initialization file.
NOMOUNT
Specifies that the instance is to be started, but the database is not to be mounted or opened.
EXCLUSIVE
Specifies that the database is to be mounted and/or opened only by this instance, and cannot be shared by any other instance.
PARALLEL
Specifies that the database is to be mounted and/or opened so other instances can access it simultaneously. This keyword is a synonym for SHARED.
SHARED
Specifies that the database is to be mounted and/or ...
Get Oracle SQL: the Essential Reference 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.
