Shutting Down and Starting Up Using SQL*Plus

You can shut down and start the Oracle instance using SQL*Plus.

To shut down and start the Oracle instance using SQL*Plus:

  1. Start SQL*Plus and connect to the database.

    See "Shutting Down and Starting Up Using SQL*Plus".

  2. Issue the SQL*Plus SHUTDOWN command:

    SQL> SHUTDOWN

    The database instance is shut down.

    The NORMAL clause of the SHUTDOWN command is optional because this is the default shutdown method.

    See "About Instance Shutdown" for more information about when to use other SHUTDOWN command options.

  3. Restart the database by issuing the SQL*Plus STARTUP command:

    SQL> STARTUP

    The database instance is restarted.

    See "About Instance Startup" for more information about when to use other STARTUP command options.