1. Installation Guide
  2. Getting Started with Oracle Database
  3. Starting and Stopping an Oracle Database

Starting and Stopping an Oracle Database

Describes about starting and stopping an Oracle database by using any of the following methods:

Starting and Stopping the Database with Oracle Administration Assistant for Windows

Use this procedure to start or stop the database:

To start or stop the database:

  1. From the Start menu, select All Programs, then Oracle - HOMENAME, then Configuration and Migration Tools, and then Administrative Assistant for Windows.
  2. In the console window, expand the Oracle Administration Assistant for Windows tree structure.
  3. Under Databases, right-click the name of the database, and from the menu, select from the following options:

    • Connect Database

    • Start Service

    • Disconnect Database

    • Stop Service

    • Startup/Shutdown Options

    • Process Information

Starting and Stopping the Database from the Microsoft Windows Services Utility

You can use SQL or srvctl utility to start or stop the database instance. SRVCTL starts the service automatically.

To use SQL to start the database instance, start the Windows services:

  1. From the Start menu, select All Programs, then Administrative Tools, and then Services.
  2. In the Services dialog box, locate the name of the database you want to start or stop.
  3. Right-click the name of the database, and from the menu, select either Start, Stop, or Pause.

    To set its startup properties, right-click Properties, and in the dialog box, select either Automatic, Manual, or Disabled from the Startup type list.