Start & Stop Oracle Database: Quick Guide

1 year ago
Jackson Davis
1 minute

Start the Oracle database instance.

  1. Open the command line window or terminal.
  2. Enter the following command to start the Oracle database instance:
sqlplus / as sysdba
startup
  1. To check the status of the database instance, wait for it to finish starting up and then use the following command.
select status from v$instance;

Stop the Oracle database instance.

  1. Open a command prompt window or terminal.
  2. Enter the command to stop the Oracle database instance.
sqlplus / as sysdba
shutdown
  1. To check the status of the database instance, wait for it to be fully closed and then use the following command.
select status from v$instance;

Please make sure to save all data and ensure no users are performing important operations before stopping the database instance.

bannerAds