Starting and Leaving SQL*Plus

Use the following commands to log in to and out of SQL*Plus.

SQLPLUS [[-S[ILENT]] [logon] [start]]|-|-?

where logon requires the following syntax:

username[/password][@net_service_name]|/|/NOLOG

and where start requires the following syntax:

@file_name[.ext] [arg ...]

STARTUP [FORCE][RESTRICT][PFILE=filename][MOUNT[OPEN[RECOVER]] [database]][mount_options]|[NOMOUNT]

where mount_options requires the following syntax:

[EXCLUSIVE|[PARALLEL|SHARED][RETRY]]

Starts an Oracle instance with several options, including mounting and opening a database.

SHUTDOWN [ABORT|IMMEDIATE|NORMAL|TRANSACTIONAL]

Shuts down a currently running Oracle instance, optionally closing and dismounting a database.

{EXIT|QUIT} [SUCCESS|FAILURE|WARNING|n|variable|:BindVariable] [COMMIT|ROLLBACK]

Commits all pending changes, terminates SQL*Plus, and returns control to the operating system.