A Starting and Stopping an Oracle Database Instance

You may need to frequently stop and restart the database.

To start an Oracle Database Instance:

  1. From the Start button, select Programs, then Administrative Tools, then Services, and select OracleServiceDatabaseName where DatabaseName is the service_name of the database as indicated in the tnsnames.ora file. See "Configuring a NET Connect Alias" for further details.

  2. In the left panel, click the link to Start the service.

  3. The database services begin and the Start Database window appears. Do not proceed until you see this message: "OracleService service was started successfully".

To stop an Oracle Database Instance:

  1. From the Start button, select Programs, then Administrative Tools, then Services, and select OracleServiceDatabaseName.

  2. In the left panel, click the link to Stop the service.

  3. The database begins to shut down, showing the Stop Database window. Do not proceed until you see this message: "OracleService service was stopped successfully".