Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

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; the instance will then be restarted.

RESTRICT

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

PFILE =_filename

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

Note

SQL*Plus reads the parameter file, not the Oracle instance, so the path to the parameter file must be relative to the machine running SQL*Plus.

MIGRATE

Starts the database in OPEN MIGRATE mode with intialization parameters set to allow upgrade or downgrade scripts to be run. Use this option only with a new version of the server.

QUIET

Starts the instance without displaying information about memory allocation within the System Global Area.

MOUNT [ dbname ]

Causes the database to be mounted but not opened.

[ dbname ]

Optionally specifies a database name to override the DB_NAME initialization parameter.

OPEN [ open_options ] [ dbname ]

Causes the database to be mounted and then opened for normal operation.

NOMOUNT

Starts the instance without mounting the database.

READ (ONLY | WRITE [RECOVER])

Use READ ONLY to open the database so that it can be read from, but not written to. Use READ WRITE to explicitly specify the default behavior.

RECOVER

Tells Oracle to perform media recovery, if necessary, before ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page